Virtualization for SQL Server DBAs – New SQL Saturday Pre-Con Session
Today I am officially announcing the launch of my first all-day SQL Saturday Pre-Conference training session entitled “Virtualization for SQL...
2013-10-30
1,224 reads
Today I am officially announcing the launch of my first all-day SQL Saturday Pre-Conference training session entitled “Virtualization for SQL...
2013-10-30
1,224 reads
What is PowerPivot for Excel? PowerPivot brings the power of Data Modelling into your PC. Traditionally, the DataWarehouse is built...
2013-10-30
1,674 reads
I’m very passionate about security, especially database security. As the numbers with regards to data breaches continue to climb, this...
2013-11-05 (first published: 2013-10-30)
2,739 reads
By Steve Bolton
…………In order to divide the Herculean task of describing custom algorithms into bite-sized chunks, I omitted discussion of...
2013-11-04 (first published: 2013-10-30)
2,801 reads
I just posted a new version of sp_BackupDatabases. The biggest change is that the procedure now creates one-time SQL Agent...
2013-10-29
1,629 reads
(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)
Cardinality Estimation is...
2013-11-01 (first published: 2013-10-29)
3,556 reads
Not much news came out of the PASS Summit 2013 from last week, but boy did I have a blast! I...
2013-10-29
1,135 reads
Let’s have some fun.
This Friday, November 1, 2013, I’m putting on an all day seminar on query tuning. It’s set...
2013-10-29
681 reads
Startup Weekend comes to Orlando on Nov 22-24, 2013. I haven’t been (and not sure I will make this one)...
2013-10-29
759 reads
This blog post will not be about Bob Dylan, but rather about some professional changes/challenges I’ve been up to lately.
The...
2013-10-29
505 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