Presentation Materials “Discovering the Plan Cache” #SQLSat211
Just got done with my morning session, titled ”Discovering the Plan Cache“, for SQL Saturday Chicago #211 and wanted to get...
2013-04-13
449 reads
Just got done with my morning session, titled ”Discovering the Plan Cache“, for SQL Saturday Chicago #211 and wanted to get...
2013-04-13
449 reads
I’ve been looking for better ways of learning and improving my SQL Server skills. Blogs, BOL, webcasts, and training videos...
2013-04-13
741 reads
Do It In Bulk
I usually don’t run queries on just one server. Most of the time I need to get...
2013-04-12
1,278 reads
First, I would like to thank everyone for joining my webcasts today. Very much appreciated. Secondly, I would like to...
2013-04-12
1,045 reads
If IDENTITY insert is disabled or simply not available in a particular database or a database architecture, you’ll want to do a table based surrogate key assignment or use...
2013-04-12
55 reads
If IDENTITY insert is disabled or simply not available in a particular database or a database architecture, you’ll want to...
2013-04-12
963 reads
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-04-12
408 reads
This was the second SQL Saturday hosted in Omaha. I loved to see how the event grew from the first...
2013-04-12
486 reads
Hello Dear Reader! I was teaching a class in Chicago last week and I got a lot of really great...
2013-04-12
1,147 reads
Last time I posted about How you can add date/time to output file name, in which I used xp_cmdshell to...
2013-04-12
2,379 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