SQL PASS Summit 2012 Came and Went – and Changed My Life
I cannot believe how surreal this past SQL PASS Summit was for me. This was the second Summit I have...
2012-11-20 (first published: 2012-11-14)
1,965 reads
Remote Desktop and Surface
The Windows RT operating system is not the same as Windows. After all the talk about the upcoming OS and...
2012-11-14
2,375 reads
SQL Server Parallel Data Warehouse (PDW) and SQL Server Fast Track Data Warehouse
The SQL Server Parallel Data Warehouse and SQL Server Fast Track Data Warehouse are very high end builds of Microsoft’s...
2012-11-14
929 reads
Database Mirroring Performance Counters
This week’s SQL Skills insider email contains a simple but often too true scenario regarding database mirroring. If you haven’t...
2012-11-21 (first published: 2012-11-14)
2,740 reads
SQL Server Virtualisation
SQL Server Virtualisation - Lots of companies and organisations are adopting a virtualisation first approach to the installation of new servers...
2012-11-14
787 reads
SQL Server || Compress & UnComprees Backups in one Media\File
Today, We try to check of SQL server when trying to take Compress & UnCcomprees Backups in one Media\File.
Query No. 1
BACKUP...
2012-11-14
2,519 reads
Rules of Holes #2: You Are Still in a Hole
OK. So you followed the First Rule of Holes -you stopped digging yourself in deeper. But now what? You are still in a Hole. Your situation has not changed...
2012-11-14
13 reads
Rules of Holes #2: You Are Still in a Hole
OK. So you followed the First Rule of Holes -you stopped digging yourself in deeper. But now what? You are still in a Hole. Your situation has not changed...
2012-11-14
20 reads
T-SQL Tuesday #36 – Community
Chris Yates (@YatesSQL / blog) is hosting the T-SQL Tuesday blogging party this month, and he wants to know “What does...
2012-11-13
738 reads
Instant File Initialization with TDE
If you are using Transparent Data Encryption TDE and have Instant File Initialization turned on, you are not getting the...
2012-11-13
962 reads
Blogs
T-SQLTuesday 204: Are blogs still relevant?
This month’s blogging party is hosted by Jeff Ianucci – his challenge is to...
Are Blogs Still Relevant? I Think They Still Are.
As for me, I'll keep writing whenever time permits. I don't expect every post...
Reading Blogs: T-SQL Tuesday #204
By Steve Jones
This is an interesting invitation this month. Jeff Ianucci is a new host, and...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Switching Schemas I
Comments posted to this topic are about the item Switching Schemas I
Enforcing Unique Customer Emails When Duplicates Already Exist
Comments posted to this topic are about the item Enforcing Unique Customer Emails When...
Question of the Day
Switching Schemas I
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 one row back for an object named dbo.beer. There is an ETL schema and both of these are nonpartitioned tables. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers