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)