SQL Server 2012 Diagnostic Information Queries (Dec 2012)
Here is the December 2012 version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements...
2012-12-28
1,003 reads
Here is the December 2012 version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements...
2012-12-28
1,003 reads
2012-12-28
15 reads
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2012-12-28
1,122 reads
Last week, I presented on extended events at the Minnesota SQL Server user group (PASSMN). The turnout was quite excellent...
2012-12-28
747 reads
Last week I mentioned that I had put up a few new versions of my index analysis script. Turns out...
2012-12-28
716 reads
If you blog and call yourself a blogger then you probably have a pretty full RSS reader. Mine has been...
2012-12-28
941 reads
Microsoft today announced the latest round of SQL Server Cumulative Updates
SQL Server 2012 CU 5 – You can get more information...
2012-12-28
840 reads
This is a guest post by David Postlethwaite.
I’ve been wondering how to do this for years. At SQL Bits and...
2012-12-28
1,059 reads
With the upcoming PASS Business Analytics Conference, it only makes sense for there to be a 24 Hours of PASS...
2012-12-27
1,144 reads
Last Friday I went for a quick run before we packed up and headed to Steamboat Springs for a week’s...
2012-12-27
1,793 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...
Telp/Wa 62817825533 Jl. Dr. Soetomo No.118, Darmo, Kec. Wonokromo, Surabaya, Jawa Timur 60241
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
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