Build database schema snapshot functionality into your .NET application
If you wish to build your own .NET application that allows the user to take database schema snapshots on demand...
2016-04-12
203 reads
If you wish to build your own .NET application that allows the user to take database schema snapshots on demand...
2016-04-12
203 reads
The ALTER TABLE..SWITCH command allows you to almost instantly move large amounts of data from one table to another. It does...
2016-04-20 (first published: 2016-04-12)
4,196 reads
I love getting get a laptop, but getting all the software reinstalled and making sure everything works can be trying....
2016-04-12
351 reads
This month is an interesting, but tough topic. The blog party is hosted by Jens Vestergaard, and his invitation is...
2016-04-12
744 reads
If you are a SQL Server professional and are interested in spending a day with a bunch of other like-minded...
2016-04-12
400 reads
Ever wanted to look at a query’s actual execution plan (execution plan with runtime information) without waiting for the query...
2016-04-12
226 reads
Ever wanted to look at a query’s actual execution plan (execution plan with runtime information) without waiting for the query...
2016-04-12
557 reads
Blog post #4 in support of Tim Ford’s (b|t) #iwanttohelp, #entrylevel
In SQL Server, in the T-SQL you use to query...
2016-04-19 (first published: 2016-04-12)
3,144 reads
Posting here mostly because I’ll need this link again sooner or later! We’re hosting our more or less annual joint...
2016-04-12
546 reads
This post is part of a series on this blog that will explore SQL Server Service Broker, a native messaging and queueing technology built into the SQL Server Database...
2016-04-12
156 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...
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