November 14, 2011 at 9:33 am
GilaMonster (11/14/2011)
Sean Lange (11/14/2011)
Funny how we all post the same link and type pretty much the same thing on this topic 2-3 every week.Type?
He doesn't have his mind reader yet. So 20th century! 😀
November 14, 2011 at 9:35 am
Ninja's_RGR'us (11/14/2011)
GilaMonster (11/14/2011)
Sean Lange (11/14/2011)
Funny how we all post the same link and type pretty much the same thing on this topic 2-3 every week.Type?
He doesn't have his mind reader yet. So 20th century! 😀
I had the mind reader installed but the censors got tired of removing all the 4 letter words from my posts and started charging my account 2¢ for each one. After a few thousand dollars from less than 10 posts I had it removed. 😛
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
November 14, 2011 at 9:43 am
To explain... I have a browser plugin that stores snippets of test. So common replies aren't typed, they're just auto-inserted.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 14, 2011 at 9:45 am
GilaMonster (11/14/2011)
To explain... I have a browser plugin that stores snippets of test. So common replies aren't typed, they're just auto-inserted.
Screenshot?
November 14, 2011 at 9:46 am
Sean Lange (11/14/2011)
Ninja's_RGR'us (11/14/2011)
It's only been posted 3 times... not sure it's enough ;-).Yeah apparently we were all three typing at the same time. Kind of scary!!
Not as scary as "read uncommitted" on the forum would be! 😛
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
November 14, 2011 at 9:48 am
GSquared (11/14/2011)
Sean Lange (11/14/2011)
Ninja's_RGR'us (11/14/2011)
It's only been posted 3 times... not sure it's enough ;-).Yeah apparently we were all three typing at the same time. Kind of scary!!
Not as scary as "read uncommitted" on the forum would be! 😛
Why, it's not like the posts are being saved as we type think them! 😀
November 14, 2011 at 9:49 am
Tom Brown (11/14/2011)
OK I've read and inwardly digested the link. :blush:Seems like SNAPSHOT Read committed is one way to go. However if I investigate this and find is what we want, I'm gonna need a help in the argument to persuade our DBAs to implement it.
I've done both snapshot isolation on certain queries, and setting whole databases to read committed snapshot. Wasn't hard to do, and can definitely help with questions your DBAs might have.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
November 14, 2011 at 9:52 am
GSquared (11/14/2011)
Tom Brown (11/14/2011)
OK I've read and inwardly digested the link. :blush:Seems like SNAPSHOT Read committed is one way to go. However if I investigate this and find is what we want, I'm gonna need a help in the argument to persuade our DBAs to implement it.
I've done both snapshot isolation on certain queries, and setting whole databases to read committed snapshot. Wasn't hard to do, and can definitely help with questions your DBAs might have.
+1. Works awesome for SSRS. Just don't set the SSRS "system dbs" with that, tempdb will throw errors on a few reports and you have to hit refresh.
November 16, 2011 at 6:36 am
Ninja's_RGR'us (11/14/2011)
GSquared (11/14/2011)
Tom Brown (11/14/2011)
OK I've read and inwardly digested the link. :blush:Seems like SNAPSHOT Read committed is one way to go. However if I investigate this and find is what we want, I'm gonna need a help in the argument to persuade our DBAs to implement it.
I've done both snapshot isolation on certain queries, and setting whole databases to read committed snapshot. Wasn't hard to do, and can definitely help with questions your DBAs might have.
+1. Works awesome for SSRS. Just don't set the SSRS "system dbs" with that, tempdb will throw errors on a few reports and you have to hit refresh.
Hadn't thought of trying it on those. Just on user databases.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
November 16, 2011 at 6:40 am
GSquared (11/16/2011)
Ninja's_RGR'us (11/14/2011)
GSquared (11/14/2011)
Tom Brown (11/14/2011)
OK I've read and inwardly digested the link. :blush:Seems like SNAPSHOT Read committed is one way to go. However if I investigate this and find is what we want, I'm gonna need a help in the argument to persuade our DBAs to implement it.
I've done both snapshot isolation on certain queries, and setting whole databases to read committed snapshot. Wasn't hard to do, and can definitely help with questions your DBAs might have.
+1. Works awesome for SSRS. Just don't set the SSRS "system dbs" with that, tempdb will throw errors on a few reports and you have to hit refresh.
Hadn't thought of trying it on those. Just on user databases.
I've tried finding the thread that gave me that idea. IIRC, you were on it as well.
Bottom line is certainly don't do it for rstempdb. I didn't test to leave it on the other one.
On linked reports you have to hit refresh to bypass an error. Not much but it gets annoying real fast if you have to load 100 reports / day!
November 17, 2011 at 6:07 am
Ninja's_RGR'us (11/16/2011)
GSquared (11/16/2011)
Ninja's_RGR'us (11/14/2011)
GSquared (11/14/2011)
Tom Brown (11/14/2011)
OK I've read and inwardly digested the link. :blush:Seems like SNAPSHOT Read committed is one way to go. However if I investigate this and find is what we want, I'm gonna need a help in the argument to persuade our DBAs to implement it.
I've done both snapshot isolation on certain queries, and setting whole databases to read committed snapshot. Wasn't hard to do, and can definitely help with questions your DBAs might have.
+1. Works awesome for SSRS. Just don't set the SSRS "system dbs" with that, tempdb will throw errors on a few reports and you have to hit refresh.
Hadn't thought of trying it on those. Just on user databases.
I've tried finding the thread that gave me that idea. IIRC, you were on it as well.
Bottom line is certainly don't do it for rstempdb. I didn't test to leave it on the other one.
On linked reports you have to hit refresh to bypass an error. Not much but it gets annoying real fast if you have to load 100 reports / day!
I bet! (On the hundreds of reports per day)
And if I could remember every thread on this site that I've participated in, I don't think I'd have room in my head for anything else! 🙂
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
November 17, 2011 at 6:17 am
That would explain the oversized brain! 😀
November 17, 2011 at 8:23 am
It has to be oversized, have you seen his list of qualifications - not sure I understand most of them but I'd like to be a qualified ROFL too 😀
November 17, 2011 at 8:26 am
Tom Brown (11/17/2011)
It has to be oversized, have you seen his list of qualifications - not sure I understand most of them but I'd like to be a qualified ROFL too 😀
It's an old(er) tactic. We had a rude & bad poster who had a list of qualifications longer than most retired doctors, all in his signature (all of it in the last few months or ± 2 years).
Most people listened to him instead of us because of that. So a few of us made up a list of crap acronyms to get back on top.
Eventually he left after <a LOT> of arguments with him.
GS is the last one to still have those in his signature.
November 17, 2011 at 8:35 am
Ah ha
No offence intended GS 😉
But I see you have deleted yours quals list Ninja (if you ever joined that game) - I'm sure you would be perfectly within your rights to claim PDQ
Viewing 15 posts - 16 through 30 (of 53 total)
You must be logged in to reply to this topic. Login to reply