Viewing 15 posts - 421 through 435 (of 1,825 total)
If you want rows back in a particular order , you HAVE TO specify an order by clause.
Try this entry on my blog for more info...
January 14, 2011 at 2:02 am
January 14, 2011 at 2:00 am
Agreed that an article should not be replaced or removed , after all you can sometime learn a better lesson by doing things the wrong way :-). And as...
January 14, 2011 at 1:30 am
For those that were asking way back when, my sqlbits session is now up...
Constructive criticism welcome 😉
http://sqlbits.co.uk/Sessions/Event7/TSQL_Techniques_Why_and_how_to_tune_a_routine
January 13, 2011 at 11:59 pm
Accepted , but in that case shouldn't they be positioned at the original publication date until he republish date has been hit ?
January 13, 2011 at 7:20 am
Koen (da-zero) (1/13/2011)
January 13, 2011 at 6:18 am
The issue seems to me to be not the performance of the looping per-se , but the execution speed of the dynamic sql that is being built.
Would that...
January 13, 2011 at 5:18 am
Yuck, that is a horrible idea.
You should be able to join the conditions logically or'ing them by this technique
http://www.sqlservercentral.com/articles/comma+separated+list/71700/
Then execute the whole statement as a whole with 'top 1...
January 13, 2011 at 5:04 am
krishnaroopa (1/13/2011)
Recently we replaced cursors with while loop
Ahh , you fell for that one , it is a myth that replacing cursors with a while loop is a good...
January 13, 2011 at 4:33 am
January 13, 2011 at 4:25 am
facticatech (1/12/2011)
Is there a better way to write in a single statement instead of 10 statements like the one above for 10 different columns?
"Better" is always subjective , and...
January 13, 2011 at 1:30 am
You need to whitelist your known good ipaddress on your firewall , this is not a sqlserver issue.
But , this is probably not the best way to handle this .
The...
January 12, 2011 at 8:12 am
It would seem safer to me to whitelist your known ip addresses at the firewall rather than blacklist those 'bad' ones.
January 12, 2011 at 7:05 am
Viewing 15 posts - 421 through 435 (of 1,825 total)