Viewing 15 posts - 22,156 through 22,170 (of 22,232 total)
I thought this was a useful, well written article. Not exactly up to the advertising, but very good. Please, drop a few of the exclamation points next time.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 26, 2005 at 6:04 am
Crossed a picket line in Oklahoma to see "Life of Brian", great movie.
The thing with religion is, it can be quite scary for those of us outside. For example, I...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 18, 2005 at 6:40 am
Woah! Language & morals aren't the same. A person can be morally clean as a whistle while using a nice anglo-saxon word in every sentence uttered. They'd be rude (possibly,...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 18, 2005 at 6:22 am
You're an evil man. I like it. Thanks for sharing the secret.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 18, 2005 at 6:08 am
Steve,
Your response was a giant disapointment. You didn't tell us what ch*** is? What's up with that. Huge let down. I'm surprised they let you post here. ![]()
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 17, 2005 at 1:42 pm
May be so, but to be honest, one could argue that artificial keys over natural keys is simply a personal opinion, albeit one a bit more applicable to the subject...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 17, 2005 at 10:34 am
I found the article interesting and entertaining. The amount of vitriol it's generated is pretty surprising considering how mild the article was overall.
One comment about interviews from the interviewer side....
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 17, 2005 at 10:09 am
Even though you're running through Query Analyzer, I'll bet you're connecting through ODBC instead of through a native connection. Take a look in Control Panel at the ODBC settings. Either...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 19, 2005 at 5:30 am
Everything everyone else said, plus, you can split off storage of text columns into a seperate file to keep maintenance of the text information seperate from the rest of your...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 19, 2005 at 5:26 am
Thanks for the info. What types of maintenance headaches did you run into specifically? Disk space is kind of hard to argue, it being so cheap these days, but other...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 18, 2005 at 1:05 pm
I ran a search on the MS site and it looks like you may be behind on a service pack or two.
http://support.microsoft.com/kb/825197
http://support.microsoft.com/default.aspx?scid=kb;en-us;330307
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 18, 2005 at 7:29 am
It kind of depends on what you need. I'm pretty lucky at my company and we've got both Embarcadero DBArtisan and Quest Central. For object management, generating scripts, that sort...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 18, 2005 at 7:23 am
Pretty straight-forward. ODBC has a query timeout setting. You've got options. Set the timeout higher. Tune the queries you're running so that they're faster. Verify the indexing strategy is good...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 18, 2005 at 7:18 am
Good news. You've got an index allocation error. Easiest kind to fix. Drop the index and recreate it. Make sure you've got the recreate script handy prior to dropping of...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 14, 2005 at 8:07 am
One thing not mentioned, is there a difference in parameters being passed by the various users? Are the first three calling proc A and passing in a parameter that returns...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 14, 2005 at 7:18 am
Viewing 15 posts - 22,156 through 22,170 (of 22,232 total)