Viewing 15 posts - 181 through 195 (of 344 total)
What I liked about this article was the trick for search and replace using the IDE. The way I do it could not be used by most people,...
July 13, 2009 at 9:20 am
I don't think that my position is that different from yours.
With all due respect, I think our positions are very, very different and not just a matter of degree or...
June 30, 2009 at 4:19 pm
The problem with multi-page long comment headers (in general), and your suggestion of headers including "where" and "why" (in particular) is that they are more likely to develop inaccuracies over...
June 30, 2009 at 2:31 pm
Information that you'd normally want to know, such as dependencies (which other database objects depend on a given object and which it, in turn, depends on) come for free.
At best,...
June 30, 2009 at 11:29 am
...and give you both credit...
Not me. I don't deserve any credit. I actually do the DROP, *not* alter. I happily include permissions creation at the end of...
June 16, 2009 at 5:01 pm
I appreciate this article and gave it 5 stars. This article went further (as expected) in explaining how test driven development might work at the database level. I...
June 16, 2009 at 11:56 am
I really liked you article not only because it was very easy for anyone to read and understand, but because the tone was polite and not condescending as sometimes happens...
June 12, 2009 at 9:49 am
...enamored of CLR Triggers. It worries me that I'm missing out on a particular advantage of having them.
I would want to know what they are being used for too. ...
June 8, 2009 at 2:36 pm
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
Viewing 15 posts - 181 through 195 (of 344 total)