Speaking at SQL Saturday #136 – Wellington, New Zealand
TweetG’day,
On Saturday 14th April I’ll be speaking at SQL Saturday 136 in Wellington, New Zealand.
My presentation is titled “Extended Events...
2012-04-12
993 reads
Building an Intel Ivy Bridge Desktop System, Part 1
I stopped by my local Micro Center on April 9, 2012, and I noticed that they had just received their...
2012-04-11
1,311 reads
Hashing Collisions
One of the problems with hashing is that you can have collisions from values that are not very similar. This...
2012-04-11
4,394 reads
Consultants: Corp-to-Corp vs 1099
I blogged previously that when you are a consultant or contractor, you can sometimes be faced with the decision when...
2012-04-11
5,574 reads
How To Live Blog an Event
As the euphoria of SQLBits X sadly begins to fade, I wanted to take a moment to share with you...
2012-04-11
1,067 reads
Limiting user access to your database
There are situations where you need to grant SELECT permission to a particular user and limit that access to a...
2012-04-11
2,533 reads
SQL Server – default trace FAQ
Has someone deleted a table?
Are you trying to track auto grow events? Problem scenarios such as Database autogrow and slow...
2012-04-11
1,076 reads
Top 3 Reasons Why Evernote is worth $1 billion to me
Everyone heard about Facebook’s recent purchase of Instagram for $1 billion dollars. No one can imagine how they came with such...
2012-04-11
899 reads
A Tale of Four Laptops
With the release of the 22nm Ivy Bridge microarchitecture less than three weeks away, at the end of April 2012,...
2012-04-13 (first published: 2012-04-10)
3,243 reads
T-SQL Tuesday #029 – SQL 2012 and Treating TempDB like it’s really Temporary.
A while back, my young son thought it would be fun to use a CD as a virtual surfboard on...
2012-04-10
1,585 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