There are seven common antipatterns in T-SQL coding that make code perform badly, and three good habits which will generally ensure that your code runs fast. If you learn nothing else from this list of great advice from Grant, just keep in mind that you should 'write for the optimizer'.
2012-08-29
7,758 reads
This article discusses and demonstrates AlwaysOn Availability groups in SQL Server 2012, a new feature for high availability.
2012-08-28
9,947 reads
Can I export images from SQL Server to a file in Windows? What SQL Server options are available to do so? Check out this tip to learn more.
2012-08-28
3,504 reads
A free day of training in Columbus, GA. Come meet the local SQL professionals and spend a day talking SQL Server.
2012-08-28 (first published: 2012-08-09)
2,187 reads
There is a lot of confusion amongst DBAs about using PowerShell due to existence the deprecated SQLPS mini-shell of SSMS and the newer SQLPS module. In a two-part article and wallchart, Michael Sorens explains how to install it, what it is, and some of the excellent things it has to offer.
2012-08-27
3,413 reads
This tip will look at how you can use triggers to replace the functionality you get from the ON DELETE CASCADE option of a foreign key constraint.
2012-08-24
2,441 reads
Adam Machanic is speaking at SQL in the City - Boston on Oct 8, 2012.
2012-08-24
1,488 reads
SQL Agent stores duration in HHMMSS format - not always useful. Discover how to use Powershell, some basic math, and T-SQL to tame these unruly values.
2012-08-23
3,828 reads
So how should you install and configure SQL Server 2012 properly? Glenn Berry completes his two-part series by explaining the steps needed to complete the preparation and do the actual installation.
2012-08-23
2,632 reads
The Row Number Transformation calculates a row number for each row, and adds this as a new output column to the data flow. The column number is a sequential number, based on a seed value. Each row receives the next number in the sequence, based on the defined increment value.
2012-08-22
4,217 reads
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
By Steve Jones
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
Alamat Kontak WA CS 08218154392 Jl. Ahmad Yani No.39 A, Rw1, Sidokumpul, Kec. Sidoarjo,...
Alamat Kontak WA CS 08218154392 Jl. Raya Kendangsari Industri No.2, Kendangsari, Kec. Tenggilis Mejoyo,...
In SQL Server 2025, I run this code:
select bit_count('A')
What is returned? See possible answers