Viewing 15 posts - 20,791 through 20,805 (of 22,196 total)
Hey, I lead a pack of Cub Scouts. I'm responsible for teaching them the "Fart Song."
[to the tune "The Yellow Rose of Texas"]
Oh, my body has a passage that...
March 19, 2008 at 11:28 am
Whoa! Hold on. Revelation! People who come out of college are mature adults? Hmmm... To ask this in the proper SSC manner, you have a test that proves that?
March 19, 2008 at 10:43 am
jburkman (3/19/2008)
I've read this excellent thread, I see the vibrant knowledge and experience of the participants, and I'm de-lurking to...
March 19, 2008 at 8:56 am
The default installation of AdventureWorks is case sensitive.
March 19, 2008 at 7:05 am
Oh wow. That is depressing. I'm going to go reread Rendevous with Rama.
March 19, 2008 at 6:56 am
I tried it two ways. I set up a table with a million rows for the tests.
This way works very well, with a nice index seek and only four...
March 19, 2008 at 6:51 am
Crud. I completely misread your question. Disregard my last post. I'm an idiot.
Why can't you simply do a join against your table? Especially since we're talking about a distinct list,...
March 18, 2008 at 12:00 pm
2005 Plan cache is pretty radically different than 2000.
Take a look at at this blog by some of the developers from MS. It might help.
March 18, 2008 at 11:52 am
Execution plans changed because of a recompile? That's a pretty likely possibility.
March 18, 2008 at 11:08 am
Take a look at the OUTPUT clause as a mechanism to capture the data that is inserted as it gets inserted. This is much more effecient, as well as easier...
March 18, 2008 at 7:41 am
If you're getting multiple values from one table, you should probably apply some type of filter either in the ON statement of the join or in the WHERE clause. You...
March 18, 2008 at 5:37 am
After it gets applied, any impact is dependent on the number of rows inserted or updated against which an assertion for this constraint must be made. The more rows immediately...
March 18, 2008 at 5:30 am
Just that when you set up a linked server its available to every database and every user (that has the password, assuming you don't cache it in the connection, making...
March 17, 2008 at 1:28 pm
Steve Jones - Editor (3/17/2008)
I once got a resume with the "Interests" section saying "Eating exotic meats"
I wanted to bring the guy in just to see him, but...
March 17, 2008 at 12:54 pm
Viewing 15 posts - 20,791 through 20,805 (of 22,196 total)