We’re speaking at PASS Summit 2013!
PASS liked our “Mouth Wide Shut” interviewing session from last year so much that they’ve decided to have us back...
2013-05-22
611 reads
PASS liked our “Mouth Wide Shut” interviewing session from last year so much that they’ve decided to have us back...
2013-05-22
611 reads
Seems I managed to make it through all of April without an update to the index analysis stored procedure. It...
2013-05-22
591 reads
I am beyond excited to announce that I have been accepted to speak at the annual SQL PASS Summit 2013...
2013-05-22
1,191 reads
No, this isn’t some complaint about PASS or the Summit. This is an announcement that not only will I be...
2013-05-22
662 reads
Snippet to quickly view computed column information. You can also view this by doing a “create table” script. This however,...
2013-05-22
589 reads
I’m Speaking at The PASS Summit 2013!
Hello Dear Reader! Big news. I’ve been selected as a speaker for the SQL...
2013-05-22
523 reads
As I mentioned in the introductory post, in the Introduction to SQL Server Security session for Pragmatic Work’sTraining on the T’s, I...
2013-05-22
723 reads
I am honored to say that have been selected to present this year. I'll be giving a talk on my...
2013-05-22
390 reads
I’m happy to officially announce that I’ll be presenting at this year’s PASS Summit in Charlotte, NC! I’ll be presenting...
2013-05-22
564 reads
For sake of future generations, let’s begin to reduce typing and reuse code we’ve built. I think we can all...
2013-05-22
1,323 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