12 Steps to Workload Tuning – Winter 2012 Performance Palooza!
[UPDATE] Video recording from PASS Virtual Performance Chapter’s Winter 2012 Performance Palooza can be found here.
I am a huge fan...
2012-12-05
887 reads
Blog Posts
Blog Redesigned
Since it’s been a while since I made any real changes to the design of this blog, it was time...
2012-12-05
739 reads
Experimenting with Social Media
After multiple talks with Jason Strate (blog|twitter) and Denny Cherry (blog|twitter) about how they are working on automating more of...
2012-12-05
1,138 reads
how to get ahead
Many people have ideas as to how to do well in life. Of course, many people do not even agree...
2012-12-05
1,651 reads
LivingForSQLServer celebrates 2nd year anniversary today
It's been 2 years since I wrote my first blog post on SQLServerCentral ("What happens when a query is submitted").
No...
2012-12-05
1,472 reads
My Writing Toolkit for the book project
I’m in the middle of writing the first chapter of my book. I’m not just ready to announce the working...
2012-12-05
857 reads
Next Chennai SQL Server UG Meet Is Scheduled
Chennai SQL Server user group meet is scheduled for Dec'2013.
Venue: Microsoft Training Centre, Radhakrishnan Salai, Chennai
Landmark: Opposite to President hotel
Timing: 09:30...
2012-12-05
1,607 reads
Plan cache bloat by SQLAgent (Prior to SQL2008) !
Recently I was checking the plan cache utilization with the help of the below query which I normally use for...
2012-12-05 (first published: 2012-11-29)
2,479 reads
About
I am a geek, husband, father, geocacher & gratuitous consumer of satellite signals (not in that order). I’ve been in IT professionally for over two decades doing web development,...
2012-12-04
36 reads
Backup History
This is a quick rewrite of the script I just posted a few days ago. The script had a few...
2012-12-04 (first published: 2012-11-30)
2,527 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