Chad Boyd - All Comments

Estimating Data Compression ratios for all...

Chad Boyd — Mon, 22 Sep 2008 22:41:38 GMT

One of my favorite features with SQL 2008 has been Data and Backup compression (which I discuss in more

MERGE statement syntax modified

Michael Zilberstein — Tue, 16 Sep 2008 18:03:38 GMT

This is probably known to all but I've just found out - MERGE command syntax had been modified since

re: Automate a Database Restore

primer200 — Wed, 20 Aug 2008 04:18:04 GMT

Great post!

Most of the times we require restore a database to another server to a point in time. All we know is the orginal server name, database name, the target server name, target database name, the file path for mdf and ldf files on the target server and a point in time.

In this case we need first query the msdb of the original server to get a list of files and its location required to restore to the point in time. If you can include this, I rekon the sp is even more useful. I have done this myself, but I I had to use some ugly coding such as cmdshell.

Link Listing - July 29, 2008

Christopher Steen — Wed, 30 Jul 2008 13:49:17 GMT

Sharepoint Silverlight Drag, Drop, Import and Export [Via: Michael Washington ] Creating a WSS / MOSS...

Link Listing - July 29, 2008

Christopher Steen — Wed, 30 Jul 2008 13:48:38 GMT

Link Listing - July 29, 2008

re: SERIALIZABLE isolation level (serialized transactions) and duplicate key insertion attempts

aprato — Wed, 09 Jul 2008 03:35:52 GMT

Nice, Chad!

The blocking behavior is something I've seen before and it makes sense if you think about it. The lock manager doesn't know what you'll ultimately be doing with all the rows locked in the range... you could be deleting them all for all it knows.

PS: I tried to give your article a 5 star rating but my fat, flabby, sausage-like fingers mis-clicked

My interested stuff(2008-07-02)

代码乱了 — Sat, 05 Jul 2008 02:10:06 GMT

BTDex-EasystringcompressionandencryptionJamesAvery-JulyLoungeUpdateandCheckingyourS...

Link Listing - June 30, 2008

Christopher Steen — Tue, 01 Jul 2008 10:25:55 GMT

ASP.NET How to use the IHttpAsyncHandler in ASP.NET [Via: Mads Kristensen ] SQL Server SQL SERVER -...

Link Listing - June 30, 2008

Christopher Steen — Tue, 01 Jul 2008 10:25:27 GMT

Link Listing - June 30, 2008

Installing Clustered SQL Servers - Outline, Checklists, Document Sheets

Chad Boyd — Mon, 30 Jun 2008 06:01:35 GMT