When and How to Shrink Your Database
Most DBAs know that shrinking a database is a bad thing. But in many cases, there is no DBA around,...
2013-08-01
637 reads
Most DBAs know that shrinking a database is a bad thing. But in many cases, there is no DBA around,...
2013-08-01
637 reads
What I’m going to show you is not rocket science. This one gets filed under the category of “well, duh. ...
2013-08-01
801 reads
This part of the review is still a part of the topic Maintain Instances and Databases which accounts for 17%...
2013-08-01
635 reads
Hello Dear Reader! Another very quick blog. Thank you to all of the people that tuned in to see me...
2013-07-31
1,166 reads
Over the years when a performance problem comes up there is always some speculation that it’s a network issue and...
2013-07-31
1,193 reads
Hello Dear Reader! This is just a very quick blog to let you know that the 24 Hour's of PASS...
2013-07-31
1,372 reads
SSIS is one of those tools that I love and hate at the same time. It’s a great ETL tool...
2013-08-05 (first published: 2013-07-31)
2,757 reads
Join SQL Server professionals from around the world for free online technical training and networking year round. PASS Virtual Chapters...
2013-07-31
1,351 reads
PASS SQL Saturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Please...
2013-07-31
1,328 reads
Reblogged from TechCrunch: Nobody has ever accused Amazon Web Services of hiding its complexities. It seems even Amazon acknowledges that...
2013-07-31
1,389 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