SQLSaturday #40 – South Florida Recap
I had the great privilege to be able to attend and speak at SQLSaturday #40 – South Florida this past weekend...
2010-08-02
657 reads
I had the great privilege to be able to attend and speak at SQLSaturday #40 – South Florida this past weekend...
2010-08-02
657 reads
Steve Jones had an interesting blog post the other day, Do as I Say, Not as I Do, and I...
2010-07-30
1,544 reads
Andy Leonard is posting interviews of all the candidates PASS Board of Directors on his blog and mine is up...
2010-07-28
396 reads
I finally get to head down to Miramar to speak at SQLSaturday #40 – South Florida. I really wanted to go...
2010-07-27
339 reads
The Boy Scouts have “Be Prepared” as their motto and, while I was never a scout, I think it’s always...
2010-07-23
333 reads
Last Tuesday, July 13th, we had our monthly OPASS meeting. The meeting was sponsored by RedGate who were kind enough...
2010-07-20
459 reads
Yes, I’m going to run for the PASS Board of Directors. I have my application and will be sending it out...
2010-07-19
543 reads
What does ANSI_PADDING mean and how does it affect my SQL Server database?
2010-07-16 (first published: 2008-09-12)
25,528 reads
My article, ANSI Padding, Trailing Whitespace, and Variable Length Character Columns, is featured in today’s SQLServerCentral newsletter. Check it out!...
2010-07-16
369 reads
OPASS will be holding it’s July meeting this evening from 6pm – 8:30pm at 225 S. Westmonte Drive, Altamonte Springs, FL. ...
2010-07-13
435 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