Speaking at PASS Summit
I found out last week that I will be presenting three sessions at the PASS Summit 2013 in Charlotte, NC....
2013-08-05
722 reads
I found out last week that I will be presenting three sessions at the PASS Summit 2013 in Charlotte, NC....
2013-08-05
722 reads
Over the last year of blogging my thoughts and queries I’ve discovered something interesting. I posted Where is my Backup?...
2013-08-05
1,453 reads
As many of you know, I created a facebook group named 'Living For SQL Server' couple of months back.
SQL Server...
2013-08-05
1,412 reads
Guidance is hard.
Seriously, you’d think it would be easy. You’d think you say things like, don’t shrink your database, most...
2013-08-05
2,348 reads
I recently needed to figure out how to embed Flash streaming video in a blog post. LiveWriter does Youtube ok...
2013-08-05
589 reads
I’ll be doing my PCI for the SQL DBA presentation on August 8th at 1 pm Eastern for the PASS...
2013-08-05
810 reads
There are several ways to create a custom navigation control in SharePoint. In the below image you can see the...
2013-08-05
956 reads
When it comes to ETL, I’m a pessimist. Until proven otherwise, I assume that all data is bad, all connections...
2013-08-05
2,089 reads
Once a year, just before the annual PASS Summit, there is a promotional event called 24 Hours of PASS. The...
2013-08-05
456 reads
There are a lot of ways to monitor AG, sql server errorlog, window event log, cluster log......, here I list...
2013-08-04
6,591 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