Multiple ALTER DATABASE SET options
TweetG’day,
Did you know that you can actually combine multiple SET operations into a single ALTER DATABASE statement.
It’s true, you can!
Mostly...
2013-04-06
4,338 reads
TweetG’day,
Did you know that you can actually combine multiple SET operations into a single ALTER DATABASE statement.
It’s true, you can!
Mostly...
2013-04-06
4,338 reads
We lost someone this week. We lost a fellow SQL-ite, a Twitterer, a DBAs@Midnight chatroom live chatter. We lost someone...
2013-04-05
847 reads
Powershell 3.0 has many new feature, and they are useful in some circumstance.
let's say User A log in server A,...
2013-04-05
1,220 reads
I’m starting a new tradition:
Before each weekend, I will post links to the best SQL Server stuff i’ve read, heard...
2013-04-05
1,041 reads
This should go without saying, because most of us have been on the receiving end of poor customer support. However,...
2013-04-05
1,042 reads
Just recently I was part of an online presentation in which the intended audience was unable to install any of...
2013-04-04
250 reads
As per Microsoft Books Online and SQL Server Security best practice white paper, it is recommended to periodically review privileges...
2013-04-04
4,902 reads
You can get backups of your WASD databases. But, if you want them to be transactionally consistent, you need to...
2013-04-04
929 reads
The bank holiday and work have put me a few days behind schedule, but here is the list out all of the...
2013-04-04
752 reads
Last week I took the final exam to acquire the MCSE – Business Intelligence certification. This blog post describes my preparation...
2013-04-04
18,514 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...
Has anyone ever seen this before? I have sysadmin permission on a server. I...
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...
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