24 Hours of PASS: Preview to Slicing and Dicing Summit Session and more…
For 24 Hours of PASS 2013 Summit preview (#24HOP – twitter hash tag), I was asked to give a preview of...
2013-07-12
747 reads
For 24 Hours of PASS 2013 Summit preview (#24HOP – twitter hash tag), I was asked to give a preview of...
2013-07-12
747 reads
It’s just two weeks until my next trip. It feels like I just got back from London, and one again...
2013-07-12
992 reads
MSSQLTIPS offers new webcast monthly. Topics in various areas of SQL Server are covered and perfect for all DBAs out...
2013-07-12
430 reads
I like to clean up things after I’m done with my testing and this morning I decided to clean up...
2013-07-11
1,999 reads
This PowerShell script helpful in finding No of Processors, Speed and It’s current usage based on samples being gathered at...
2013-07-11
1,675 reads
Test your restores: he first tip in my Hard Earned Lessons of a DBA piece.
I can’t emphasize this enough. I’ve...
2013-07-11
836 reads
FYI:
Geoflow (see Geoflow Preview for Excel 2013) is now called Power Map, and Data Explorer (see Microsoft Data Explorer) is now called...
2013-07-11
894 reads
As I mentioned in the introductory post, during the Introduction to SQL Server Security session for Pragmatic Work’sTraining on the T’s, I...
2013-07-11
574 reads
Reblogged from Glenn Berry's SQL Server Performance: I have gone through and made some minor updates and bug fixes for...
2013-07-11
361 reads
Scenario. You have a new SSIS server. All DTS packages migrated and deployed successfully to this new SSIS server. You send...
2013-07-11
355 reads
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...
By ReviewMyDB
Part 1 of my What's New in SQL Server for the Developer series. IIF,...
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