Free Online SQL Server Training for the Week of November 10, 2013
If you’re a training provider and I’ve missed you, please drop me a line at brian {dot} kelley {at} sqlpass...
2013-11-07
1,608 reads
If you’re a training provider and I’ve missed you, please drop me a line at brian {dot} kelley {at} sqlpass...
2013-11-07
1,608 reads
If you administer a SQL Server Reporting Services server, chances are you’ve had users complain the report manager is loading...
2013-11-07
4,606 reads
Remember when you were eight years old, how exciting it was to order some of those amazing products that were...
2013-11-07
942 reads
ugggh.
My Drupal site in AWS EC2 was hijacked and is being used by the hijackers to do port scans.
Who said...
2013-11-06
611 reads
Today I got a database mirror case, I was told the all databases were in disconnected\in recovery status on both...
2013-11-06
1,271 reads
What does this mean? I had someone ask me in a session recently, and I think I have a good...
2013-11-06
1,106 reads
For those of you that know me, you know that I enjoy learning, and passing on what I have learned...
2013-11-06
803 reads
These quick tips are short and sweet. They are nothing more than an explanation and some code. If you have...
2013-11-06
571 reads
I've been to five SQL Saturdays so far and this was my first year to attend the Dallas conference. Therewere...
2013-11-06
415 reads
For those who don’t know the three physical join operators are Hash Match, Loop Join and Nested Loops. Understanding these...
2013-11-06
691 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