Do you want me to tell you the truth or do you want me to tell you what you want to hear?
We live in a Dilbert age.
If you are a DBA and have worked in organizations of any size you are...
2013-09-28
1,760 reads
We live in a Dilbert age.
If you are a DBA and have worked in organizations of any size you are...
2013-09-28
1,760 reads
Here is the downloadable file with all my sample scripts and slidedeck from my SQL Admin Best Practices with DMV's presentation from...
2013-09-28
1,053 reads
I’m trying really hard to write a blog that goes over all the great #sqlpass interviews we’ve done, but work...
2013-09-27
1,278 reads
I’ve always been a fan of the feeling when I find an old blog post that’s got just the information...
2013-09-27
1,371 reads
We just received word of a bunch of new functionality over at Scott Guthrie’s blog. Not a lot of stuff...
2013-09-27
1,330 reads
I hope you were able to attend my free webinar on Understanding Microsoft Self-Service BI on September 26, 2013. If...
2013-09-26
1,361 reads
Last Monday, I presented a session for Pragmatic WorksTraining on the T’s on the Microsoft’s Parallel Data Warehouse. In the session,...
2013-09-26
1,601 reads
The last couple of months have shown that the hypervisor battles for bigger, faster, and smoother are still heated and...
2013-10-02 (first published: 2013-09-26)
2,450 reads
SQL Server 2014 has enhancements to two common database maintenance operations:Partition Switching and Online Index Rebuild. This will greatly increase...
2013-09-26
1,239 reads
I’ve already made my own intentions clear. I’m casting one of my votes for Allen Kinsel. But, I get three...
2013-09-26
760 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