Using batching to do large operations without filling the transaction log
Deleting large amounts of data from a table is usually an important task, but if you don’t have a maintenance window to work within then you can end up causing locking and blocking against the other processes which are accessing the database. Not to mention you will cause a very large amount of data into […]
Using batching to do large operations without filling the transaction log
Deleting large amounts of data from a table is usually an important task, but if you don’t have a maintenance window to work within then you can end up causing locking and blocking against the other processes which are accessing the database. Not to mention you will cause a very large amount of data into […]
My Experience with putting a CRL Procedure into SQL
We are looking at how to create a C# method which can then be attached to the SQL Server as a stored procedure and called. To make it a little cooler we are passing data into the procedure and having the C# method return the data through an output parameter.
SQL 2008 RC0 Intellisense doesn’t work against SQL 2005
I’ve been working with SQL 2008 RC0 for a couple of weeks now, and something I’ve noticed that really sucks. The Intellisense doesn’t work against a SQL 2005 server any more. I’ve been using the SQL 2008 UI exclusively for several months now (since the November CTP at least) and I’ve gotten quite used to […]