SQLRally 2012 Eval Scores
I was just browsing the results of the presentations at SQLRally 2012. I ended up with a evaluation average of...
2012-06-25
649 reads
I was just browsing the results of the presentations at SQLRally 2012. I ended up with a evaluation average of...
2012-06-25
649 reads
Being a 2011 finalist I felt I should try and rally all those who truly are exceptional to get their...
2012-06-25
794 reads
A few days ago, I found a very interesting behavior regarding Service Broker on a
customer system. The main thing is...
2012-06-25
3,468 reads
Well after being a bit late in trying to book the beta exams I managed to get three of the...
2012-06-25
962 reads
Ok, so this is not strictly a post about SQL itself (and it's about a fairly old OS), but I...
2012-06-25
2,743 reads
The requirements for Power View state that it can only use tabular models as data sources. So if you want to...
2012-06-25
2,327 reads
It’s about that time again, PASS Summit 2012 is right around the corner in Seattle, WA. It will be held...
2012-06-25
962 reads
I took four beta tests earlier this year for SQL Server 2012. I had debated writing another book, and I’ve...
2012-06-25
1,298 reads
Just about a year ago, I talked about the importance of setting goals for yourself, both personally and professionally, making...
2012-06-25
1,036 reads
Good question. I don’t have a clue. So let’s set up a test. I’ll create this stored procedure:
CREATE PROCEDURE DL2e
...
2012-07-03 (first published: 2012-06-25)
2,278 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