Viewing 15 posts - 13,681 through 13,695 (of 22,219 total)
Another vote for Red Gate tools. They're pretty amazing. They primarily will help in development and maintenance. In terms of performance, they have a new tool, SQL Monitor that will...
"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
January 7, 2011 at 1:48 pm
Craig Farrell (1/7/2011)
Donalith (1/7/2011)
"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
January 7, 2011 at 1:42 pm
Do you think Documentum or SharePoint are the best document management tools? Hard to say right? But they each one use a different schema, so saying, "This schema is best...
"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
January 7, 2011 at 1:34 pm
If I recall the chapters in Kalen's book correctly, there is a strong bias to row locking, but, no you can't really guarantee the locking type, and to a degree,...
"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
January 7, 2011 at 1:26 pm
johnl 80306 (1/7/2011)
"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
January 7, 2011 at 11:10 am
Yeah, it could be an implicit conversion on the date causing the issue. Either way, because the strings are different and the values are different, you can't guarantee that you'll...
"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
January 7, 2011 at 11:08 am
Maybe I don't understand the question, but shouldn't you just modify the process that is running the backups so that it overwrites the file each night instead of generating a...
"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
January 7, 2011 at 10:23 am
Yeah, that's an easy one:
UPDATE SysLog SET Hostname ='eub-dc-psesx-07'
from syslog
WHERE (DateTime >= 'Jan 2 2011 2:40:50:443AM')
AND (IP = '10.20.98.156') AND (Hostname = 'eub-dc-psesx-07') AND (EngineID = 1...
"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
January 7, 2011 at 10:20 am
I know of this book. It's pretty good. It's on the MCM reading list... look down near the bottom of my post.
"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
January 7, 2011 at 8:16 am
If you're working with SQL Server 2008, I'd go for using Change Data Capture. It's going to give you a lot more functionality, easily, than you can build yourself.
"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
January 7, 2011 at 7:56 am
I am a huge fan of upping the cost threshold for parallelism. I'd set it higher, a lot higher, than the default for most OLTP systems I manage. 35 is...
"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
January 7, 2011 at 7:51 am
Obviously, I want my cake and I want to eat it too (and I'll have as much of yours as I can)... or at least that's how most businesses would...
"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
January 7, 2011 at 5:48 am
Indexes can make sort operations run faster. It does depend on what is being sorted, how many rows, what the rest of the query looks like etc. Try it. If...
"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
January 6, 2011 at 12:34 pm
r.pe (1/6/2011)
"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
January 6, 2011 at 8:55 am
I don't completely understand. You're saying that if you ran a query against sys.foreign_keys and sys.foreign_key_columns that you would not see data returned if there are duplicate keys? That's not...
"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
January 6, 2011 at 8:39 am
Viewing 15 posts - 13,681 through 13,695 (of 22,219 total)