I decided to do a weekly post with the best SQL Server related links of the week. These are articles that I find useful and think that they also might be beneficial to you the reader.
Here we go
Kalen Delaney explains how to find the amount of space occupied by a worktable by using DMVs
Alexander Kuznetsov explains why the following logic can fail 40% of the time
IF EXISTS(some query) BEGIN
Jonathan Kehayias has posted a nice collection of code in this post, some of it is below
Configuring SQL Server 2000 Notification with CDOSys
Configuring SQL Server 2005⁄2008 Database Mail
Log file growth in SQL Server
Monitor free space in the database files
Monitor free space on the server hard disks
Monitor the SQL Server Error Log
Monitor long running SQL Agent Jobs
Monitor failed SQL Agent Jobs
Uri Dimant shows the problem with named constraints and temp tables
Mladen Prajdić writes how to schedule jobs in SQL Server 2005 Express
Michelle Ufford walks us through the basics of BCP (bulk copy program). BCP is a utility that installs with SQL Server and can assist with large data transfers.
Denny Cherry tells us about Instant File Initialization. This allows SQL Server to create files of any size without sitting there for minutes or hours (depending on the size of the files).
Why reinvent the wheel? Brent Ozar also has a bunch of links on his weekly link post
That is it for this week, I will tag the weekly posts with SQL Friday in case you want to see the whole archive in the future