Viewing 15 posts - 8,971 through 8,985 (of 22,214 total)
If the inconsistencies are internal to the database and not an external storage problem, your approach might (huge, huge, word) be a good approach. Running repair_allow_data_loss is a complete gamble...
February 4, 2014 at 5:58 am
Why not modify the code to use brackets. That will narrow down the issues around naming & special characters.
And I'm with the others. What is the purpose of this code?
February 4, 2014 at 5:55 am
SQLRNNR (2/3/2014)
WayneS (2/3/2014)
SQLRNNR (2/3/2014)
rodjkidd (1/29/2014)
Talking of Grant, did anyone see the picture of him on the SQLCruise yesterday- almost as red as the livery of that company he works for!Rodders...
Why...
February 3, 2014 at 4:11 pm
Please, please, please, no piling on, but I'm curious what you guys think about this: Unreasonable Defaults. I think most of the fundamental info is fine. I'm just... concerned?... with...
February 3, 2014 at 3:58 pm
WayneS (2/3/2014)
Grant Fritchey (2/3/2014)
wolfkillj (2/3/2014)
EDIT: Any word on when Jonathan's book will hit the streets (or "drop", as the kids today seem to say)?
Not a clue. I've gone through three...
February 3, 2014 at 3:50 pm
That's also going to result in a scan because a leading edge wild card can't use an index key.
February 3, 2014 at 11:32 am
My first thought is that you had a different plan in the cache and making the affinity change causes a recompile which helped the issue.
But... I'm not sure about that...
February 3, 2014 at 11:28 am
wolfkillj (2/3/2014)
Grant Fritchey (2/3/2014)
wolfkillj (2/3/2014)
Grant Fritchey (2/3/2014)
wolfkillj (1/29/2014)
February 3, 2014 at 8:09 am
wolfkillj (2/3/2014)
Grant Fritchey (2/3/2014)
wolfkillj (1/29/2014)
February 3, 2014 at 7:54 am
Sean Lange (1/31/2014)
wolfkillj (1/31/2014)
Ed Wagner (1/31/2014)
Luis Cazares (1/30/2014)
Would this help?http://www.sqlskills.com/blogs/kimberly/guids-as-primary-keys-andor-the-clustering-key/
http://blogs.msdn.com/b/sqlserverfaq/archive/2010/05/27/guid-vs-int-debate.aspx
Maybe even a post from a GUID lover:
http://blogs.msdn.com/b/sqlazure/archive/2010/05/05/10007304.aspx
Or even BOL on Using uniqueidentifier Data:
http://technet.microsoft.com/en-us/library/ms190215(v=sql.105).aspx
I especially like Kimberly's article Luis posted here....
February 3, 2014 at 5:31 am
anand.ramanan (2/1/2014)
Your work around for delegating profiler access is intriguing. Could you please take a few moments to share this setup, so it would help the...
February 3, 2014 at 5:13 am
wolfkillj (1/29/2014)
February 3, 2014 at 4:46 am
Greg Edwards-268690 (1/29/2014)
GilaMonster (1/29/2014)
Ed Wagner (1/29/2014)
GilaMonster (1/29/2014)
Could use some of that chill down here. We had a couple of weeks of 35 C+ (high for JHB). Seriously unpleasant.
That sounds seriously...
February 3, 2014 at 4:40 am
rodjkidd (1/29/2014)
Talking of Grant, did anyone see the picture of him on the SQLCruise yesterday- almost as red as the livery of that company he works for!Rodders...
Unless it was while...
February 3, 2014 at 4:37 am
Jeff Moden (1/25/2014)
February 3, 2014 at 3:48 am
Viewing 15 posts - 8,971 through 8,985 (of 22,214 total)