Friday Followup For February 28, 2014
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2014-02-28
1,139 reads
Why wait statistics are important and how you can start collecting them now!
Why wait statistics are important and how you can start collecting them now!
Wait statistics have always been a very important...
2014-02-28
1,405 reads
Fight Career Frustration With Learning
If you work in IT, the office becomes your second home. It’s where we make a living, and most of...
2014-03-11 (first published: 2014-02-28)
2,968 reads
Virtual Lab – Setting up a new VM
This is part of a series where I set up a virtual lab for testing and misc. work. The other...
2014-02-27
1,477 reads
PowerShell – SSRS Inventory – Automatic – Excel File – EMAIL
Inventory is a vital information,whether you’re a consultant or an in-house DBA, you need to have a reliable inventory of...
2014-02-27
2,060 reads
Data Architecture Virtual Group - Whiteboard Data Architecture Presentation
Thanks to all 130+ folks who joined, suffered my jokes and handwriting, and asked fantastic questions during my presentation to the...
2014-02-27
1,320 reads
Security #Datachat on Twitter Tonight
Tonight, at 9 PM Eastern, I’ll be participating in a #datachat on SQL Server security. It’s sponsored by Confio (now...
2014-02-27
989 reads
Introduction to Hadoop
Hadoop was created by the Apache foundation as an open-source software framework capable of processing large amounts of heterogeneous data-sets in...
2014-03-11 (first published: 2014-02-27)
8,366 reads
Spring in Florida
The first sign of spring in Florida is the leaves falling from the oak trees. Tons of leaves, leaves everywhere,...
2014-02-27
1,054 reads
Let’s Talk Query Tuning
I spend quite a bit of time writing about query tuning on this blog. I’ve written (re-written and am actively...
2014-02-27
1,289 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