Viewing 10 posts - 1 through 10 (of 10 total)
"...is by using a creation_datetime column and a delete_indicator..."
except that as indicated earlier, at point B, where they want to know what's changed and (roughly) when, they don't got no...
April 13, 2010 at 5:25 am
I honestly didn't think he was being sarcastic.
March 18, 2010 at 7:32 pm
I do agree wtih Jeff Moden's sentiments. Don't arbitrarily change anything unless you're prepared to carry the can for it down the track, because you will. So many bosses are...
March 18, 2010 at 4:24 am
That reminds me of the time I was working with a doctor who had to enter some notes into the system and didn't want to. For diagnosis he typed ":"....
February 17, 2010 at 1:01 pm
Be good to see an alternative article on how to maintain your standards when thrown into a (purely hypothetical of course) BI/Reporting team where:
Nothing is documented and the...
January 19, 2010 at 12:30 am
Ah. Thank you. I also failed to mention the value of using
DBCC DROPCLEANBUFFERS
before running the batch.
January 18, 2010 at 1:21 pm
Also remember that the execution plan will tell you what the relative cost of the queries will be. If you execute both queries at the same time and look at...
January 18, 2010 at 12:55 pm
"...I would like to be able to present the result..."
You might want to leave presentation for a presenation tool rather than doing it with TSQL. For example you could use...
January 18, 2010 at 4:30 am
Closely related to the concept of saying "no" effectively, is the concept of saying "yes" realistically. I have seen countless instances where DBAs and similar IT professionals will commit in...
January 12, 2009 at 4:37 pm
I must be missing something here. The thing I don't get about the whole tally of numbers discussion is why so much time and effort seems to always be devoted...
November 24, 2008 at 2:41 pm
Viewing 10 posts - 1 through 10 (of 10 total)