Lost that Single-User Connection?
You have changed your database to single_user mode to do a task. As you go about your business, you lose...
2013-05-06
807 reads
You have changed your database to single_user mode to do a task. As you go about your business, you lose...
2013-05-06
807 reads
I know that it has been a while, and I apologize. I have been traveling around the U.S. evangelizing SQL...
2013-05-06
1,400 reads
To identify default data and log directories in SQL Server 2012 you can use SERVERPROPERTY() function. In SQL Server 2012...
2013-05-06
934 reads
As promised, here are the presentations and sample code I used at the 2013 Carolina Code Camp. If you attended...
2013-05-06
1,018 reads
It seems that with the Disney purchase of Star Wars this past year that May the Fourth is coming on...
2013-05-04
443 reads
In my last post, I discussed about the quantitative KPIs which, to me, are useful for “outsiders”, i.e. non-DBAs, to...
2013-05-04
929 reads
In my last post, I discussed about the quantitative KPIs which, to me, are useful for “outsiders”, i.e. non-DBAs, to...
2013-05-10 (first published: 2013-05-04)
5,216 reads
Joe Lacob bought the struggling Golden State Warriors NBA franchise in 2010. He has been the most hated man by...
2013-05-03
826 reads
Hello Dear Reader! We are at that time of the year again. SQL Saturdays are popping up all over the...
2013-05-03
888 reads
WOW! SQL Saturday Atlanta this year is turning into one of the largest SQL Saturdays ever! I’m absolutely honored and pumped to...
2013-05-03
658 reads
By Steve Jones
I was experimenting with CHOOSE() recently after I was asked a question. In a...
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...
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