Article re-featured on SQLServerCentral
The second article I had published on SQLServerCentral, ANSI PADDING, Trailing Whitespace, and Variable Length Character Columns, was re-featured in...
2009-07-31
1,418 reads
The second article I had published on SQLServerCentral, ANSI PADDING, Trailing Whitespace, and Variable Length Character Columns, was re-featured in...
2009-07-31
1,418 reads
ActiveAugust started as a discussion on Twitter and Mike Walsh (@mike_walsh) has set the bar with his blog post about...
2009-07-28
1,205 reads
Andy Warren and crew at OPASS have announced that SQLSaturday 21 – Orlando will be held at Seminole Community College, 100...
2009-07-28
1,305 reads
As part of my work I need to be a “Jack of all trades” meaning I not only need to...
2009-07-24
655 reads
How many of you have said, “I have a real hard time remembering names” or “Excuse me, I know we...
2009-07-21
422 reads
Have you ever seen this error when you have setup database mail:
The mail could not be sent to the recipients...
2009-07-20
441 reads
Last night I attended, along with about 20 others, the latest and greatest OPASS meeting. I got there early to...
2009-07-15
540 reads
There may be some people wondering why I go by the name @unclebiguns on Twitter. I am basing this on...
2009-07-15
402 reads
Hey, Orlando area SQL Server folks, don’t forget the OPASS meeting 6pmTuesday, July 14th at End to End Training (map). ...
2009-07-13
449 reads
I recently saw that Steve Jones had posted an update on his 2009 goals and realized that is was about...
2009-07-07
379 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