Viewing 15 posts - 47,146 through 47,160 (of 49,552 total)
Please don't cross post. It wastes people's time and scatters replies.
Please direct replies to the following thread
http://www.sqlservercentral.com/Forums/Topic472055-150-1.aspx
Thanks
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 20, 2008 at 12:11 am
Shorter transactions means less blocking and less chance of deadlocks. In turn means less work to do. Always a good thing. 😀
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 19, 2008 at 12:45 pm
I have no problem using table variables if the rowcount is low (100 rows is around my threshold) or I'm just going to do a straight select * from @tbl...
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 19, 2008 at 11:45 am
Are there any errors in the sQL error log from around the same time?
does that domain group have access to the DB in question?
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 19, 2008 at 7:33 am
I'm going to go and dig out "Songs of Distant Earth" Both the book and the soundtrack that Mike Oldfield did
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 19, 2008 at 7:11 am
Partially. Is it related to estimated duration as well as to the resources used by the query execution. Look at it as an aprox measure of how much work SQL...
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 19, 2008 at 7:09 am
The cost is an estimate created by the optimiser of how expensive the query is to run. It's not just execution time, also CPU, memory and IOs.
My personal preference, when...
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 19, 2008 at 12:58 am
Jeff Moden (3/18/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 19, 2008 at 12:37 am
Matt Miller (3/18/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 19, 2008 at 12:32 am
Have you checked what the statements are that are involved in the deadlocks?
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 18, 2008 at 9:52 am
Matt Miller (3/18/2008)
GilaMonster (3/17/2008)
Jeff Moden (3/17/2008)
There's a whole lot of minor differences but the big difference is, table variables do not and cannot be made to use statistics.
Yup. And that,...
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 18, 2008 at 9:42 am
Christopher G.S. Johnson (3/18/2008)
Any thoughts on the order of maintenance plan operations - optimization, integrity check and backups?
That should be fine. Just make sure shrink isn't included in...
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 18, 2008 at 9:36 am
What do the execution plans look like?
If you can post the script of the proc and the schemas of the tables (with index definitions), we can offer suggestions.
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 17, 2008 at 1:51 pm
Personally I'd recommend finding the cause of the deadlocks and resolving that (usually bad code or bad indexing) rather than putting nolock everywhere. It can have some interesting effects (read...
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 17, 2008 at 1:48 pm
Litespeed's pretty good. It's used at my company and we haven't had an issue with it.
Regarding the tape backups, test them, test them and test them again. Tapes do fail....
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 17, 2008 at 1:45 pm
Viewing 15 posts - 47,146 through 47,160 (of 49,552 total)