Tony Rogerson's ramblings on SQL Server - All Comments

rebuild master sql2005

rebuild master sql2005 — Fri, 09 May 2008 15:13:37 GMT

Pingback from rebuild master sql2005

Interesting Finds: May 5, 2008

Jason Haley — Mon, 05 May 2008 13:41:36 GMT

re: Rude easter egg in SQL 2005 - Uniqueidentifier gives the F0FF

tonyrogerson — Thu, 03 Apr 2008 05:45:02 GMT

Yep - this was an April's fool joke :)

Many thanks for the entertainment Colin - I'll be pulling your leg for ever more at UG meetings.

Tony.

Interesting Finds: March 29, 2008

Jason Haley — Wed, 02 Apr 2008 01:37:58 GMT

re: Rude easter egg in SQL 2005 - Uniqueidentifier gives the F0FF

GrumpyOldDBA — Tue, 01 Apr 2008 15:28:06 GMT

see my second comment shortly after didn't arrive - suppose it spells april fool with a cast to something?

re: Rude easter egg in SQL 2005 - Uniqueidentifier gives the F0FF

GrumpyOldDBA — Tue, 01 Apr 2008 11:52:21 GMT

hmm .. April Fool eh? I suppose if you cast back to something it'll read april fool?

re: Rude easter egg in SQL 2005 - Uniqueidentifier gives the F0FF

GrumpyOldDBA — Tue, 01 Apr 2008 11:48:27 GMT

Can't reproduce this sorry. Vanilla install, w2k3 r2 sp2, sql dev x32, regional settings for server is UK. Standard install of sql 2005 with windows default collation.

as base install can't reproduce, installed sp1, still can't reproduce.

tried changing login default language.

my sp2 sql boxes don't do this. I can leave the sql at sp1 for a little while if you have any other config changes I should make?

Interesting Finds: March 29, 2008

Jason Haley — Sat, 29 Mar 2008 15:33:51 GMT

http://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/11/10/1280.aspx

http://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/11/10/1280.aspx — Sun, 23 Mar 2008 07:25:49 GMT

Pingback from sqlblogcasts.com/.../1280.aspx

Interesting Finds: March 22, 2008

Jason Haley — Sat, 22 Mar 2008 15:04:23 GMT

SQL shorts

SQL Server Blog by Jason Massie on SQL Server 2005 and SQL Server 2008. — Fri, 21 Mar 2008 18:36:35 GMT

re: sp_send_dbmail in a transaction with @query causes unresolvable deadlock

AndyC London — Tue, 18 Mar 2008 17:19:01 GMT

If they read their own documentation... then they should use srv_getbindtoken in the XP to get a token and then exec sp_bindsession before running the query, this puts the loopback connection into the same connection as the initiating one.

However, I'd agree with the previous comments, I'd like to see this using the serivce broker instead to queue up the mails. I'm not sure how on one hand they are suggesting that XPs are depreciated and on the otherhand they are still using them, themselves.

When I've seen this scenario, I call them "external deadlocks", I'm not sure if there's a proper name for these.

re: Concatenation with FOR XML and eleminating control/encoded characters

tonyrogerson — Tue, 18 Mar 2008 14:01:21 GMT

I know - they terrible, luckily I avoid XML in the database like a plague!

I guess another way would be CTE but I wonder what performance would be like.

re: Concatenation with FOR XML and eleminating control/encoded characters

simonsabin — Tue, 18 Mar 2008 13:47:37 GMT

The issue with using the .value is that you invoke the XML Reader operators which aren't the best in terms of performance

re: Rampant Frogs Run Riot in Tony's pond Froggy Style

EdVassie — Mon, 17 Mar 2008 13:58:27 GMT

I counted 14 frogs in my pond the other day. All the little spots in the spawn are now turning into commas. Soon they'll be out there eating whever they bump in to.