Video: Designing Stored Procedure Solutions
My new session for 2014, “Designing Stored Procedure Solutions”, is now up on the Sessions page: abstract, video, and code!...
2014-04-28
1,243 reads
My new session for 2014, “Designing Stored Procedure Solutions”, is now up on the Sessions page: abstract, video, and code!...
2014-04-28
1,243 reads
Sean and I will be speaking at SQL Saturday Houston on May 10, at San Jacinto College – South Campus 13735...
2014-04-14
651 reads
“An encryption flaw called the Heartbleed bug is already being called one of the biggest security threats the Internet has...
2014-04-10
709 reads
If I’ve said it once, I’ve said it 1,024 times: your SQL data and log drives need a 1024 KB...
2014-04-07
1,504 reads
We’ve talked before about how to get log space usage information in SQL Server. After the 1,032nd time I re-wrote...
2014-03-31
1,264 reads
We’ll be at OKC this summer for their SQL Saturday on August 23, and we’re presenting our precon “Becoming an...
2014-03-26
617 reads
The problem with the PASS Summit session submissions process is that people don’t know why they’re rejected. So say we...
2014-03-26 (first published: 2014-03-19)
1,445 reads
In celebration of the impending SQL Server 2014 release, and in recognition that a large percentage of my clients are...
2014-03-24
1,074 reads
InfoWorld Magazine (http://www.InfoWorld.com) has published a new article by MidnightSQL owner Sean McCown, “Review: SQL Server 2014 pushes the pedal...
2014-03-20
723 reads
Today, MSDN and TechNet are reporting that SQL Server 2014 will be available on April 1, 2014. Thanks to @MariaZakourdaev, who posted...
2014-03-18
826 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