Baton Rouge SQLSaturday #150 & Tech Day .Net 1 track
August 4th of this year will be the forth annual Baton Rouge SQL Saturday and Tech Day. LSU has offered...
2012-07-10
2,991 reads
August 4th of this year will be the forth annual Baton Rouge SQL Saturday and Tech Day. LSU has offered...
2012-07-10
2,991 reads
Why don’t we have a function like the one in this article to convert from time zone to time zone?...
2012-07-10
965 reads
After about a year of work and a month of waiting, the book I wrote with Ted Krueger (Blog | @Onpnt)...
2012-07-10
1,884 reads
Change data capture was introduced in SQL Server 2008 and has been pretty popular ever since. The basic concept behind...
2012-07-10
4,132 reads
Date: August 18, 2012
Session 1
Title: So I started this blog…now what?
Abstract:
Ever thought about trying your hand at blogging? Or maybe...
2012-07-10
711 reads
Date: July 21, 2012
Session: So I started this blog…now what?
Abstract:
Ever thought about trying your hand at blogging? Or maybe you’ve...
2012-07-10
676 reads
Welcome back Dear Reader to Part 6 on our series of how to read a Data Record. In Part 1...
2012-07-09
1,266 reads
Here is a snippet of code that will assist in the dynamic ‘spin-up’ of duplicate SSIS packages. To put it...
2012-07-09
1,482 reads
I haven’t been able to do much XQuery development recently which is a shame as I love developing with the...
2012-07-09
4,555 reads
Today while checking our database growth reports, I noticed that size of msdb database on most of our SQL Server...
2012-07-09
2,525 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...
Has anyone ever seen this before? I have sysadmin permission on a server. I...
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...
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