Viewing 15 posts - 18,856 through 18,870 (of 22,219 total)
Itzik Ben-Gan's books, Inside SQL Server 2005 T-SQL Querying and T-SQL Programming. Also the performance tuning one by Kalen Delaney. Joseph Sack's books are fantastic too.
"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 6, 2009 at 9:43 am
Sure, you can have two fields on the clustered index. I'm assuming the cluster is not the primary key, but you can have two fields on the key too.
"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 6, 2009 at 9:04 am
GilaMonster (1/6/2009)
Greg Edwards (1/6/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
January 6, 2009 at 9:02 am
Greg Edwards (1/6/2009)
Grant Fritchey (1/6/2009)
GilaMonster (1/6/2009)
Chris Morris (1/6/2009)
GilaMonster (1/6/2009)
I recommend a 20-sided dice.Six is sufficient...http://en.wikipedia.org/wiki/The_Dice_Man
Maybe for you. 😉 I play D&D. The 20-sided dice is the most important one.
I 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 6, 2009 at 8:59 am
GilaMonster (1/6/2009)
Grant Fritchey (1/6/2009)
I must be old, D&D used lots (and lots and lots) of six-sided dice. Now, Traveller, there were the decimal dice at work.
Which edition was that? 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
January 6, 2009 at 8:58 am
One question, you wouldn't have an outer join to the customer table would you? You have to have a customer to have a call right?
If so, this should work just...
"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 6, 2009 at 8:37 am
From what you're saying, dynamic TSQL is probably the way to go.
In a system where anything can be queried, any way, at any time, performance is usually an issue. It'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 6, 2009 at 8:26 am
I would run a server side trace (which can be generated through the Profiler tool, but shouldn't be run through it) to capture the calls against the database. Once 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
January 6, 2009 at 8:21 am
GilaMonster (1/6/2009)
Chris Morris (1/6/2009)
GilaMonster (1/6/2009)
I recommend a 20-sided dice.Six is sufficient...http://en.wikipedia.org/wiki/The_Dice_Man
Maybe for you. 😉 I play D&D. The 20-sided dice is the most important one.
I have 4, 6, 8, 10...
"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 6, 2009 at 8:12 am
Jeff Moden (1/6/2009)
Grant Fritchey (1/5/2009)
RBarryYoung (1/5/2009)
Actually, I heard from someone at PASS that WITH RECOMPILE does not work reliably for this problem in SQL2005, but "is fixed" in SQL 2008.
WITH...
"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 6, 2009 at 6:30 am
URGENT!
How do you pick indexes... Oh lordy
http://www.sqlservercentral.com/Forums/Topic630357-360-1.aspx
"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 6, 2009 at 6:23 am
I didn't see anyone mention it, but if you're moving scheduled Agent jobs, just script them out on the first server and you can run them on the second. Edit...
"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 6, 2009 at 6:22 am
nairsanthu1977 (1/6/2009)
Can anyone give me some tips on creating indexes in sql server 2005. when to created index on single/multiple columsn etc...
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
January 6, 2009 at 6:19 am
There are some stress tools out there for when you get past the basics of query performance troubleshooting. Quest offers one called Benchmark Factory. Idera used to have one, 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
January 6, 2009 at 6:12 am
nitinpatel31 (1/6/2009)
Any way here is 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 6, 2009 at 6:05 am
Viewing 15 posts - 18,856 through 18,870 (of 22,219 total)