if exists(select * from sys.views v join sys.schemas s on v.schema_id = s.schema_id where s.name = 'dbo' and v.name = 'OrderLineItems') drop view dbo.OrderLineItems ...

Developers working with SQL Server often treat indexing as a DBA's domain--something happening "under the hood" that doesn't require much attention unless performance takes a hit. But ignoring the ...

;with N1(C) as (select 0 union all select 0) -- 2 rows ,N2(C) as (select 0 from N1 as T1 CROSS JOIN N1 as T2) -- 4 rows ,N3(C) as (select 0 from N2 as T1 CROSS JOIN N2 as T2) -- 16 rows ,N4(C) as ...

Described as an advanced course designed for advanced SQL Server professionals, the course will feature detailed demonstrations of SQL Server internals, as well as tuning techniques, utilizing SQL ...

I made the long trek across the country this week to attend my favorite conference, the SQL PASS Community Summit, this year in Seattle, and so far it’s been well worth it. I usually arrive early to ...