T-SQL Tuesday #45 Follow the Yellow Brick Road
We have the distinct pleasure once again to have a party full of SQL enthusiasts. The best part is that few if any of us are even in the...
2013-08-13
11 reads
We have the distinct pleasure once again to have a party full of SQL enthusiasts. The best part is that few if any of us are even in the...
2013-08-13
11 reads
We have the distinct pleasure once again to have a party full of SQL enthusiasts. The best part is that...
2013-08-13
812 reads
Are you looking for some beach time? I know I am. I also know that I will probably get some of that beach time at an upcoming SQL Saturday....
2013-08-12
29 reads
Are you looking for some beach time? I know I am. I also know that I will probably get some...
2013-08-12
671 reads
At work my boss this week my boss gave me some quotes about me. We solicit feedback twice a year...
2013-08-12
2,240 reads
Single Query to fetch complete details of sql jobs and you can run it across different version of SQL [2000/2005/2008...
2013-08-12
8,172 reads
If you asked me, prior to today, if I would type or say those words, I would have laughed right...
2013-08-12
750 reads
It’s summer here in the northern hemisphere, and in Texas we’re getting 100F-plus weather pretty consistently. This brain-frying weather may...
2013-08-12
584 reads
“My transaction log is too big!” I wish I had a dime for each time phrase has been spoke, written,...
2013-08-12
1,672 reads
LinkedIn groups have the option to enable a Jobs section and associated discussion area. Potential employers can post jobs directly...
2013-08-12
826 reads
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...
By ReviewMyDB
Part 1 of my What's New in SQL Server for the Developer series. IIF,...
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...
Comments posted to this topic are about the item Data Lost in the Cloud
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