SQL Server SELECT

GROUP BY and DISTINCT can return the same results when looking for uniqueness in a resultset. Consider the Sales table below. Store     Pr...

A few things to keep in mind when deciding whether you want a unique index or constraint. 1) The index creation options other than FILLFAC...

Ever had to try to decipher SQL that was generated by a report writer or sql generation tool such as Cognos Framework Manager? How about try...

Here are a few hints if your extracting data from an Oracle database using SSIS. 1) Use Oracle 11g client. The 10g client has bugs around ...

Are you in a dev environment and by screwing around with large dml statements you've created a monsert log file that you need to truncat...

Sounds like a Colon Cleanse pitch no? Well it's not. One of the most important things you can do when performance tuning is to remembe...

I love the PIVOT and UNPIVOT commands. They have saved me a ton of time on quite a few projects. UNPIVOT especially, since many times when w...