T-SQL Tuesday #41: How I Got My Start in Presenting
For this month's T-SQL Tuesday, Bob challenges us to discuss how we came to love presenting. Here's my story.
I developed a...
2013-04-19 (first published: 2013-04-09)
1,971 reads
For this month's T-SQL Tuesday, Bob challenges us to discuss how we came to love presenting. Here's my story.
I developed a...
2013-04-19 (first published: 2013-04-09)
1,971 reads
Some Tuesday mornings I have bacon with eggs and an English muffin. Not today though. I am blogging about Why...
2013-04-09
470 reads
With Service Packs and Cumulative Updates rapidly released for SQL, it can be hard to keep up with what version you have installed where. It’s easy enough to find...
2013-04-09
25 reads
I see this question in one form or another a lot. I’ve seen this or something like it probably half...
2013-04-08
818 reads
I had known that the Resource Governor is always running in modern versions of SQL Server. It’s core to the...
2013-04-08
1,126 reads
This past weekend, I took a quick trek into the land of beer and cheese for the second annual Madison...
2013-04-08
605 reads
The PASS Business Analytics Conference is almost here! Check out the sessions to be presented at the conference and you will see...
2013-04-08
933 reads
The Chicago SQL Saturday is coming up this weekend on Saturday, April 13th. If you are waiting until the last minute...
2013-04-08
524 reads
For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of...
2013-04-08
491 reads
I can’t say I’ve ever worried too much about how much power my PC uses. I care about battery life...
2013-04-08
780 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