Two Blogs, One Writer
I started blogging back on August 9, 2006, so I have been at it for quite a while. I am...
2012-12-07
1,081 reads
Blog Posts
Down in DC, with SQLSaturday 173!
This Saturday, major event that will shake the halls of
power gets under way for an all-day non-stop super event. Bringing...
2012-12-06
1,336 reads
Free SQL Server Learning Resources - Updated
Here is updated list of *free* invaluable SQL Server learning resources.
Unknown is an ocean.
You think I missed some important freely...
2012-12-06
3,334 reads
Lost in Translation – Deprecated System Tables – syslockinfo
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-12-06
1,558 reads
Microsoft Surface: Top Apps… So Far
After living with the Surface for a month and trying hard to make it work as a tool for production,...
2012-12-06
1,765 reads
My new favourite traceflag
As we are all aware, there are a number of traceflags. Some documented, some semi-documented and some completely undocumented. Here...
2012-12-06
1,019 reads
Querying Performance Counters in SQL Server
In a previous post, there was a comparison between sysperfinfo and sys.dm_os_performance_counters which included the use of a simple query. ...
2012-12-06 (first published: 2012-11-27)
6,877 reads
SQL Saturday 194 - Exeter
Many kudos goes to Jonathan and Annette Allen and the others on the team for confirming SQL Saturday 194 in...
2012-12-06
885 reads
SQL Server Data Tools (SSDT) – November 2012 update
SQL Server Data Tools (SSDT) has a new update:
VS 2010: new version 10.3.21101.1, September version: 10.3.20905.0, initial version: 10.3.20225.0
VS 2012: new...
2012-12-06
2,996 reads
Tables without a Primary Key
As well as creating the script for yesterday’s post on finding Tables without a Clustered Index I tweaked the script...
2012-12-06 (first published: 2012-11-30)
5,247 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