Viewing 15 posts - 9,046 through 9,060 (of 14,953 total)
I've never seen it cause a difference in results. Not with 2k, not with 2k5, not with 2k8.
Not going to say it can't happen, just that I've never seen...
July 10, 2009 at 1:08 pm
YSLGuru: I completely agree. All advice is circumstantial.
I think what Steve is looking for here is advice that is common, but which is more often bad than not.
July 10, 2009 at 12:21 pm
It was a bad idea, and they've changed their minds on it.
You're right (Steve) that it should never have been made a policy in the first place.
What they've replaced it...
July 10, 2009 at 9:47 am
Auditing the data changes can eliminate/mitigate the risk. I wrote a couple of articles for SSC on that subject, about a year ago.
Making sure all access to the tables...
July 10, 2009 at 9:26 am
Test both versions (convert and dateadd) on a couple of million rows of data.
My tests show the dateadd one is marginally, but definitely, faster. What do your tests show?
July 10, 2009 at 9:22 am
sqlguru (7/10/2009)
July 10, 2009 at 9:20 am
Elliott W (7/9/2009)
July 10, 2009 at 9:11 am
It doesn't eliminate the use of a surrogate identifier, it just hides it from you. That's even per the quote from Celko that you include in your post.
Would be...
July 10, 2009 at 9:03 am
The one I see that I dislike the most is "truncate the log file and then shrink it". That's the right advice in a very, very small number of...
July 10, 2009 at 8:55 am
Bruce W Cassidy (7/9/2009)
Paul White (7/9/2009)
So is COALESCE the only standard SQL function that accepts a variable number of parameters?Just curious.
[font="Verdana"]Hmm. Do you include the variable number of columns...
July 10, 2009 at 6:43 am
On the second one, it's pretty dependent on how I learned that the proc is "slow".
If, for example, a web page is loading slowly, and the users are telling me...
July 9, 2009 at 2:40 pm
Here's what I've got for this. Relies on you having a Numbers table, which is just a table with integers in it, usually from 1 to 10,000.
if object_id(N'tempdb..#test') is...
July 9, 2009 at 2:22 pm
Since when is SSN not externally verifiable?!?!? The fact is, how much do you trust the source?
Are you willing to trust Number 42 Bob more than SSN+Address Bob? See...
July 9, 2009 at 12:39 pm
Hobby databases I've seen:
Cookbook
Game-related data (loot data in World of Warcraft, that kind of thing)
Baseball cards
Music collection
Video collection
Geneology
DBA-related data (links to discussions in SSC, that kind of thing)
Political promises
Any of...
July 9, 2009 at 9:24 am
tylerlaude (7/9/2009)
1. I do not feel I have enough knowledge right now to even take an internship. I want to build my knowledge base first.
2. I...
July 9, 2009 at 9:10 am
Viewing 15 posts - 9,046 through 9,060 (of 14,953 total)