Viewing 15 posts - 41,896 through 41,910 (of 49,552 total)
Christopher Stobbs (1/7/2009)
Hi Gail,After the first seek is done are the other filters done on the index or resultant dataset return from the first filter(Index seek)
The latter.
The index seek results...
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
January 7, 2009 at 8:57 am
Since all of the filters are inequalities, SQL can only seek on one of them. The other two have to be applied as a second step after the index seek....
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
January 7, 2009 at 8:38 am
winston Smith (1/7/2009)
which is better and why?create index index1 on table1 (col1, col2, col3)
or create index on table1 (col1)
include(col2, col3)
Depends what you're trying to accomplish
The first fully covers and...
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
January 7, 2009 at 8:14 am
Use Statistics IO and Statistics Time when you're investigating the procs themselves, along with the exec plan, to see where the problem points are.
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
January 7, 2009 at 8:09 am
gharris_35 (1/7/2009)
HiI have uploaded the estimated plan. See Estimated Plan.zip
Did you check that before you posted? 😉
Management studio saves plans one at a time, so all that's attached is...
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
January 7, 2009 at 7:22 am
Grant Fritchey (1/7/2009)
Too much information in the Estimated execution plan? I don't understand.
I'm guessing too many plans.
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
January 7, 2009 at 7:16 am
Is there a trigger on the table?
Maybe it's just a phrasing issue, but an update statement is not going to insert anything into the database. It's going to modify 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
January 7, 2009 at 6:34 am
Run profiler and capture the SP_Completed event. That will get you the stats for every proc run.
You could run the proc with the execution plan on and see which queries...
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
January 7, 2009 at 6:33 am
It's created by the optimiser when running queries so that it can get info about the distribution of data in the column, to get a better execution plan.
See this post...
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
January 7, 2009 at 6:24 am
venkatg86 (1/7/2009)
Can i know the Exact cause of this Error. so, i may aware of this and not repeat the same error in future
No idea. The message you posted doesn't...
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
January 7, 2009 at 6:20 am
SQL 2005 caches the structure of frequently used temp tables. It's an optimisation to reduce the impact of frequently creating and dropping the same table. That may be what you're...
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
January 7, 2009 at 5:39 am
There's no way to move a database while it's online.
The two ways to move a DB are the detach/attach method you have, or to do an ALTER DATABASE ......
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
January 7, 2009 at 4:56 am
Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
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
January 7, 2009 at 4:55 am
Post the exact error message, and read this blog post. http://www.sqlskills.com/BLOGS/PAUL/post/TechEd-Demo-Creating-detaching-re-attaching-and-fixing-a-suspect-database.aspx
For what it's worth, you should never detach a suspect or corrupt database, because it will not reattach.
Do you have...
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
January 7, 2009 at 4:52 am
Why are you truncating the transaction log? If you don't want to backup the log and point-in-time recovery is not required, put the DB into simple recovery and leave it...
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
January 7, 2009 at 3:57 am
Viewing 15 posts - 41,896 through 41,910 (of 49,552 total)