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
Defensive database programming: eliminating IF statements
Alexander Kuznetsov explains why the following logic can fail 40% of the time
IF EXISTS(some query) BEGIN
DO SOMETHING;
END
Automating Common DBA Tasks Complete Series
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
When constraint remains in system table even the table is no longer exists
Uri Dimant shows the problem with named constraints and temp tables
Advanced SQL Server 2005 Express Job Scheduling
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.
Getting rid of Instant File Initialization (or enabling it if that strikes your fancy)
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).
SQL Server and Cloud Links for the Week
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
*** If you have a SQL related question try our Microsoft SQL Server Programming forum or our Microsoft SQL Server Admin forum
Denis has been working with SQL Server since version 6.5. Although he worked as an ASP/JSP/ColdFusion developer before the dot com bust, he has been working exclusively as a database developer/architect since 2002. In addition to English, Denis is also fluent in Croatian and Dutch, but he can curse in many other languages and dialects (just ask the SQL optimizer) He lives in Princeton, NJ with his wife and three kids.
