T-SQL Tuesday #42: The Long and Winding Road
It’s the second Tuesday of the month, which means it’s time again for #TSQL2sday! It is the 42nd installment of...
2013-05-14
790 reads
It’s the second Tuesday of the month, which means it’s time again for #TSQL2sday! It is the 42nd installment of...
2013-05-14
790 reads
I now have a red, P85 Tesla Model S. I picked it up at the Denver Tesla Service Center on...
2013-05-14
1,341 reads
Sp_who2 is not used by this DBA. That info is amazingly good to have, but I want more. Don’t get...
2013-05-14
874 reads
Can you tell me the drive we were backing up server #58 to exactly 8 months ago, and, if possible,...
2013-05-14
434 reads
This script is so simple you’ll start off by asking why you’d ever use it. Then you’ll use it and...
2013-05-14
627 reads
There are two scripts I like to use to look at the file sizes on servers. The first one is...
2013-05-14
464 reads
We came across a scenario where database bak files being created from long time which are no more in use...
2013-05-17 (first published: 2013-05-13)
2,453 reads
SQL Server 2012 Reporting Services introduced Power View, which was initially available only in SharePoint. This limited the use of...
2013-05-16 (first published: 2013-05-13)
3,468 reads
For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of...
2013-05-13
670 reads
I like to know what’s on the drives that are supposed to be dedicated to data and log files. So I...
2013-05-13
1,090 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