Viewing 15 posts - 6,601 through 6,615 (of 7,484 total)
Craig Farrell (10/13/2010)
October 14, 2010 at 10:58 am
The Dixie Flatline (10/13/2010)
Does this bug anyone else, or should I go back to taking my chill pills?
Go back to the chill pills.
People with a poor grasp of English...
October 13, 2010 at 12:56 pm
Trey Staker (10/13/2010)
Shawn Melton (10/13/2010)
How about this one as a response.:-)Very appropriate response from Gail...I might steal that one sometime. "Measure don't assume" Love it.
It would have...
October 13, 2010 at 12:46 pm
Sahasam (10/12/2010)
Error:
Subquery returned more than 1 value. This is not permitted when the subquery...
October 13, 2010 at 12:38 pm
WayneS (10/12/2010)
Tom.Thomson (10/12/2010)
I just read all the new SQL Tuesday blog entries - first time I've done this. Wow! 😀 Pretty impressive, on the whole.
Hey, first time for me...
October 13, 2010 at 4:54 am
I just read all the new SQL Tuesday blog entries - first time I've done this. Wow! 😀 Pretty impressive, on the whole.
October 12, 2010 at 7:18 pm
dogramone (10/12/2010)
First time I've ever joined a QOTD discussion.
No, there have been far worse. At least in this one the answer was not wrong. And for irrelevance to...
October 12, 2010 at 6:15 pm
Paul White NZ (10/12/2010)
Tom.Thomson (10/12/2010)
It had better be. If it wasn't it would often get the boundary consitions wrong!
Yes but even if it did get the boundaries wrong, it...
October 12, 2010 at 6:07 pm
Steve Jones - SSC Editor (10/12/2010)
OK, I'm confused. Any ideas? Difference in performance after copying the mdf to a new server.http://www.sqlservercentral.com/Forums/Topic1002991-360-1.aspx?Update=1
The two files are logically the same, but not necessarily...
October 12, 2010 at 12:39 pm
To me the interesting thing is the difference in performance on the production server and on your machine.
We know that the production server is a Windows 2003 server with 1GB...
October 12, 2010 at 12:28 pm
Interesting question with totally useless (or worse than that) explanation.
Thank heavens for Hugo's clear and simple explanation!
October 12, 2010 at 12:13 pm
Paul White NZ (10/12/2010)
October 12, 2010 at 11:43 am
WayneS (10/12/2010)[/b]
I dunno if the fog's denser, but after reading the thread I'm pretty sure I am....
October 12, 2010 at 11:37 am
Welsh Corgi (3/22/2010)
Listed below are some articles on why you should consider using a surrogate or an natural key.:-)http://www.deeptraining.com/litwin/dbdesign/FundamentalsOfRelationalDatabaseDesign.aspx
http://www.agiledata.org/essays/keys.html
http://www.dbdebunk.com/page/page/626995.htm
http://www.dbdebunk.com/page/page/626995.htm
http://en.wikipedia.org/wiki/Surrogate_key
🙂
The first URL quoted soesn't mention surrogate keys at all, the second...
October 12, 2010 at 10:58 am
Paul White NZ (10/10/2010)
TABLOCKX isn't essential in quite the same way, but it seems like a sensible precaution to me, for the reasons Jeff gave.
I think there's another reason as...
October 11, 2010 at 5:16 am
Viewing 15 posts - 6,601 through 6,615 (of 7,484 total)