Docker images for custom SQL Server Installations
I no longer install SQL Server on my workstation, I use Docker to spin up instances as and when I...
2017-08-22
1,834 reads
I no longer install SQL Server on my workstation, I use Docker to spin up instances as and when I...
2017-08-22
1,834 reads
Unexpected SQL Server Performance Killers #3
Watch this week's video on YouTube
In this series I explore scenarios that hurt SQL Server performance and show you how to avoid them. Pulled...
2017-08-22
42 reads
Capturing query execution metrics is much easier now that you can see the runtime metrics in execution plans when you’re...
2017-08-22
262 reads
Capturing query execution metrics is much easier now that you can see the runtime metrics in execution plans when you’re...
2017-09-06 (first published: 2017-08-22)
1,619 reads
I thought I’d do another chess puzzle this month. This one is a variant on the Eight Queens problem:
SQL Puzzle...
2017-09-01 (first published: 2017-08-22)
2,358 reads
I am so excited to be helping out with SQL Saturday Charlotte again this year. This is the 6th year...
2017-08-22
415 reads
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2017-08-22
241 reads
One of the more common questions I find in SQL Server SSIS forums is how to split apart a single...
2017-08-22
493 reads
In the previous posts I posted some questions that I usually get when we talk about getting certified with SQL Server also listed some resources you can use to...
2017-08-21
20 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-08-21
506 reads
This is my late response to T-SQL Tuesday #204. I almost always forget about...
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...
Has anyone ever seen this before? I have sysadmin permission on a server. I...
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...
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