Viewing 11 posts - 1 through 11 (of 11 total)
I'm having the same issue. Any help with this would be appreciated.
March 21, 2009 at 12:30 am
Good idea. Thanks for the advice. Unfortunately, the issue comes up once ever few months, so it is hard to know for sure if it is resolved. ...
February 6, 2009 at 12:19 pm
The issue I'm having is that on a SQL 2005 box running Analysis Services 2005, I also want to install the management console for Analysis Services 2000 (so I can...
June 23, 2008 at 8:26 am
To recap...is the consensus that using non-fully qualified object names, including for tables, stored procedures, and other objects, will have a performance hit for both SQL 2000 and SQL 2005?
March 10, 2008 at 10:16 am
Jereme Guenther (10/25/2007)
October 26, 2007 at 9:41 am
Great example, and thanks for the info on the MERGE functionality. A question about usage...
With this syntax:
WHEN SOURCE NOT MATCHED THEN
Can I put other things in there...
September 11, 2007 at 8:39 am
Nice bit of knowledge. My issue would be that there are other factors that could affect the performance of the backup - especially network latency. We should keep this in...
June 12, 2007 at 8:15 am
"Sarcasm or not, this is where you should have made the effort to talk to the end users"
I think something is missing here. Not every developer has the exposure to...
April 30, 2007 at 8:35 am
By checking the square root outside of the select statement, you will save the processor a number of extra calculations. I modified it to be this:
SELECT @NextIntSqrt = SQRT(@NextInt)
January 29, 2007 at 8:49 am
I like the trick for handling the DATEFIRST. With it, you can write the function in 3 lines without recursion, which I think is a bit more elegant.
CREATE FUNCTION dbo.fnGetNextBusinessDay...
November 3, 2006 at 9:34 am
I really liked the script that will traverse the FK hierarchy. However, it looks like it will only work as long as there is no recursiveness - if a table...
May 31, 2006 at 12:48 pm