Parallel Data Warehouse (PDW) Performance Tip: CTAS vs INSERT SELECT

When loading tables in Microsoft’s Parallel Data Warehouse (PDW) via T-SQL, one will soon encounter the need to load data...

SQL Saturday #145 Nashville – Recap

This month has been wild. I’ve been out of town quite a bit for work, and started the month with...

Using SQL Server 2012 FileTables

Reblogged from Basit's SQL Server Tips:

SQL Server 2012 allows you to store file/directories in a special table called FileTable that...

Database Design Contest at the 2012 AITP Region 3 Student Conference

Had a great Friday in Lafayette, LA on the campus of the University of Louisiana-Lafayette.  31 different teams submitted database...

SQL Server # TSQL to Convert STRING in PROPER format

Problem Statement
SQL Server has got in-built functions to convert the given string into LOWER() or UPPER() format but it does...

When a Covering Index no longer covers

I received an email from my boss on the morning supervisors approve timesheets. He stated that they are complaining about...

CSSUG Oct2012 - My Session Presentations and Scripts Are Available Here

Chennai SQL Serve User Group Meet for Oct'2012 happend today at Microsoft Traning Centre located in Radhakrishnan Road, Chennai.

Its pleasure seeing enthusiastic...

Presentation DAC: PowerShell: Automating SQL Stats Collection for Performance Tuning

Presentation DAC: PowerShell: Automating SQL Stats Collection for Performance Tuning

The San Francisco SQL Server User Group – Oct 10 2012 Thanks you everyone for attending session, here is the presentation...

Presentation DAC: PowerShell: Automating SQL Stats Collection for Performance Tuning

The San Francisco SQL Server User Group – Oct 10 2012 Thanks you everyone for attending session, here is the presentation...