Viewing 15 posts - 1,516 through 1,530 (of 7,483 total)
It depends on two things: 1. the frequency of inserts to the table, and 2. whether queries typically access several adjacent rows in the ordering you choose to place on...
Tom
August 2, 2015 at 7:19 pm
Ed Wagner (7/31/2015)
Then again, getting to the heart of the security matter...my "sa" account is disabled as it should be.
I prefer to have no SA account - no SQL logins,...
Tom
August 1, 2015 at 7:24 pm
Jeff Moden (7/31/2015)
jghali (7/31/2015)
Note to self: Always look at the date before posting!!! :hehe:
Did you ever create...
Tom
August 1, 2015 at 7:10 pm
whereisSQL? (7/31/2015)
Eirikur Eiriksson (7/31/2015)
Ray K (7/31/2015)
SQLRNNR (7/31/2015)
eccentricDBA (7/31/2015)
Pawtucket Patriot Ale
Nantucket Nimble Nail
Sam Adams Summer Ale
Rhyming attempts fail
Same
Game
Tom
August 1, 2015 at 6:26 pm
DonlSimpson (7/30/2015)
Luis Cazares (7/30/2015)
Ray K (7/30/2015)
Eirikur Eiriksson (7/30/2015)
Ed Wagner (7/30/2015)
VacationWagon Queen
Drama queen
Dancing Queen
ABBA
Waterloo
Tom
July 30, 2015 at 4:34 pm
Interesting question. Works in current versions but shows bad practise.
Every SQL Server version I have known would do this, but in theory the value returned could be any row...
Tom
July 29, 2015 at 9:51 am
Iwas Bornready (7/28/2015)
robert.sterbal 56890 (7/27/2015)
I always wish they would publish the previous survey and the actual results as well as the current one.That's actually a really good idea.
No, for...
Tom
July 28, 2015 at 4:33 pm
Brandie Tarvin (7/27/2015)
TomThomson (7/26/2015)
Grant Fritchey (7/26/2015)
Managed to get a fully-loaded station wagon (four people plus bags) all the way up to 120MPH (195KPH) on the Autobahn.
Don't get caught at that...
Tom
July 27, 2015 at 8:08 pm
SQLRNNR (7/27/2015)
Revenant (7/27/2015)
Ray K (7/27/2015)
DonlSimpson (7/26/2015)
TomThomson (7/25/2015)
SQLRNNR (7/25/2015)
outre-merultramar
Montreal
Expos
Nationals
GNATS
Bites
Tom
July 27, 2015 at 7:42 pm
Grant Fritchey (7/26/2015)
Managed to get a fully-loaded station wagon (four people plus bags) all the way up to 120MPH (195KPH) on the Autobahn.
Don't get caught at that one in France...
Tom
July 26, 2015 at 1:02 pm
SQLRNNR (7/25/2015)
TomThomson (7/25/2015)
What...
Tom
July 26, 2015 at 12:52 pm
You need to deal with a NULL introduced by the left join - it will produce NULL when there is no appropriate row in the RH table, but the results...
Tom
July 25, 2015 at 4:25 pm
You certainly can have SSMS with SQLS 2008 Express, but the way I did it was to install "SQL Server Express with Tools" rather than the server and the tools...
Tom
July 25, 2015 at 3:50 pm
Actually none of the options is correct. The third is just plain wrong and the others each omit the first column (name) from the returned row.
What is actually...
Tom
July 25, 2015 at 3:35 pm
Viewing 15 posts - 1,516 through 1,530 (of 7,483 total)