I’m Not Presenting at PASS Summit 2013
Last week I got the news that none of the four sessions I submitted for this year were accepted. Disappointing...
2013-05-22
685 reads
Last week I got the news that none of the four sessions I submitted for this year were accepted. Disappointing...
2013-05-22
685 reads
With the PASS Summit sessions announced, I took a quick look to see how many were what I'd consider security-centric....
2013-05-22
2,848 reads
Earlier this week I posted The many uses of CROSS APPLY and I’m quite glad I did. I’ve been working...
2013-05-22
887 reads
I’m happy to announce that I have been selected to present
at the SQL PASS Summit in Charlotte, North Carolina this...
2013-05-22
687 reads
The 11th cumulative update release for SQL Server 2008 Service Pack 3 is now available. Cumulative Update 11 contains all...
2013-05-22
654 reads
I was asked a good question the other day, one that I wasn’t sure of the answer. The question was...
2013-05-22
1,753 reads
Hello Friends,
As discussed in my previous blog the new architecture of Service Application in 2010. Let’s today discuss about connecting...
2013-05-22
717 reads
Andy Leonard (blog | twitter) and I are putting together a presentation on protecting the entire ETL (Extract, Transform, Load) pipeline, specifically...
2013-05-22
2,734 reads
Calculation dimensions in SSAS are used to store calculations that can be applied to any measure in the cube. For...
2013-05-22
1,285 reads
If a query is taking longer to run than normal, there’s a good chance it’s being blocked by something else....
2013-05-22
708 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