Viewing 15 posts - 7,156 through 7,170 (of 9,707 total)
Brandie Tarvin (10/19/2010)
GilaMonster (10/19/2010)
Help me do the impossible: http://www.sqlservercentral.com/Forums/Topic1006743-357-1.aspxAdded in a second penny. Hopefully that'll equal two cents worth.
And he seems to have responded well to all our responses. He's...
October 19, 2010 at 6:32 am
GilaMonster (10/19/2010)
Help me do the impossible: http://www.sqlservercentral.com/Forums/Topic1006743-357-1.aspx
Added in a second penny. Hopefully that'll equal two cents worth.
October 19, 2010 at 6:21 am
In addition to the maintenance plans listed above, you should also code a job that checks file sizes verses available disk space to make sure you aren't running out of...
October 19, 2010 at 6:19 am
A few notes. Use Truncate instead of Delete. Truncate logs only the extents being deleted, not the entire record like Delete does. Hence, it's quicker. Also, be aware that using...
October 19, 2010 at 6:12 am
Quick note that has nothing to do with resolving your problem, but could save you a lot of typing. You don't have to Declare each variable on a separate statement....
October 19, 2010 at 5:49 am
The only thing I can think of at this point is either that the GUIDs already exist in the table that you're trying to load the Excel sheet into or...
October 19, 2010 at 4:31 am
Please start a new thread for your question. Most people consider this one resolved and won't answer.
October 19, 2010 at 4:28 am
Stefan Krzywicki (10/18/2010)
Which is great and correct for light, but pigment is exactly the opposite. White is an absence of all pigment, black is a combination of all pigment.
Not quite...
October 19, 2010 at 4:23 am
Stefan Krzywicki (10/18/2010)
The Dixie Flatline (10/18/2010)
I once heard two brothers argue (inconclusively) about whether or not black and white were colors. Opinions anyone?
My opinion is that brothers...
October 18, 2010 at 12:42 pm
The Dixie Flatline (10/18/2010)
I once heard two brothers argue (inconclusively) about whether or not black and white were colors. Opinions anyone?
How about scientific fact?
Color is just the...
October 18, 2010 at 12:41 pm
Brandie Tarvin (10/18/2010)
As far as your primary key violation goes... Is the GUID in the Excel file or are you defaulting on that?
Please answer this question.
October 18, 2010 at 11:46 am
Steve Jones - SSC Editor (10/18/2010)
Aren't most trees green?
Ahem. Trees are brown (some are white). The leaves (or needles) are green.
There's a difference. @=)
EDIT: Opps. Missed your rebuttal. Still stand...
October 18, 2010 at 11:31 am
Adding an aggregate to previously-coded statements and forgetting to add a Group By.
DOH.
October 18, 2010 at 10:36 am
Viewing 15 posts - 7,156 through 7,170 (of 9,707 total)