Viewing 15 posts - 2,026 through 2,040 (of 2,443 total)
Sergiy (6/5/2009)
EMPID BIGINT - if INT is not capable enough to hold all EMPID's - which company has billions of...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
June 5, 2009 at 8:07 am
Mark (6/5/2009)
jcrawf02 (6/5/2009)
Gianluca Sartori (6/5/2009)
I don't know if this is a proof, but for sure it is "half a proof".Regards,
Gianluca
Does that make it a theorem?
More of a conjecture I think
I...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
June 5, 2009 at 8:02 am
Gaby Abed (6/5/2009)
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
June 5, 2009 at 7:58 am
Gianluca Sartori (6/5/2009)
I don't know if this is a proof, but for sure it is "half a proof".Regards,
Gianluca
Does that make it a theorem?
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
June 5, 2009 at 7:55 am
GSquared (6/3/2009)
I don't have a cat. I have two dogs, and one of them is still dopey from being sedated by the vet yesterday (teeth cleaning). Does that...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
June 3, 2009 at 12:01 pm
Jack Corbett (6/3/2009)
--------------------------------------------------------------------------------
I'm going to have to agree with GSquared on this one. This definitely does not belong in a trigger
In fact, it belongs in the client-side validation before the...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
June 3, 2009 at 10:19 am
tosscrosby (6/3/2009)
Which volume are you referencing? Volume 1, question 53, pertains to maximum RAM for SQL 2000 EE 64bit.
That's the stumper . . .
j/k 😛 - volume 5, sorry.
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
June 3, 2009 at 10:14 am
Tom Brown (6/3/2009)
Before you click on the link, be aware that they OP has posted vast quantities of data - twice - it...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
June 3, 2009 at 9:00 am
Byron, what you need (I think) is the % answered to apply to the cumulative total for the calendar day, and not just the interval? i.e. if I had this:
answered...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
June 3, 2009 at 8:58 am
Adam Machanic (6/3/2009)
select len(cast(year(getdate()) as char)) -- returns 4select len(cast(month(getdate()) as char)) -- returns 1
LEN does an implicit right trim. Try DATALENGTH instead.
beautiful, thanks Chef for helping me remember all...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
June 3, 2009 at 8:44 am
Is there a good way to search for a particular QotD? If I use the search bar, it seems to focus on Articles/Forums/Scripts, even if I put "Question of the...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
June 3, 2009 at 8:26 am
GSquared (6/3/2009)
I hate to sound so quantum (reference to today's cartoon from the front page), but I think the principle of publishing even when there are problems with it, is...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
June 3, 2009 at 8:17 am
I agree with you, Steve. Wish I had a topic to write on (or time) because I'd want to publish on SSC more than anywhere else for that very reason....
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
June 2, 2009 at 12:49 pm
Does every query you run take 10 to 30 minutes to run? Not trying to be impertinent, but is there a possibility for query tuning to decrease the runtime?
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
June 2, 2009 at 7:07 am
Lynn, thank you for that reflection, your intent is appreciated and should be taken to heart. (Romans 12:8 - "As much as is possible, live at peace with everyone.")
Jeff, I...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
June 2, 2009 at 6:48 am
Viewing 15 posts - 2,026 through 2,040 (of 2,443 total)