Viewing 15 posts - 17,896 through 17,910 (of 22,226 total)
Just open up the Server Properties in SSMS. On the Processors page you can see how many processors you have available and set them to a particular affinity. I'd suggest...
"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
March 30, 2009 at 6:54 am
When you say reads, do you mean STATISTICS IO in SSMS? Or you are referring to execution times? There is a difference there since SSMS is still showing milliseconds and...
"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
March 30, 2009 at 6:49 am
I'm on LinkedIn, Plaxo & Facebook, but I probably don't open them more than once a week at the most and then for only a few minutes. Twitter on 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
March 30, 2009 at 6:24 am
Jeff Moden (3/29/2009)
Heh... it's all your fault, ya know? Our conversations about 3 months ago are what started it all.Thanks for the feedback, Grant.
Excellent. I'll take full credit 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
March 30, 2009 at 6:13 am
Excellent. Congratulations and good luck.
"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
March 29, 2009 at 2:02 pm
Depending on how the data is distributed, what kind of data, etc., you might want to look into partitioning. This would allow most of the data to be online and...
"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
March 29, 2009 at 2:00 pm
If you don't have windows authentication enabled anywhere, then you might be in trouble. There's no way to hack past the password (even if there was, this is not 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
March 28, 2009 at 6:12 am
I don't quite get the question either. If you read the foreign key constraint, it's going to tell you which table is constraining. From there you can either simply select...
"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
March 28, 2009 at 6:11 am
Whatever this job is, I hope it's not too intrusive to the system since it sounds like it's going to be running 24/7. If you're inserting or updating data all...
"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
March 28, 2009 at 6:09 am
Jeff Moden (3/27/2009)
How about the uplifting and ever popular [font="Arial Black"]"RBAR - Death by SQL" [/font] 😀
I don't know. That sounds... almost... on topic. :hehe:
"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
March 27, 2009 at 6:54 pm
Kendal Van Dyke (3/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
March 27, 2009 at 6:38 pm
You can create clustered and nonclustered indexes on temp tables.
Syntax is like this:
CREATE INDEX myindexname ON schemaname.tablename(col1,col2)
INCLUDE (col3)
WITH FILLFACTOR=80
ON Primary
That creates an index consisting of two columns which includes...
"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
March 27, 2009 at 1:30 pm
NO!
Never run the Profiler gui against Production.
It uses a completely different mechanism for gathering the data to present from what the server-side trace uses. This mechanism can, and 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
March 27, 2009 at 1:08 pm
Roy Ernest (3/27/2009)
Grant Fritchey (3/27/2009)
You can get them from the client.
On which client? Normal Web App that uses the Sproc?
I meant the data access layer, regardless of how it's displayed....
"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
March 27, 2009 at 9:41 am
suhasini.m (3/27/2009)
I am running both the quries at the same time and also doing DBCC DROPCLEANBUFFER and DBCC CLEARPROCCACHE before for both the queries.
If this 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
March 27, 2009 at 9:40 am
Viewing 15 posts - 17,896 through 17,910 (of 22,226 total)