Viewing 15 posts - 13,186 through 13,200 (of 22,219 total)
That's the right approach, if, your client and their business model just wants the historical aggregation information. If they want more, as you say, you're stuck. I can't tell you...
"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 20, 2011 at 5:36 am
Best advice I can give you is to read the documentation so you know what you're doing. It's available online here.
Do the standalone install. By and large if you accept...
"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 20, 2011 at 5:30 am
Craig Farrell (2/20/2011)
For anyone curious, my opinions on the SQLSaturday #47 event in Phoenix.http://www.sqlservercentral.com/Forums/Topic1066836-1199-1.aspx
All in all, a very satisfying day.
Sounds like a good event. Sorry I couldn't make that one.
"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 20, 2011 at 5:26 am
You're retrieving 92k out of 95k from the table. There's no real way to speed that type of data access up. You're going to get scans, and you're dependent on...
"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 19, 2011 at 8:58 am
mazzz (2/18/2011)
The CXPACKETs as far as I could tell were waiting on PAGEIOLATCHes. 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
February 18, 2011 at 10:54 am
What do the wait stats look like? What are the processes on the server waiting for? That'll help you determine the biggest pain points.
"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 18, 2011 at 9:44 am
You have to start troubleshooting the system. First, are all users on all applications on all databases suffering, or only some? That help determine where to look. Have things been...
"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 18, 2011 at 8:28 am
avinashily (2/18/2011)
i have a table with the following data types defined for the columns,
a nvarchar(50) not null,
nume numeric(18,0) not null,
time1 datetime null,
variab nvarchar(max) null,
abc text null,
numcha nchar(20) null,
can you...
"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 18, 2011 at 8:24 am
I'll also add one to the list, hash tables and work tables created as part of execution plans.
"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 18, 2011 at 8:18 am
I'll go Roy one step further and suggest that you have to approach the index hints with extreme caution, especially if it's adding a large list of INCLUDE columns.
It sounds...
"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 18, 2011 at 8:16 am
I've found through a lot of testing that the use of ROW_NUMBER when returning more than a few rows has a tendency to degrade faster than using a TOP 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
February 18, 2011 at 6:55 am
mstjean (2/17/2011)
Point taken regarding indexing. Let me ask a smaller question: The query...
"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 18, 2011 at 6:29 am
Brandie Tarvin (2/17/2011)
You people are strange.@=)
You're just noticing?
"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 17, 2011 at 12:48 pm
Unfortunately your tests are quite fair. You need to have an index on a column so that you see if the implicit conversion causes a problem or not. You had...
"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 17, 2011 at 12:40 pm
There must be duplicate data in Table1 or rows already exist in Table2.
"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 17, 2011 at 10:46 am
Viewing 15 posts - 13,186 through 13,200 (of 22,219 total)