Browse by Tags

KBA - UPDATE Statements May be Replicated as DELETE/INSERT Pairs & Diagnostics in SQL Server 2000 SP4 and in later versions help detect stalled and stuck I/O operations

Published 13 May 8 1:45 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications UPDATE Statements May be Replicated as DELETE...

Filed under: sql server, update, i/o, kba, insert, delete, statement, sp4

TSQL to findout blocking and locks on a SQL Server?

Published 7 December 7 1:8 PM | SSQA.net

Have you ever performed huge operations such as deleting records of a table and processing inserts on that table at the same time? This is a common task that every application will have to perform and you can avoid by fine tuning your queries (mostly...

Filed under: sql server, performance, indexes, blocking, security, insert, tsql, locks, deletes

FIX: Error message when you run the BULK INSERT statement in Microsoft SQL Server 2005: "The bulk load failed. The column is too long in the data file for row <n>, column <n>"

Published 7 October 7 7:30 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition, SQL Server 2005 Enterprise X64 Edition & SQL Server 2005 Enterprise Edition Notification Contents: New and All Modifications FIX...

Filed under: sql server, kba, error log, insert, column, bulk load

DBCC EXTENTINFO - unused pages in these extents (undocumented)

Published 4 September 7 7:45 AM | SSQA.net

When it comes to resolving table fragmentation, the basic checkout you perform is to run DBCC INDEXDEFRAG or even run DBCC DBREINDEX statements. As per the default configuraiton SQL Database Engine allocates a new extent to an allocation unit only when...

Filed under: sql server, performance, indexes, data, i/o, table, insert, allocation, fragmentation, deadlock, extent

FIX: The performance of insert operations against a table that contains an identity column may be slow in SQL Server 2005

Published 11 August 7 5:15 AM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise Edition Notification Contents: New and All Modifications FIX: The performance of insert operations against a table that contains an identity column...

Filed under: sql server, performance, database, kba, insert

FIX: You may receive error 1203 when you run an INSERT statement against a table that has an identity column in SQL Server 2005

Published 27 June 7 11:46 AM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications FIX: You may receive error 1203 when you run...

Filed under: sql server, kba, standard, edition, enterprise, x64, insert