Viewing 15 posts - 181 through 195 (of 335 total)
All of it seems really strange to me. Views don't rate on this, not even 2 of them? What about user defined functions? And as you point...
June 8, 2009 at 9:47 am
Why does anyone live with buggy behavior. Solve the Issue.
Not everyone has the luxury of solving every problem. If you are overwhelmed with tasks, you have to prioritize....
June 5, 2009 at 11:27 am
Example of where I could probably use this (or a similar) technique: We use SQL Server 2005. I have several SSIS packages that fail at random intervals and at...
June 5, 2009 at 8:56 am
What a great article. And the questions and answers in the discussion have been equally illuminating. Thanks.
May 27, 2009 at 9:04 am
Francis Rodrigues (5/12/2009)
There are not any issues to my knowledge that require the NOLOCK hint for ROW_NUMBER(). I just used it for performance reasons.
Thanks for the clarification. I...
May 12, 2009 at 12:20 pm
Well done article.
Question: I hate to open a can of worms on a different topic, but I'm so curious as to why you specified the nolock hint for...
May 12, 2009 at 9:38 am
Excellent article. I like how you took the time to look up known problems with TDE and to write out a list of issues to take into consideration. ...
May 4, 2009 at 2:37 pm
What a well-written article. I like how you explain things. Also, your writing style is easy to read and the touch of humor keeps me engaged.
Alas,...
April 30, 2009 at 11:14 am
GSquared: I appreciate your balanced cautionary post. Probably taking the analogy too far, your post sparked these thoughts in me (meant to be somewhat funny):
But if there is an...
April 29, 2009 at 12:47 pm
GSquared: Once again, a very big thank you! I've always believed that in my gut, but never had much to back it up. I'm going to show...
April 29, 2009 at 12:24 pm
GSquared: Do you have any references to the studies you mentioned in your previous post? My boss did a search. All she could find was an NSA...
April 29, 2009 at 11:22 am
GSquared: Thanks so much for your comment. One of the things I can't stand is the password rotation requirements at my agency and agencies we have to deal...
April 29, 2009 at 9:47 am
CROSS APPLY isn't much more than a fancy correlated sub-query with all of the same advantages and disadvantages...
Thanks Jeff and Lynn. I knew that CROSS APPLY wouldn't be better...
April 28, 2009 at 9:05 am
the vendor has designed their application to force a row-by-row approach because they don't know any better. So as you say, you don't really have a choice other than to...
April 27, 2009 at 3:58 pm
Viewing 15 posts - 181 through 195 (of 335 total)