Interview questions
Lately, I’ve been asked by several folks about the interview questions that I use when I interview candidates for SQL...
2012-06-15 (first published: 2012-06-11)
12,028 reads
Lately, I’ve been asked by several folks about the interview questions that I use when I interview candidates for SQL...
2012-06-15 (first published: 2012-06-11)
12,028 reads
Below examples will show that we can still write a pure sql query for RANK, DENSE_RANK and ROW_NUMBER without using...
2012-06-11
321 reads
ORM tools. They’re great. They’re evil.
In the right hands, used the proper way, they can be a very powerful, very...
2012-06-11
3,502 reads
Absolutely fantastic of course!
You regular readers know that the Becoming a DBA area of the blog is one of the...
2012-06-10
821 reads
I just received an email message from the PASS Global Summit 2012 organizers after submitting session abstracts a few weeks...
2012-06-10
1,214 reads
2012-06-10
669 reads
I am sure you have heard of the term; garbage in garbage out. This maxim is even more true when...
2012-06-10
943 reads
I have been thinking about this for a while now, but I have decided to change my twitter handle. I...
2012-06-08
734 reads
I’ve been rereading an excellent book called “Clean Code” by Robert C. Martin. This book has some practices that each...
2012-06-08
1,218 reads
I'm hitting 3 venues in 5 days giving 4 different talks. If you plan on making one of these, I'd...
2012-06-07
1,061 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