SQL Server SELECT

Prior to SQL Server 2005, the value in the TOP clause was limited to literal values which meant that variables could not be used. Hence, the...

While written for SQL Server 2005 and a little out of date for SQL Server 2008, The Microsoft Data Warehouse Toolkit: With SQL Server200...

I recently conducted technical interviews for one of my clients to help find a mid-level SQL Server BI developer. Below are the questions I ...

During an interview today I asked a candidate if she had experience using SSIS Checkpoint functionality . Although I haven't confirmed w...

I was just troubleshooting a long-running query that happened to be an UPDATE statement and found that a Clustered Index Update operation wa...