May 2013 Las Vegas UG
Spring is in the air, I think.
With that scent in the air, we have a nice juicy topic coming up...
2013-05-14
802 reads
Spring is in the air, I think.
With that scent in the air, we have a nice juicy topic coming up...
2013-05-14
802 reads
Thursday May 16th at noon central, we are going to be educated by MCM and past SQL Server MVP Robert...
2013-05-14
504 reads
As of today (5/14/2013) this MSDN article says “SQL Server Agent service startup account must be a member of the SQL Server...
2013-05-14
809 reads
To expand on what I talked about in Should a placement firm tell you what they are billing the client?:...
2013-05-14
994 reads
It’s T-SQL Tuesday time, this month hosted by Wendy Pastrick who asks you to talk about the Long and Winding...
2013-05-14
897 reads
Have you ever wanted to browse your SharePoint 2010 site in Windows Explorer? If you are in SharePoint 2007 please...
2013-05-14
893 reads
I blogged DBCC WritePage a year ago here http://www.sqlnotes.info/2011/11/23/dbcc-writepage/. It’s an extremely dangerous command especially with the last parameter “directORbufferpool” of this command turned on. I also showed you...
2013-05-14
12 reads
I blogged DBCC WritePage a year ago here http://www.sqlnotes.info/2011/11/23/dbcc-writepage/. It’s an extremely dangerous command especially with the last parameter “directORbufferpool”...
2013-05-14
1,001 reads
This past weekend we took a mini vacation, along the way my daughter decided to play this song, which is...
2013-05-14
606 reads
This month’s rendition of T-SQL Tuesday - #42, is hosted
by SQL MVP, Wendy Pastrick (blog|twitter) , who maintains her blog about Life,...
2013-05-14
1,209 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