Rollback TRUNCATE TABLE statement
Whenever I ask a SQL candidate in an interview the difference between DELETE and TRUNCATE TABLE, the first answer I...
2012-08-06
2,451 reads
Whenever I ask a SQL candidate in an interview the difference between DELETE and TRUNCATE TABLE, the first answer I...
2012-08-06
2,451 reads
Blocking in in SQL Server by SPID -2 happens due to Orphan DTC transaction, for instance whenever a data source...
2012-08-06
5,773 reads
Hey all you proactive SQL junkies, want to jump start your SQL 2012 Certification? Or are you just here because...
2012-08-06
467 reads
http://www.flickr.com/photos/brickapolis/5474835288/
I was working with a friend last week, doing SQL related teaching and tune ups. Earlier this week I had...
2012-08-06
4,268 reads
One of the first questions I hear from folks wanting to grow in their Microsoft SQL Server DBA or database developer...
2012-08-06
2,279 reads
TweetG’day,
I had a recent conversation about data pages. There was some debate about the location of the first record on...
2012-08-06
1,219 reads
Another potential problem that you need to tackle as a DBA is running out of disk space on the hard...
2012-08-06
3,278 reads
What will happen if you lost all your administrator account by mistake ? As per the best practice you have disabled...
2012-08-06
8,009 reads
We are starting our free monthly webinars with 'What's new in Reporting Services 2012' on Wednesday August 8, 2012 at 12...
2012-08-06
1,332 reads
This is one of the session I took for SQL DBA to understand the basics of Oracle, Its a powerpoint presentation but...
2012-08-06
4,695 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