SQL Server: All About SQL Server Statistics : Consolidated post
Statistics is the one of the important factor which helps the optimizer to choose the right execution plan.At the same time, many of us (so called DBA) will not...
2013-07-11
57 reads
Statistics is the one of the important factor which helps the optimizer to choose the right execution plan.At the same time, many of us (so called DBA) will not...
2013-07-11
57 reads
Statistics is the one of the important factor which helps the optimizer to choose the right execution plan.At the same...
2013-07-10
979 reads
Building Connectors Is Crap in SSIS – Updated
What else can I say. I finally broke when I had to build a...
2013-07-10
1,955 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-10
1,680 reads
I ran into this with a client last night when trying to restore their SQL Server data warehouse database from...
2013-07-10
2,512 reads
Columnstore index is the new type of index introduced in SQL Server 2012. It is a column based non-clustered index...
2013-07-10
840 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-10
607 reads
Back when I was trying to start a business and unknowingly heading towards a economic cliff, I read all sorts...
2013-07-10
597 reads
Sometimes you detach databases, or you delete a database which is in restoring status, the data and log file will...
2013-07-09
2,369 reads
Multi Server script to find OS and Memory details. It doesn’t require a text file as its input but you...
2013-07-09
918 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