Viewing 15 posts - 17,071 through 17,085 (of 22,226 total)
There really is no way to accurately assess how long a query will take to run. You can have a single row update that should run in about 5ms 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
June 30, 2009 at 8:07 am
Pretty sure that's from an encrypted database Roy. I posted on 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
June 30, 2009 at 7:52 am
Sounds like the database was encrypted. It wants the location of the key files and you'll need the passwords that unlock them.
"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
June 30, 2009 at 7:52 am
All those functions on the columns in the JOINS are going to kill performance. They should have in 2000 as well. Can you post 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
June 30, 2009 at 7:39 am
Two options, identify indexes that are not used or that are too big and eliminate them, as per the previous post. Another option is to upgrade to 2008 and use...
"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
June 30, 2009 at 7:34 am
There is also a lite version of AdventureWorks that includes simpler structures and less data, so that's another alternative (not better, just different) to Northwind. There's also an AdventureWorksDW 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
June 30, 2009 at 7:32 am
GilaMonster (6/30/2009)
Ok, those worked properly.This is seriously weird
It's a secret admirer.
"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
June 30, 2009 at 6:28 am
mazzz (6/30/2009)
I remember reading about the cost figures being estimates, even in the *actual* execution plan - what would one look at instead, to figure out which bit of...
"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
June 30, 2009 at 6:08 am
smsam1 (6/29/2009)
actually what i meant is this, you go through set of values to find a particular value inside that set is comparison,
That would be a WHERE clause within a...
"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
June 30, 2009 at 6:02 am
Yes, it was taken down pending an investigation of violation of the DMCA. Here's more detail [/url]for those that are interested.
"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
June 29, 2009 at 12:13 pm
Passthrough or not, when you send a query up to SQL Server, it gets converted into TSQL syntax because that's the only syntax that SQL Server understands. Although I thought...
"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
June 29, 2009 at 12:03 pm
The question is, how much money do you want to spend. The two tools that I use to do this are System Center Operations Manager from Microsoft and SQL Diagnostic...
"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
June 29, 2009 at 11:59 am
It's using the index on SiteMap2 that has both columns because that makes it a covering index.
Don't use the cost estimates as a measure of query performance. They really...
"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
June 29, 2009 at 11:51 am
charipg (6/29/2009)
As a DBA,1.How to CHECK JOB FAILURES?
SQL Agent in Books Online
2.How to CHECK DISKSPACE?
Performance Monitor counters
3.HOW TO CHECK THE FILEGORWTH ?
Performance Monitor Counters
4.HOW TO TRUNCATE TRANSACTIONAL...
"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
June 29, 2009 at 8:53 am
It is very possible to over-use temp tables and table variables. A lot of developers will load data into a temp table and then go through various joins to other...
"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
June 29, 2009 at 8:23 am
Viewing 15 posts - 17,071 through 17,085 (of 22,226 total)