Viewing 15 posts - 47,206 through 47,220 (of 49,552 total)
zubamark (3/7/2008)
2. Always put distinct in subquery.
Don't ever put a distinct in an IN or EXISTS subquery. It's meaningless and may cause SQL to do unnecessary work.
In terms of an...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 7, 2008 at 1:32 pm
The timer is fairly accurate. If you want accurate timings, either use profiler to monitor your queries, or you can run SET STATISTICS TIME ON before you run the query,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 7, 2008 at 8:14 am
Agreed. If you love the job, the money will follow.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 7, 2008 at 8:12 am
Check the full scans/sec counter.
From what I know, read-ahead reads are usually done when a table or index is scanned, and the storage engine fetches pages before they are requested,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 6, 2008 at 12:01 pm
Chris Morris (3/6/2008)
you can't reach the destination of 'best way' without going through 'first way' *.* Except Lynn, Steve, Jeff, Dave, Peso, Gail.....
Hell, no. The amount of times I...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 6, 2008 at 11:45 am
Perhaps I should have said 'not used in the filters' rather than not in the where clause (since there's no where clause)
The red highlight is a join to a...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 6, 2008 at 8:28 am
Loner (3/5/2008)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 6, 2008 at 8:24 am
The index with ProductID first produces an index scan because ProductID is not one of the columns that are filtered on. A query can use an index seek if the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 6, 2008 at 7:28 am
A competant DBA. Even the Best Practices anaylser isn't foolproof
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 6, 2008 at 7:23 am
What does your full scans/sec look like?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 6, 2008 at 6:36 am
I need to confirm this, but I believe it is 'as long as it fits'. Will reseach and confirm or correct later
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 6, 2008 at 6:30 am
You defined the parameter as VARCHAR without specifying a length. If no length is specified, it it 1 character long, essentially VARCHAR(1)
So at the point of the if, @inputval =...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 5, 2008 at 2:37 pm
Looks like a severity 20 error, so there should be more information in the SQL error log and/or the windows event log.
Check them, see if there's anything useful.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 5, 2008 at 2:31 pm
Hehe.
Recently an architect that I was working with put my title down as Database Overlord in a design doc he was working on. That was 3 weeks ago. We're still...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 5, 2008 at 2:23 pm
Interesting.
I seem to recall a presentation where one of the devs of the execution engine spoke about collapsing functions (I don't remember the technical name). Maybe ISNULL is one of...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 5, 2008 at 1:59 pm
Viewing 15 posts - 47,206 through 47,220 (of 49,552 total)