Viewing 15 posts - 30,421 through 30,435 (of 49,552 total)
pankaj.kuchaliya (9/22/2010)
i have to insert near about 5-7k row from different database to current database by using SP. which have been called in Trigger on the basis of date.
Now that's...
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
September 22, 2010 at 11:42 pm
Tara-1044200 (9/22/2010)
both db's are completely identical(tables,strcutures,indexes etc..) except the amount of data.
Amount of data is a major factor in query plans.
Can you try a statistics update on the DB...
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
September 22, 2010 at 11:29 pm
In this case, I'd test out an index (ColumnA, ColumnB, ColumnC, ColumnD) , see what improvements it makes to the 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
September 22, 2010 at 11:25 pm
Sometimes I wonder if people think we're posting for our health or something.
<several people>: Change the index thusly
OP: That won't help.
<couple people>: Did you try it?
OP: That helped a lot.
http://www.sqlservercentral.com/Forums/FindPost990881.aspx
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
September 22, 2010 at 11:24 pm
What's the definition of the index [IX_BusinessData_CityState]?
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
September 22, 2010 at 11:23 pm
Just update stats, or is there an index rebuild job as well? Stats shouldn't generate that much log data (unless you have millions of them). Index rebuilds will.
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
September 22, 2010 at 11:22 pm
Please can you post the execution plans as .sqlplan files? http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
There's a lot of important information which is not present in a copy-paste of part of the text plan.
Table 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
September 22, 2010 at 11:14 pm
Alvin Ramard (9/22/2010)
Dr. Hook song just popped up in my mind. Instead of the "Queen of the Silver Dollar", we've got the "Queen of the SQL Server". 😀
That's...
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
September 22, 2010 at 3:42 pm
Tara-1044200 (9/22/2010)
if you need sqlplan file of the execution plan , please check the atatchements.
What attachments?
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
September 22, 2010 at 3:28 pm
sysprocesses
However, having being where you are, a 2 minute poll to that table is not adequate. It does not take 2 min to connect, change data and disconnect. Rather go...
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
September 22, 2010 at 2:31 pm
For SQL 2000? Pretty much only feasible option is server-side trace.
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
September 22, 2010 at 2:15 pm
Earliest version that you can use login triggers is SQL 2005 SP2. SQL 2000 does not have any form of DDL trigger.
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
September 22, 2010 at 2:10 pm
CirquedeSQLeil (9/22/2010)
GilaMonster (9/22/2010)
*mutter* blah, waffle, blah.Long Hair white cat got your tongue?
DFsdjgjkd mljddsa???? Swew wejfdkuw!
http://picasaweb.google.com/GilaMonster.za/Cats#5235783254328183410
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
September 22, 2010 at 2:00 pm
*mutter* blah, waffle, blah.
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
September 22, 2010 at 1:44 pm
Blah blah blah
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
September 22, 2010 at 1:44 pm
Viewing 15 posts - 30,421 through 30,435 (of 49,552 total)