Viewing 15 posts - 12,736 through 12,750 (of 22,227 total)
Most of this is available in system tables. What have you tried so far?
"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
April 17, 2011 at 6:14 am
If you are placing a single quote within a string like this : 'O'Sullivan'. It actually has to be marked up like this: 'O''Sullivan' Note, that is two single quotes,...
"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
April 17, 2011 at 6:12 am
The only one Gail didn't address is Update Stats. You'd be best to make that a part of the index updates. Frequency really depends on your system, but I'd say,...
"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
April 17, 2011 at 4:08 am
You'd have to tell me how often it's called before I could tell you if it's a problem or not. I'm not crazy about setting up View SErver state for...
"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
April 15, 2011 at 11:46 am
You have three options, all of them require you to run something on the production server.
You can set up a server side trace, which works just fine and as...
"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
April 15, 2011 at 11:44 am
I agree. No way to know without discussing the details. A maintenance plan can just backup logs. I'd suggest that should be run many times a day, let alone X*7...
"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
April 15, 2011 at 11:40 am
Laura Schmalzbauer (4/15/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
April 15, 2011 at 11:38 am
Kenneth Wymore (4/15/2011)
Doctor Who 2 (4/15/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
April 15, 2011 at 9:16 am
Kenneth Wymore (4/15/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
April 15, 2011 at 9:14 am
Although, now that I'm thinking on it, you might want to take a look at Red Gate SQL Multi-Script[/url]. It might provide you with a bit more flexibility and power...
"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
April 15, 2011 at 6:08 am
I don't completely understand the situation, but if you need to run custom queries and respond to those results, yes, you probably need to build that yourself. But it won't...
"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
April 15, 2011 at 6:02 am
If you're doing the detach/attach, you might (might) be able to get away with it. Test it before-hand. You should test everything anyway.
"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
April 15, 2011 at 6:00 am
The database structure is not published. You can get some of it from the SDK documentation. I'd start there.
"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
April 15, 2011 at 5:47 am
Frankly? I've died and gone to heaven. I won the lottery. I asked the prettiest girl to the prom and she said yes. My code compiled the first time. 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
April 15, 2011 at 5:29 am
mtassin (4/14/2011)
Grant Fritchey (4/14/2011)
GilaMonster (4/14/2011)
Grant Fritchey (4/14/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
April 14, 2011 at 9:05 am
Viewing 15 posts - 12,736 through 12,750 (of 22,227 total)