DBCC Commands or Database Consistency Checker commands have been with SQL Server from its early ages itself. In this article we would list the available DBCC commands listed using the DBCC Help command. Many in this list are undocumented and are rarely used in practical scenarios. But these for...
Following is part 1 of a list of fixes and other various improvements that have been made in Service Pack 1 (SP1) for Microsoft SQL Server 2000. For more information, contact your primary support provider. For additional listings, click the article numbers below to view the articles in the ...
Following is part 1 of a list of fixes and other various improvements that have been made in Service Pack 1 (SP1) for Microsoft SQL Server 2000. For more information, contact your primary support provider. For additional listings, click the article numbers below to view the articles in the ...
What version of SQL Server do I have?This unofficial build chart lists all of the known Service Packs (SP), Cumulative Updates (CU), patches, hotfixes and other builds of MS SQL Server 2016, 2014, 2012, 2008 R2, 2008, 2005, 2000, 7.0, 6.5 and 6.0 that have been released....
You can comment here. If you know of a hotfix build or KB that we don't have listed here, please use the comments. Microsoft SQL Server 2014 Builds Microsoft SQL Server 2012 Builds Microsoft SQL Server 2008 R2 Builds ...
Always clear caches when you measure a statement.To make sure that Microsoft SQL Server isn't using a cached execution plan, it's advisable that you flush the cache when you rerun a statement. To flush the cache, run the following two commands: ...
DBCC SQLPERF(LOGSPACE) will show me a list of the databases and how much logspace each is using etc.Is there anything similar to this except for the databases themselves, and their data files?sp_spaceused is for a single database.All replies (7)...
10.0.5867.0 2007.100.5867.0 2877204 FIX: Error 8985 when you run the "dbcc shrinkfile" statement by using the logical name of a file in SQL Server 2008 R2 or SQL Server 2008 2014-07-02 10.0.5861.0 2007.100.5861.0 2958696 Cumulative update package 17 (CU17) for SQL Server 2008 Service Pack...
722778 When executing DBCC CHECKSTORAGE, the worker processes created show the current database name, instead of tempdb, in the 'tempdbname' section of sp_who output. See KBA 2119852. 725677 A 3250 error, "The devices < device name > and < device name > specified in the command should ...
Retrieves the set of firewall rules for an Azure SQL Database Server. 重要 The recommended REST commands to work with SQL Database are the Resource Manager based Azure SQL Database REST API. While there is no change to SQL Database, be aware that the classic deployment model command in ...