Working with the registry from within SQL Server
There is a lot of information within the Windows registry. Sometimes, it would sure be nice to work with the...
2017-08-30 (first published: 2017-08-16)
3,825 reads
There is a lot of information within the Windows registry. Sometimes, it would sure be nice to work with the...
2017-08-30 (first published: 2017-08-16)
3,825 reads
For the longest time, MySQL has been the recommended database platform for blogs and other websites. It’s free. It’s available...
2017-08-16
167 reads
If you do – shame on you and shame on me because I do.
Moving on, I found strange behaviour within SQL...
2017-08-16
395 reads
Now that SSDT (SQL Server Data Tools) has been installed the next step is to create a project. First, open...
2017-08-30 (first published: 2017-08-16)
1,903 reads
It’s Wednesday and that means another SQL/Oracle post. Today we’ll be discussing NULL Values, which can sometimes be a real...
2017-08-28 (first published: 2017-08-16)
9,478 reads
Last week I presented my session on SQL Server & Containers for the PASS Virtualization Group and during my prep I...
2017-08-28 (first published: 2017-08-16)
2,980 reads
Welcome back, everyone. In the previous post in this series, I explained how to work within the new SQLCLR security...
2017-08-16
725 reads
As a developer, I’ve been a big fan of multiple monitors for a long time. I moved to a triple...
2017-08-15
271 reads
Watch this week's video on YouTube
How many times have you had to transform some column value and ended up stacking several nested SQL REPLACE() functions like this?
-- Input: Red,...
2017-08-15
24 reads
This post demonstrates one of the ways to gather an inventory of database backup information. The output of the script...
2017-08-15
451 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