Search Results | SQL Server Performance Forums

operating xml with nodes() method directly v.s. using temp table

Post by: mufford, Nov 14, 2008 in forum: SQL Server 2005 T-SQL Performance Tuning

To find out how much free space you have in tempdb, execute this command:Use tempdb; Go Execute sp_spaceused; If you do not have much unallocated...

Stored procedures

Post by: mufford, Nov 10, 2008 in forum: SQL Server 2005 Performance Tuning for DBAs

If you're looking for all stored procedures that reference the object, then maybe this will help. It does the same thing as sp_depends, but can be...

Select with NOLOCK

Post by: mufford, Nov 10, 2008 in forum: SQL Server 2005 General Developer Questions

I routinely use With (NoLock) hints whenever I can (i.e. dirty reads permitted). It's especially beneficial with very active OLTP databases and can...

operating xml with nodes() method directly v.s. using temp table

Post by: mufford, Nov 10, 2008 in forum: SQL Server 2005 T-SQL Performance Tuning

Hi davidshen84, I would recommend the use of a temporary table. You mentioned "tables"... if you're dumping this data into morethan one table, or...

Using loops to improve performance?

Post by: mufford, Nov 8, 2008 in forum: SQL Server 2005 T-SQL Performance Tuning

On a related note, I just finished posting a blog entry on a 70mm record update on a replicated table that I executed last night. The script is...

Using loops to improve performance?

Post by: mufford, Nov 7, 2008 in forum: SQL Server 2005 T-SQL Performance Tuning

Hi null, (I love your handle, btw!) As someone who has performed many batch updates on large data sets (100m+), I thought I'd share some of the...

Could not allocate space for object 'dbo.Large Object Storage System object

Post by: mufford, Nov 7, 2008 in forum: SQL Server 2005 T-SQL Performance Tuning

Great suggestions, Varsham! To expand on #3... If you're dumping data into a temporary table, performing some processes, and then deleting those...