Extreme Transaction Processing (XTP, Hekaton) – the solution to everything?
(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)
My complete last...
2013-08-12
2,187 reads
(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)
My complete last...
2013-08-12
2,187 reads
Configuration tables are a best practice in just about any SSIS environment. They make it easy to update multiple packages...
2013-08-12
2,162 reads
sys.dm_tran_locks DMV (Dynamic Management View), described by BOL as follows: http://msdn.microsoft.com/en-us/library/ms190345.aspx
Returns information about currently active lock manager resources. Each row...
2013-08-12
1,275 reads
And so, the countdown begins for the super spectacular,
extraordinarily exceptional, amazingly awesome, fabulously fantastic confab
that is known as SQLSaturday
#235 in...
2013-08-11
870 reads
All ColoradoSQL user group meetings start at 5:30 p.m. and provide food and refreshments. There is no cost to attend...
2013-08-10
568 reads
Most of the DBAs at some point of time in their career should have faced at-least one of the below...
2013-08-10
1,407 reads
Hello Dear Reader! I got a lot of great questions during the 24 Hours of PASS last week and I'm...
2013-08-09
841 reads
I’ve always been a fan of the feeling when I find an old blog post that’s got just the information...
2013-08-09
890 reads
Windows Failover Clusters are fantastic, they provide High Availability for mission critical SQL Server instances and make my life as...
2013-08-19 (first published: 2013-08-09)
2,864 reads
PASS Summit 2013 will be my fifth Summit to attend. I wrote a blog post about how different my fourth...
2013-08-09
647 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