T-SQL Tuesday #44 The Second Chance
Hello Dear Reader! This is the first Tuesday of the month and you know what that means. It’s time to...
2013-07-02
2,303 reads
Hello Dear Reader! This is the first Tuesday of the month and you know what that means. It’s time to...
2013-07-02
2,303 reads
SQL Server Data Tools (SSDT) has a new update:
VS 2010: June 2013 version: 10.3.30618.1, December 2012 version: 10.3.21208.0, November 2012 version:...
2013-07-02
2,127 reads
Today I got a chance to retrieve configuration information of sql server 2005 instances. PowerShell provide a facility to read...
2013-07-02
1,150 reads
Recently we observed a weird issue with SSRS export to Excel. One of the datetime column in the report was...
2013-07-02
1,997 reads
Hello Friends,
MOSS2007 is still live and sometime we need to check certain features and that can give learning too. Recently...
2013-07-02
1,001 reads
In the last posts, we have discussed about the histogram ,density vector and how SQL server use the statistics information in cardinality estimation. In this post let us discuss about how the...
2013-07-02
167 reads
Starting SQL 2014 monitoring memory usage of the memory optimized objects is super important to ensure that your instance don’t...
2013-07-01
1,505 reads
In the last posts, we have discussed about the histogram ,density vector and how SQL server use the statistics information...
2013-07-01
1,533 reads
A little while back I wrote Best practice recommendations for writing Dynamic SQL where I made a number of suggestions...
2013-07-01
2,753 reads
First Monday of the month and time to update the monthly SQL Server checklist. Monthly SQL Server checklist, you ask?...
2013-07-01
920 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