Viewing 15 posts - 11,806 through 11,820 (of 22,219 total)
opc.three (9/26/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
September 27, 2011 at 3:44 am
I don't know what TWS is either. I tried looking it up online but I'm getting crazy stuff like Texas World Speedway. You have to help us. We're not sitting...
"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
September 27, 2011 at 3:42 am
If I were looking at starting an upgrade process right now, yeah, I'd jump on to Denali & skip 2008. Think of it like this, 2008 is already almost 4...
"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
September 27, 2011 at 3:30 am
You can reference a unique constraint when making a foreign key. It's that or a primary key.
"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
September 27, 2011 at 3:21 am
Clustering is all about availability in SQL Server and has nothing at all to do with performance.
If your query is slow, why is it slow? What does the execution plan...
"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
September 26, 2011 at 8:47 am
The traditional mechanism is to move only the data you need to move, when you need to move it.
I would not go for the "move everything, we might need it"...
"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
September 26, 2011 at 8:41 am
The difference is how they're called. If you called a procedure through an execute SQL statement in your code, it'll come in as a TSQL batch. If you explicitly call...
"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
September 26, 2011 at 8:37 am
The two indexes that both start with FiscalYear are questionable. Is that the most selective of the two columns in each index? Meaning, does it have the most unique values...
"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
September 26, 2011 at 5:00 am
Not during a restore operation. You'll have to restore the database first, then drop the number of files.
By the way, I'd suggest leaving a few file groups, even 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
September 26, 2011 at 4:57 am
It sounds like something is pegging the resources. Do you have scheduled events in SQL Server? How about in the OS? Do you have any form of monitoring in place...
"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
September 25, 2011 at 5:55 am
Yeah, it would have to be. That's my understanding of how it works.
Heaps are generally weak tables. They have a place in design, but their use should be relatively exceptional....
"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
September 25, 2011 at 5:53 am
a) It depends. Over the last few years I was, in a very lazy fashion, looking for work. I did some interviews, but I wasn't really serious about it. But...
"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
September 25, 2011 at 5:50 am
Just a question, is SQL SErver the only service running on this machine? If so, give it all the memory it can take (leaving a couple of gb for 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
September 25, 2011 at 5:40 am
For remote queries, to see what they are doing, you must look at those queries on the remote server as well as locally.
"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
September 25, 2011 at 5:34 am
I went back and read the article again because it just doesn't feel right to me somehow and then I saw this:
The more I travel, the more I observe that...
"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
September 23, 2011 at 11:19 am
Viewing 15 posts - 11,806 through 11,820 (of 22,219 total)