Error 1702, CREATE TABLE failed, happens when a table goes past the 1024 column limit in SQL Server 2000. The fix is to cut the columns to 1,024 or fewer.
SQL SERVER – DBCC Commands Introduced in SQL Server 2005
SQL Server 2005 introduced two documented and five undocumented DBCC Commands, such as freesessioncache and requeststats. Here is the list with their syntax.
SQL SERVER – Fix: Server: Msg 7391, Level 16, State 1, Line 1
Msg 7391 has no single fix. I list the causes I have hit on my servers, from distributed transactions on linked servers to DTC firewall settings, to try one by one.
SQL SERVER – Fix : Error 701 There is insufficient system memory to run this query
For Error 701, insufficient system memory, compare max server memory with min server memory, check the paging file size, and free caches with DBCC commands.
SQL SERVER – Stored Procedure – Clean Cache and Clean Buffer
DBCC FREEPROCCACHE will invalidate all stored procedure plans that the optimizer has cached in memory. Let us learn how to clean cache.
SQL SERVER – SQL Commandments – Suggestions, Tips, Tricks
My 20 SQL Commandments for SQL Server, rewritten from an Oracle article: know your data, test with realistic data, write identical statements, and more tips.
SQL SERVER – DBCC command to RESEED Table Identity Value – Reset Table Identity
DBCC CHECKIDENT with RESEED lets you reset table identity to any value. Reseed to 0 so the next insert gets 1, and never go below values already in the table.