Notes From the August 14, 2014 ONETUG Meeting
ONETUG team graciously gave me time at the beginning of the meeting to talk about the upcoming SQLSaturday OrlandoAsked them...
2014-08-15
638 reads
ONETUG team graciously gave me time at the beginning of the meeting to talk about the upcoming SQLSaturday OrlandoAsked them...
2014-08-15
638 reads
DateEventSeptember 6 SQLSaturday #301 – Cape Town 2014September 6 SQLSaturday #320 – Raleigh 2014September 13 SQLSaturday #323 – Paris 2014September 13 SQLSaturday #300...
2014-08-15
730 reads
DateTimeTitle LinkAugust 15th 12:00 EST Manage Your Shop with CMS and Policy Based Management https://attendee.gotowebinar.com/register/4279519516082609665August 19th 11:00 CST The Roadmap...
2014-08-15
608 reads
.. Is there something I should know, sang Duran Duran many moons ago when I was young and before I knew...
2014-08-15
416 reads
Photo credit – Jenn and Tony Bot
Sometimes old stuff is just as cool as new stuff. Over the past few years,...
2014-08-15
717 reads
I was reading Kendra Little’s ( b | t ) post on SQL Server Edition Changes and it reminded me of the work...
2014-08-15 (first published: 2014-08-06)
8,894 reads
Quick update on registrations. We’re at 287 as of noon on August 15th, not bad. The blue part of the...
2014-08-15
527 reads
USING POWERSHELL TO LIST SQLSERVER USER DATABASES WITH RECOVERY MODELS
One of op requested to list all the user defined databases...
2014-08-15
1,334 reads
I’m excited to able to say that I’ve been given the opportunity to put on a full day workshop at...
2014-08-14
822 reads
About a year and a half ago, I approached Guy and asked him if he wanted to start a podcast...
2014-08-14
1,414 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