No announcements
Found 1498982 threads
-
0 VotesFind unused databases
Other databases on the same instance returns proper values.Answered | 8 Replies | 6832 Views | Created by MnMkeyviwel - Tuesday, August 27, 2013 8:18 AM | Last reply by MnMkeyviwel - Monday, September 2, 2013 11:43 PM
-
0 Votes
Finding unused databases
Dear Experts, I came across this query below from ...Answered | 2 Replies | 1014 Views | Created by MnMkeyviwel - Thursday, August 21, 2014 4:07 AM | Last reply by Satheesh Variath - Thursday, August 21, 2014 4:25 AM -
1 Votes
How to find unused tables
For tables, you would have to take a snapshot of the database (backup db, restore it as copyofdb) and do a compare a month later for example with a tool like SQL Data Compare.Answered | 3 Replies | 4377 Views | Created by KKKKKKKKKKKK1234 - Thursday, December 3, 2009 8:46 AM | Last reply by Krishna Rajeesh - Thursday, December 3, 2009 9:52 AM -
1 Votes
How to find unused logins?
Siva, There is no way to find unused logins.Answered | 2 Replies | 1784 Views | Created by SivaReddyG - Tuesday, March 4, 2014 2:45 PM | Last reply by Prashanth Jayaram - Tuesday, March 4, 2014 3:14 PM -
0 Votes
Finding unused XAML
There is a tool: http://www.kopf.com.br/kaplof/removing-unused-styles-from-silverlight-projects Rgds,Answered | 8 Replies | 12973 Views | Created by nickbaker77 - Wednesday, May 27, 2009 1:51 PM | Last reply by bmarotta - Tuesday, September 24, 2013 5:13 PM -
0 Votes
To find Unused detached files
Even if it was an Enterprise Edition installation of SQL where the database files are locked when they are actively open by SQL Server, I would caution against deleting any ...Answered | 6 Replies | 8244 Views | Created by DBA_LEARNER - Monday, January 31, 2011 11:17 PM | Last reply by xs2varun - Monday, February 7, 2011 10:02 PM -
0 Votes
How to find unused stored Procedures in a server
Unfortunately There is no direct method to find unused sps in a DB.Answered | 3 Replies | 10920 Views | Created by MSK38653 - Sunday, July 3, 2011 1:56 PM | Last reply by Siva1983 - Monday, July 4, 2011 12:03 PM -
0 Votes
finding unused storeprocedures in sql server
to find "unused" databases you will need to set up a separate process.Answered | 6 Replies | 1485 Views | Created by knewsql - Tuesday, January 5, 2016 2:08 PM | Last reply by Anthony C-UK - Tuesday, January 5, 2016 4:45 PM -
0 Votes
how to find how much space is used/unused on database?
Is there a script or stored proc that can check database usage, used/unused.Answered | 1 Replies | 2268 Views | Created by alexsql - Friday, June 22, 2012 5:56 PM | Last reply by Chuck Pedretti - Friday, June 22, 2012 5:57 PM -
0 Votes
finding unused softwares in windows 8.1
Dear team, i am using windows 8.1, my "C:" Drive is almost full. i want to uninstall the unused Software but i am ...Answered | 1 Replies | 1206 Views | Created by mann madhan1 - Wednesday, August 5, 2015 1:39 PM | Last reply by Just Karl - Thursday, September 3, 2015 7:24 PM -
1 Votes
Find unused Storage Accounts
There you will find the storage account information.Answered | 3 Replies | 4988 Views | Created by Harjit Samra - Thursday, November 24, 2016 3:38 PM | Last reply by Harjit Samra - Friday, November 25, 2016 1:50 PM -
0 Votes
T-SQL for finding the unused tables which are consuming maximum disk space.
see http://www.mssqltips.com/sqlservertip/1177/determining-space-used-for-each-table-in-a-sql-server-database/ Please Mark This As Answer if it helps to solve the ...Answered | 5 Replies | 1226 Views | Created by Leon D'silva - Thursday, May 8, 2014 12:06 PM | Last reply by Prashanth Jayaram - Thursday, May 8, 2014 2:48 PM -
1 Votes
finding unused tables and other DB objects
if this is huge database you will still drill down to script.Answered | 13 Replies | 5114 Views | Created by skc_chat - Thursday, December 22, 2011 7:45 AM | Last reply by REY - Singh - Monday, December 26, 2011 8:42 AM -
0 Votes
Question about unallocated space and unused space in a database
Please refer the below links: Understanding Pages and Extents DBCC SHRINKFILE And ...Answered | 2 Replies | 9687 Views | Created by Kinect Fan - Saturday, December 4, 2010 6:27 AM | Last reply by WeiLin Qiao - Wednesday, December 8, 2010 1:44 AM -
0 Votes
Find unused term sets in SP Online tenant
Hi, You can mark yourself post as answer to help other community members to find the information quickly.Answered | 6 Replies | 1150 Views | Created by Gubendra Raj Madivaanan - Thursday, February 8, 2018 4:43 PM | Last reply by Carl__Zhou - Tuesday, February 27, 2018 4:43 AM -
0 Votes
How to find the list of unused stored procedures in SQL Server 2005?
If you use T-SQL stored procedures, you can get all SPs in the current SQL Server 2005 database by using sys.procedures.Answered | 8 Replies | 6796 Views | Created by Kishore Thupakula TechM - Friday, March 14, 2014 7:09 AM | Last reply by SQLZealots - Thursday, March 27, 2014 7:03 AM -
8 Votes
SharePoint - PowerShell - List all databases in use (ignore unused DBs)
Hi, Gets a list of all the databases currently used by SharePoint 2010 farm : Get-SPDatabase | Sort-Object Name | Format-Table ...Answered | 2 Replies | 45267 Views | Created by ran009 - Tuesday, January 29, 2013 12:43 AM | Last reply by Fadi Abdulwahab - Tuesday, January 29, 2013 5:57 AM -
0 Votes
scripts to find out “Unused Indexes, Duplicate indexes and Recommended Indexes” for a server across all databases
Hope its helps http://blog.sqlauthority.com/2011/01/04/sql-server-2008-unused-index-script-download/ -- Missing Indexes for all ...Answered | 2 Replies | 2003 Views | Created by nrajeshkumars - Friday, June 17, 2016 9:06 AM | Last reply by PankajR - Friday, June 17, 2016 10:02 AM -
0 Votes
Unused Index
In addition, whenever a database is detached or is shut down (for example, because AUTO_CLOSE is set to ON), all rows associated with the database are removed.Answered | 3 Replies | 5252 Views | Created by SunitaA - Tuesday, May 24, 2011 9:56 AM | Last reply by Sorna Kumar Muthuraj - Tuesday, May 24, 2011 11:29 AM -
1 Votes
Help: Why the "unused" in "hInstLibrary = 0x10000000 {unused=9460301 }"?
That's because HWND is defined as following in Windows SDK struct HWND__ { int ...Answered | 2 Replies | 8027 Views | Created by Lou-In-Ottawa - Saturday, October 2, 2010 7:11 PM | Last reply by Sheng Jiang 蒋晟 - Saturday, October 2, 2010 7:52 PM - Items 1 to 20 of 1498982 Next ›
No announcements
