Awarded Microsoft MVP
Today I’m extremely excited, honored and humbled to announce that I have been recognized as a Microsoft MVP for first...
2013-10-01
704 reads
Today I’m extremely excited, honored and humbled to announce that I have been recognized as a Microsoft MVP for first...
2013-10-01
704 reads
I received an email from a nice chap recently, concerning a subject that I’m often asked about and I wanted to share my thoughts with you here. Since I only...
2013-10-01
44 reads
I received an email from a nice chap recently, concerning a subject that I’m often asked about and I wanted...
2013-10-01
1,189 reads
This post explains how to monitor DiskSpace of a group of listed servers in a text file.
The function Get-DiskSpaceReport comprises...
2013-10-01
4,413 reads
After over 6 months of silence, it is time again for another Stupid me™®©! For those unfamiliar with the concept:
Every...
2013-10-01
371 reads
After over 6 months of silence, it is time again for another Stupid me™®©! For those unfamiliar with the concept:
Every...
2013-10-01
657 reads
In our earlier post, we have discussed in detail about the architecture of the data file and different types of pages. In this post, we will be discussing about...
2013-10-01
200 reads
Server evaluations are a major part of my consulting business. I need to get up to speed very quickly on...
2013-09-30
1,270 reads
In our earlier post, we have discussed in detail about the architecture of the data file and different types of...
2013-09-30
10,031 reads
I must admit… Denver is my favorite town in this country. The outdoor things to do, the wide variety of...
2013-09-30
1,273 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