Viewing 15 posts - 61 through 75 (of 253 total)
Beatrix Kiddo (6/17/2014)
Andrew, how do you cope with no annual leave? (If that's not too personal.)
Simple! No job I've ever held so far has allowed me to have leave,...
June 17, 2014 at 10:30 am
Ha, you probably have a point :-). However, the sad part is, this place is a massive improvement from my last job! IT jobs in this part of...
June 17, 2014 at 9:42 am
Ah, geez... If only my current workplace could have a less-indispensable view of its programmers :-P.
We work with a vendor software package that has... Interesting... Coding quirks....
June 17, 2014 at 7:46 am
Yep, we're in the same boat as far as compatibility and versions go. We're technically not supposed to be using 2008R2 by the vendor's contract (2008 is the latest...
June 12, 2014 at 12:18 pm
Gotcha :-). Misstep on my part for not looking into whether READ COMMITTED SNAPSHOT was present first. This database is pretty much just a stored procedure container for...
June 10, 2014 at 11:05 am
... *Facepalm* Yep, it certainly does. For some reason, I was thinking that READ COMMITTED SNAPSHOT was also part of the isolation levels in sys.dm_exec_sessions. That...
June 10, 2014 at 7:35 am
GilaMonster (6/9/2014)
Andrew Kernodle (6/9/2014)
EDIT: Incorrect on my part! Tested it just now; issuing BEGIN TRAN and then not doing a COMMIT or ROLLBACK won't hold locks.
It will...
June 9, 2014 at 3:01 pm
Note: My understanding of this may be off in some places; if anyone has corrections for the following, please supply them! 🙂
From what I understand, when you hit...
June 9, 2014 at 2:18 pm
andrew gothard (6/9/2014)
Andrew Kernodle (6/5/2014)
The vendor software we use at my current company has NOLOCK...
June 9, 2014 at 9:48 am
Oh great, now I look at my previous post and I notice I didn't even mention that part :-P. I'm the poster previously known as hisakimatama! Clearly my...
June 6, 2014 at 4:08 pm
Impromptu announcement-of-not-too-much-note time, I suppose!
Decided to switch my posting name from one of my usual online aliases to my own name. Read Brad McGehee's book on becoming an exceptional...
June 6, 2014 at 3:05 pm
Yep, definitely shouldn't be dropping and recreating the index each week. Using Ola's excellent maintenance plan to do REBUILD or REORGANIZE is definitely a better choice, and the root...
June 6, 2014 at 10:13 am
SQLRNNR (6/5/2014)
hisakimatama (6/5/2014)
The vendor software
...
"It's vital to our operations!", and that was that....
June 5, 2014 at 9:54 am
Yep, I've had that problem. Found NOLOCK all over the coding in the vendor-provided software at my current workplace my second day there, and reported it to my supervisor,...
June 5, 2014 at 9:40 am
Argh. I too suffer under the burden of working with code littered with NOLOCK :(.
The vendor software we use at my current company has NOLOCK all over the place,...
June 5, 2014 at 9:28 am
Viewing 15 posts - 61 through 75 (of 253 total)