SQL Server 2012 Service Pack 1 CU5
On July 15, Microsoft released SQL Server 2012 Service Pack 1 Cumulative Update 5. This is Build 11.0.3373, and I...
2013-07-23
1,508 reads
On July 15, Microsoft released SQL Server 2012 Service Pack 1 Cumulative Update 5. This is Build 11.0.3373, and I...
2013-07-23
1,508 reads
Found a gap issue when using IDENTITY column in SQL Server 2012, every time I restarted sql server service, the current...
2013-07-23
3,777 reads
In our earlier posts, we have discussed about different types of pages.Data Pages, GAM and SGAM,PFS page and IAM page. In this...
2013-07-23
2,254 reads
Open Source, ON WINDOWS! I’m still stunned in this day and age that people pay obscene amounts of money on tools that are easily replaced in most cases with...
2013-07-23
48 reads
Open Source, ON WINDOWS!
I’m still stunned in this day and age that people pay obscene amounts of money on tools...
2013-07-23
1,909 reads
What looks to be the biggest and best new feature in SQL Server 2014 is called the “In-memory OLTP Engine”,...
2013-07-23
2,089 reads
I’ve got a couple days off, starting today after my webinar on Preparing for When Disaster Strikes. I’ve got some...
2013-07-23
896 reads
I learned something from you – that was something someone said to me at the end of a recent consulting engagement....
2013-07-23
763 reads
Every day I consider myself extremely fortunate to be in a profession that I really enjoy, as there’s always something...
2013-07-23
801 reads
(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)
Today I have...
2013-07-23
1,289 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