So Now I’m Gilligan, Finally
Okay I was tagged by Tim Mitchell on the Deserted Island scenario started by Tim Ford which goes like this:
So...
2009-07-06
498 reads
Okay I was tagged by Tim Mitchell on the Deserted Island scenario started by Tim Ford which goes like this:
So...
2009-07-06
498 reads
In Part 2 of our series we will examine how to create custom templates and how to save collected trace data.
2009-06-15
4,501 reads
This article introduces Profiler presenting what it is, how to use it, and why you might want to use it.
2009-04-16
11,061 reads
New author Jack Corbett brings us a look at a way of finding out what caused your error in Integration Services.
2009-04-03 (first published: 2008-04-21)
44,775 reads
This provides information about traces that are defined on SQL Server 2005.
2008-12-01 (first published: 2008-10-25)
1,313 reads
This article by Jack Corbett explains what triggers are, the different types, and how to avoid common mistakes.
2008-10-14
14,750 reads
2008-10-03
2,859 reads
2008-09-11
1,552 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