Viewing 15 posts - 436 through 450 (of 452 total)
Why not just do (using the function definition and parameters (and the @firstDate variable) as given):
set @firstDate = dateadd(dd,1-datepart(dd,@inputdate) ,@inputDate) -- ensures that we start with the first of the...
August 21, 2009 at 11:52 am
Jim in Arizona (8/20/2009)
I think the 30% of us (me included) that got it wrong just need to make sure we get our morning caffiene before trying to answer the...
August 20, 2009 at 10:45 am
Mark Horninger (7/14/2008)
Bill Whitman (7/14/2008)
oberhardt is correct.A maintenance plan should be set up to truncate, shrink, and backup the transaction log -- nightly, if necessary.
Probably don't want to...
August 7, 2009 at 7:32 am
The <strong> tags are clearly an issue with the CMS here; I've seen it in a few other code samples. I don't know if the preview works with them where...
July 29, 2009 at 7:36 am
Carlo Romagnano (7/23/2009)
Lynn Pettis (7/23/2009)
There really should have been a third choice: It Depends. It really does, what data type is being converted to what data type?
For example you...
July 23, 2009 at 11:19 am
Interestingly enough, the MSDN documentation linked to from the answer incorrectly states:
"In this case, the number of characters that are returned is the largest value of either the sum of...
July 10, 2009 at 11:01 am
I think it comes down to personality. I find two classes of personalities in this business: those that overgeneralize, and those that don't. 😛
Okay, seriously, the personality trait I look...
June 19, 2009 at 8:36 am
I think this was a very useful article, because it highlighted a difference we sometimes forget between T-SQL and procedural code. Specifically, procedural code like
set value1 = value2
set value2 =...
May 27, 2009 at 8:34 am
I can definitely see some use for this.
Even if I had no use for it at all, it's a very interesting academic exercise. I'm looking forward to seeing how you...
May 11, 2009 at 11:03 am
Here's how I see the difference. It may help you to understand the order of execution, or it may just confuse you, but it's how I read the statements semantically....
May 7, 2009 at 11:46 am
Sylvia is actually right when she says that there's no need for aliases in author-title query. But Jeff is right when he says that code is not written well for...
May 7, 2009 at 8:54 am
jwheeler (4/27/2009)
Samuel Vella (4/27/2009)
jwheeler (4/27/2009)
The fact you even have to tell so called developers this stuff is frightening.
Not really and it's something I've seen a few times...
When someone has...
April 27, 2009 at 8:07 am
There's also a tweak I would make to eliminate a (very small) chance of failure if the file is put out there literally at the last second. Change
...
...
March 31, 2009 at 9:02 am
It's not just that DBAs have to think of other solutions, but that the entire organization has to want to work to achieve such solutions as well.
As an example,...
February 12, 2009 at 7:37 am
Viewing 15 posts - 436 through 450 (of 452 total)