T-SQL: CASE Statement
For the month of December, I’ll be taking a little holiday from blogging. In the meantime, enjoy a few of...
2012-12-11 (first published: 2012-12-03)
5,194 reads
For the month of December, I’ll be taking a little holiday from blogging. In the meantime, enjoy a few of...
2012-12-11 (first published: 2012-12-03)
5,194 reads
Throughout the week, I like to tweet links to the things that I’ve been reading. Since they all come out through out...
2012-12-03
1,025 reads
See this:
That’s right. The install worked. All I had to do was get a completely clean server set up. No...
2012-12-03
1,391 reads
In this article We are going to understand the basics of SQLOS - CPU scheduling.
In high level:
1. When an user connects to SQL...
2012-12-03
6,414 reads
Unbelievably it is December already and 2013 is fast approaching. With the Christmas break fast approaching now is the time...
2012-12-03
1,093 reads
I am old enough to remember watching the Apollo 11 landing in 1969 as a young child. Before and after...
2012-12-03
1,492 reads
If you're working in an environment as a developer without sysadmin privileges, and you are creating database diagrams using Management Studio...
2012-12-10 (first published: 2012-12-03)
3,299 reads
I often think that I am lucky to work in a profession that I enjoy very much. It makes everything...
2012-12-03
701 reads
Database technologies are an essential component of many information systems because they store a large amount of sensitive corporate data...
2012-12-02
844 reads
Checkout my article here, in which I discussed the fundamentals of XML technologies.
This article is published on SSWUG.org.
2012-12-02
645 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