How to provide a better customer service
Thomas La Rock (Blog | Twitter) recently wrote a blog post about misplacing a device he has called a FitBit One which...
2013-04-29
1,734 reads
Thomas La Rock (Blog | Twitter) recently wrote a blog post about misplacing a device he has called a FitBit One which...
2013-04-29
1,734 reads
As I re-read the original Looking Back post I realized I didn’t include anything about the fear part – stepping away...
2013-04-29
1,270 reads
Recently I was setting up a virtual machine environment to do some demo’s. One of the virtual machines would be...
2013-04-29
9,111 reads
I was recently asked by a customer if you could build a Shared Dataset using Report Builder 3.0. More specifically,...
2013-04-29
2,947 reads
sys.dm_clr_tasks DMV (Dynamic Management View), described by BOL as follows: http://msdn.microsoft.com/en-in/library/ms177528.aspx
Returns a row for all common language runtime (CLR) tasks...
2013-04-29
1,802 reads
Say if you have a management server or a script repository server, sometimes users save/test/run their script from different path,...
2013-04-28
1,398 reads
Yesterday I had the opportunity to speak at the first ever SQL Saturday Fargo! Jason Strate (b | l | t) and...
2013-04-28
791 reads
Spend a few minutes reviewing 20 Critical Security Controls. Very interesting stuff. For example, #1 refers to having and maintaining...
2013-04-27
815 reads
Hello Dear Reader! I'm up in Jacksonville for SQL Saturday 215. Today I'm presenting SQL Internals, Backups, and Recovery Models! OH...
2013-04-27
713 reads
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-04-26
1,040 reads
By Steve Jones
I was experimenting with CHOOSE() recently after I was asked a question. In a...
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...
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