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 […]
Back To Basics: The RECEIVE command (and END CONVERSATION)
The RECEIVE command is the last of the Service Broker items to cover in the Back To Basics series. The RECEIVE command is what is used to actually get the message out of the queue so that you can process the data within the message_body column. The RECEIVE command works just like the SELECT statement […]