Viewing 15 posts - 871 through 885 (of 5,504 total)
Lynn Pettis (11/11/2011)
What other Threadizins are participating in the DBA in Space contest? Looking for launch buddies!
Done. Care to return the favor? -> buddies
TIA 😎
As a side note: that...
November 11, 2011 at 1:26 pm
You might want to have a look at Bart Duncans blog for a description on how to troubleshoot deadlocks.
November 8, 2011 at 2:32 pm
A rephrase of the original question without providing any additional information doesn't really help any further.
And no, it still doesn't make sense to me.
However, even if there might be no...
November 5, 2011 at 2:29 pm
Based on what formula should the percentage value be calculated?
November 5, 2011 at 2:25 pm
It's hard to help based on the information provided so far.
Please read the first link in my signature and provide some sample data (together with table def and expected results)...
November 5, 2011 at 2:07 pm
What exactly is your question?
In general, formatting should be done at the presentation layer.
If it needs to be done using T-SQL, there are several options.
Which one could be used in...
November 5, 2011 at 2:05 pm
I forgot: you might also want to add an index on dt with balance included to improve performance. Otherwise there'll be additional sort operations that should be avoided.
November 5, 2011 at 10:42 am
Here's a slightly different approach based on the CROSS APPLY method.
One thing making the code more complex is the "interpretation" of the very first balance being the start balance of...
November 5, 2011 at 10:39 am
bitbucket-25253 (11/5/2011)
Have you looked at this article by Jeff Moden. It might give you enough info to solve your problem.
Ron, I don't think it's a running total scenario. It...
November 5, 2011 at 7:40 am
Based on your sample data, what would be the expected result?
November 5, 2011 at 7:23 am
Can you add a computed persisted column based on the run_time column to hold the date value only and add a unique constraint to it?
Probably a better performing solution than...
November 5, 2011 at 6:11 am
dm_tapas (11/1/2011)
Somebody has written from client side. Now it is giving problem to client . so they ask me to tune...
November 1, 2011 at 4:18 pm
Unfortunately, it's a rather common issue...
It seems like the SQL agent does not have appropriate permissions to execute the package.
One recommended solution is to add a proxy account with the...
November 1, 2011 at 2:44 pm
Did you try to insert the xml data into a table with an indexed xml column?
AFAIK, SQL Server does not calculate any statistical information on a variable. Therefore, it can't...
October 31, 2011 at 3:58 am
CELKO (10/27/2011)
October 28, 2011 at 10:41 am
Viewing 15 posts - 871 through 885 (of 5,504 total)