Viewing 15 posts - 16,876 through 16,890 (of 22,226 total)
there is just no way to be sure. You have to know all the processes that access the system inside & out. For example, even if you monitor the system...
"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 28, 2009 at 5:42 am
Jeff Moden (7/27/2009)
Grant Fritchey (7/27/2009)
"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 28, 2009 at 5:14 am
Lynn Pettis (7/27/2009)
Kassondra is now on her way to Fort Jackson in South Carolina to start her...
"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 28, 2009 at 5:12 am
I have yet to see someone eliminate code duplication within a database. It's just too easy to start doing... whatever. Generally a good naming convention will tend to inform 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
July 27, 2009 at 12:58 pm
My younger sister had plates that read IODADDY or something like that. I always read them as 'I/O Daddy' like some sort of nifty geek hipster, not 'I owe daddy'...
"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 27, 2009 at 11:52 am
Huge topic. You might want to start off defining your role. Take a look at Craig Mullins book called "Database Administration." It's system agnostic and very useful.
"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 27, 2009 at 11:26 am
If you mean that you intend to use functions instead of referring to the tables or views, excercise a great deal of caution here. An in-line table valued function can...
"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 27, 2009 at 11:20 am
I'm not trying to be obtuse, I just don't understand what you are referring to. Do you mean queries coming from Reporting Services?
"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 27, 2009 at 11:08 am
Oh, sorry, I couldn't tell you. I haven't even seen a beta yet.
"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 27, 2009 at 9:42 am
GilaMonster (7/27/2009)
Roy Ernest (7/27/2009)
"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 27, 2009 at 8:30 am
When you say SQL, do you mean an individual SQL statement? One that is currently running? I'm not entirely sure, but you may not be able to drill down 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
July 27, 2009 at 8:25 am
I'd like to second Gail's suggestion. It sounds like a great candidate for some re-work, re-design & tuning.
"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 27, 2009 at 8:16 am
Roy Ernest (7/27/2009)
"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 27, 2009 at 8:02 am
It could be compiling & storing the execution plan, or it could be caching the data, or it could be both.
We ran into a similar situation once. What we...
"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 27, 2009 at 7:45 am
It's going to depend on the service contract you have with Microsoft. It may be a free upgrade per your contract or it may be added cost. It's not automatically...
"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 27, 2009 at 6:57 am
Viewing 15 posts - 16,876 through 16,890 (of 22,226 total)