Viewing 13 posts - 46 through 58 (of 58 total)
Hmm, really got me interested, but when I ran it on our production OLTP server (24x7), I received an error (below) as well as the total numbers were almost too...
October 16, 2009 at 7:19 am
Interesting article and very timely for me. My big question is how do you detect errors/slow running queries etc? Do you need to run profiler again to detect...
April 8, 2009 at 9:25 am
In Germany, you can get a beer (usually cheaper than soda) at a Burger King or McDs. Also mustard is different.
January 15, 2009 at 12:08 pm
While I agree that the actual travel is a pain, I think just going to a new location and immersing yourself in a different environment is what life is all...
January 15, 2009 at 6:57 am
I don't think the role of DBA is going away, but it is evolving. I remember attending a PASS seminar a couple years ago and Kalen Delaney said right...
December 2, 2008 at 3:55 pm
Well I agree with your statement about being careful with temporary tables, don't ignore them. In many cases I have taken a complex multi-table query and broken it up...
November 17, 2008 at 7:25 am
At my current job I made it (unwritten) a condition of employment that I could attend the PASS conference (or one like it) every year. For the last 2...
August 15, 2008 at 6:26 am
I try and play tennis 2-3 times a week. When I don't have a match scheduled I take group lessons (also helps with the conditioning). On weekends I...
August 8, 2008 at 6:30 am
I've always been a strong proponent of normalization, but it can be carried overboard -- as in the OLTP database I inherited at my current job. It had been...
July 8, 2008 at 1:10 pm
I agree with Phil's attitude dialogue, but want to expand on it. I would be looking for someone that is a "jack of all trades" and enjoys problem solving....
June 20, 2008 at 9:47 am
Nice script, but where is definition (create table) for physical_stats?
June 9, 2008 at 6:52 am
Thanks for the article. I too have wondered about the 'features' that Microsoft has in their SSIS objects. I just completed my first large SSIS project and ran...
April 8, 2008 at 9:22 am
There are times when an index is not needed for a foreign key. If the table is small (low number of rows) or the index column has little selectivity,...
March 4, 2008 at 12:32 pm