T-SQL: CASE Statement
This is a companion piece to the MidnightDBA video T-SQL: CASE Statement.
In short, a CASE statement is a simplified set...
2010-12-28
2,736 reads
This is a companion piece to the MidnightDBA video T-SQL: CASE Statement.
In short, a CASE statement is a simplified set...
2010-12-28
2,736 reads
Rule: No Sushi with Adam within 24 hours of session
I’m inspired by Brent Ozar‘s and Andy Leonard‘s sharing of their PASS...
2010-12-23
795 reads
Hooboy…the super-structured format of the first two RTFM365 posts just isn’t sustainable for me. I’m going to have to go...
2010-12-20
669 reads
Hello and welcome to the December 2010 edition of T-SQL Tuesday. This month’s host is Steve Jones (blog|twitter) of SQLServerCentral,...
2010-12-14
553 reads
Here’s the rundown of what we were up to last week
Friday night at 11pm CST we present another wildly appealing...
2010-12-13
813 reads
Big lessons learned this week: 1, its’ always worthwhile to go back and reread the basics. 2, sys.sp_trace_create option 4 doesn’t...
2010-12-10
518 reads
It’s been a few months…time for another Spotlight!
Just to catch you up, occasionally someone in the SQL community – usually someone...
2010-12-09
1,457 reads
“Next 24 Hours of PASS on March 15-16 2011, celebrating Women’s History Month with 24 female speakers!”
Thus goes the announcement on...
2010-12-08
1,206 reads
“Next 24 Hours of PASS on March 15-16 2011, celebrating Women’s History Month with 24 female speakers!”
Thus goes the announcement on...
2010-12-07
819 reads
“Eat your broccoli.”
“Wear your gloves.”
“Schema qualify your objects.”
Your Mom wasn’t kidding, and she always gave the best advice. We’ve already...
2010-12-06
1,725 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