SQL Server Indexing Book Giveaway – Week 3
In past two weeks’ posts (1, 2) I talked about how I’ve got a few copies of Expert Performance Indexing for...
2016-06-17
732 reads
In past two weeks’ posts (1, 2) I talked about how I’ve got a few copies of Expert Performance Indexing for...
2016-06-17
732 reads
In this article I'll show you how to connect to SQL Azure database instance and create a simple database. First you have...
2016-06-17
350 reads
So I've had this tool around for a while, but never found much usage out of it to be honest....
2016-06-17
2,953 reads
Triggers can be very useful when you want to log changes to your data, but what if you’re only interested...
2016-06-22 (first published: 2016-06-16)
2,395 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2016-06-16
660 reads
Recently, I needed a query to identify tables that developers had create as point-in-time backups of tables that were never...
2016-06-23 (first published: 2016-06-16)
3,530 reads
Help! I backed up my database yesterday and the backup file was about 200MB but today it’s closer to 400!...
2016-06-16
633 reads
A few years back, Redgate Software released SQL Search. This was an internal project that became a free product we...
2016-06-21 (first published: 2016-06-15)
4,082 reads
That’s right. My way of giving back to the SQL Server community, I am presenting my first SQLSaturday session at the upcoming Louisville #531, Saturday, Aug. 6th, 2016. My...
2016-06-14
25 reads
That’s right. My way of giving back to the SQL Server community, I am presenting my first SQLSaturday session at...
2016-06-14
145 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