MS SQL Server : Nested Transaction and Partial Rollback of Transaction
Couple of days back, one of my colleague came to me and asked about partial rollback of a transaction.He was trying...
2012-05-20
13,750 reads
Couple of days back, one of my colleague came to me and asked about partial rollback of a transaction.He was trying...
2012-05-20
13,750 reads
Denali – Day 20: More Programmability Feature
Native XML Web Services (SOAP/HTTP endpoints) is Removed:
Earlier version of sql server support Web services...
2012-05-20
944 reads
In my previous blog post: Suggestion: “USE” Keyword with Linked Servers, I talked about the suggestion I’ve posted on Microsoft...
2012-05-20
550 reads
Another question I have answered 100s of times to Non SQL folks. "SQLServr.Exe is consuming 80% of memory. Can you...
2012-05-20
1,483 reads
If you attended one of the sessions I promised to post the links we discussed here. I have done my...
2012-05-19
1,161 reads
Denali – Day 19: Programmability Feature -T-Sql
ORDER BY .. OFFSET and FETCH :mysql LIMIT (srno ):
OFFSET is a location of the rows...
2012-05-19
1,037 reads
The SQL Server 2012 upgrade white paper is now available from Microsoft. I’m proud to have made a contribution and...
2012-05-18
1,726 reads
My fourth visit to the Rocky Mountain Tech Trifecta will be tomorrow where I’ll deliver two talks:
Branding Yourself for a...
2012-05-18
1,125 reads
I was chatting with a friend recently and he said he could never blog the way I do. Which way...
2012-05-18
592 reads
One of the things I’ve learned from running events is to set expectations. If you’re going to provide coffee don’t...
2012-05-18
590 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