Partitioning on a nullable column
tl;dr; If you are SWITCHing data into a table and the partitioning column is nullable you will need to add...
2017-05-17 (first published: 2017-05-03)
2,144 reads
tl;dr; If you are SWITCHing data into a table and the partitioning column is nullable you will need to add...
2017-05-17 (first published: 2017-05-03)
2,144 reads
CROSS APPLY was introducted as part of TSQL in SQL Server 2005. Origionally it was created as a way to...
2017-05-03
55 reads
In this video, I show how to enable live query statistics in SQL Server 2016 in order to see execution...
2017-05-15 (first published: 2017-05-03)
1,280 reads
I have been developing software from my early teens and stayed with technology after leaving school. Initially focussing on software development, networking and IT support type roles, I found...
2017-05-03
52 reads
Back in 2010 I was inspired by a twitter conversation between Nicolas Cain (blog | twitter) and Dave Levy (blog | twitter) about checking Disk Space & Mount Points...
2017-05-03
24 reads
Back in 2010 I was inspired by a twitter conversation between Nicolas Cain (blog | twitter) and Dave Levy (blog | twitter) about checking Disk Space & Mount Points...
2017-05-03
20 reads
Back in 2010 I was inspired by a twitter conversation between Nicolas Cain (blog | twitter) and Dave Levy (blog | twitter) about checking Disk Space & Mount Points...
2017-05-03
25 reads
Back in 2010 I was inspired by a twitter conversation between Nicolas Cain (blog | twitter) and Dave Levy (blog | twitter)...
2017-05-03
993 reads
I’ve had another presentation added for the 24 Hours of PASS; this one is the first session of the line-up,...
2017-05-02
384 reads
How many times have you written a program, ETL, analysis job, etc… that seemed like it would never finish running?
Although poor performance can be caused in a multitude of...
2017-05-02
39 reads
By Steve Jones
I was experimenting with CHOOSE() recently after I was asked a question. In a...
By DesertDBA
I did not expect 27 responses to my T-SQL Tuesday #204 invitation, but it...
Should you adopt an off-the-shelf AI tool, partner with a specialist, build in-house, or...
Comments posted to this topic are about the item Switching Schema II
Comments posted to this topic are about the item A Practical Approach to Automating...
Comments posted to this topic are about the item Data Lost in the Cloud
I run this query:
SELECT s.name AS schemaname , o.name AS objectname FROM sys.objects o INNER JOIN sys.schemas s ON s.schema_id = o.schema_id WHERE o.name = 'Beer'I get two rows back for the objects, named dbo.beer and etl.beer. Both the tables have identical schemas and are not partitioned. There are 25 rows in dbo.beer and 0 rows in etl.beer. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers