Viewing 15 posts - 13,441 through 13,455 (of 22,232 total)
rob mcnicol (1/31/2011)
what tweaks to this process are required to run a server-side trace on analysis services? when i export my Script Trace Definition, the '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
February 1, 2011 at 4:09 am
aMSDeveloper (1/31/2011)
We have a clustered environment and the important database is mirrored. It is a highly transactional database. We also have a RO (Read Only) environment which is also clustered...
"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 31, 2011 at 1:15 pm
ALZDBA (1/31/2011)
jcrawf02 (1/31/2011)
GilaMonster (1/31/2011)
WayneS (1/31/2011)
So... what's your favorite data modeling tool?Pencil and paper (or marker and whiteboard).
Personally, I prefer using Grant
Oh yes ... Grant has sql plans 😉
Grant has 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 31, 2011 at 12:53 pm
WayneS (1/31/2011)
Starting a new job today... I get to use whatever tools I want. I've used ERwin and PowerDesigner in the past. IMHO, ERwin...
"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 31, 2011 at 12:13 pm
I'm not sure, but I frankly wouldn't worry about it. Perfmon is where you should be collecting that data.
"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 31, 2011 at 10:50 am
Brandie Tarvin (1/31/2011)
If the poster said that, I don't blame you for slapping down. The question is, how diplomatic were you?
I wasn't mean or cruel, but I certainly wasn't diplomatic.
"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 31, 2011 at 6:36 am
You're posting in the SQL Server 2005 forum, so you might get answers that don't apply to sQL Server 2000. Just so you know.
I would use a server-side trace. That's...
"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 31, 2011 at 6:35 am
GSquared (1/20/2011)
What I always recommend is, write down a list of questions you need answered about SQL Server, take...
"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 31, 2011 at 6:31 am
Ninja's_RGR'us (1/31/2011)
Am I really smarter than the best MS engineer who had 10 000s of hours to...
"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 31, 2011 at 6:30 am
Books Online, the documentation that comes with SQL Server, should be open on your desktop most of the time. It sure is on mine.
After that, you've got here at SSC...
"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 31, 2011 at 6:27 am
I was bad. I was very bad. Just had to slap down a poster, couldn't help it. "Hey, I need a complete system design, thanks." Man I hate those.
"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 31, 2011 at 6:25 am
I would ditch all the query hints entirely. Using hints you're forcing the optimizer and the query engine to do things your way instead of letting them figure out the...
"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 31, 2011 at 6:19 am
I have to say, you're asking for a complete system design on a rather complicated set of requirements, which you haven't completely provided. Many of us are paid to do...
"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 31, 2011 at 6:17 am
Another problem is cross-database dependencies. If you have lookup tables in different databases, you can't use declarative referential integrity, foreign keys, to ensure the consistency of the data. You'd have...
"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 31, 2011 at 6:13 am
My general approach is a little different than others. I tend to cluster on the most frequently accessed path into the data that is also selective enough to index well....
"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 31, 2011 at 6:11 am
Viewing 15 posts - 13,441 through 13,455 (of 22,232 total)