PASS 2013 Keynotes Live Day 1
Final thoughts Dear Reader. This is a big launch year for Microsoft and we are getting some very cool toys...
2013-10-16
727 reads
Final thoughts Dear Reader. This is a big launch year for Microsoft and we are getting some very cool toys...
2013-10-16
727 reads
Welcome to the live blog! Have some resources to start: Watch the keynote live here: http://www.passsummit.com #sqlserver Take a look at...
2013-10-16
526 reads
Today is the first full day of the PASS Summit 2013 conference. This year I’m again joining the blogger table...
2013-10-16
1,112 reads
We have a set of databases at my office that use the load and swap method of loading data with...
2013-10-16
1,221 reads
I took a quick break at 5:30 to drop off my bag at the hotel and head back to attend...
2013-10-16
294 reads
I am liveblogging the keynote from the bloggers table at the PASS Summit again this year. Just keep scrolling.
Watching the...
2013-10-16
808 reads
While not technically the first day of Summit since the official start is yet to come, here are my thoughts on Sunday and Monday of PASS Summit 2013. For...
2013-10-16
10 reads
While not technically the first day of Summit since the official start is yet to come, here are my thoughts...
2013-10-16
663 reads
Today, October 16, 2013: PASS DAY2
PASS Summit Day 1……complete……..Great learning, check! Awesome sessions and nuclear networking! You can read my...
2013-10-16
1,138 reads
Problem: When you are performing many DML operations and makes tempdb contesnion on it, You may get wait_resource of 2.1.103...
2013-10-16
749 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