Viewing 15 posts - 38,461 through 38,475 (of 49,552 total)
Jeff Moden (6/13/2009)
Heh... I've found that many concurrency issues simply vanish in the presence of high speed code.
Agreed. If the queries are running faster, they're locking for shorter periods...
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
June 13, 2009 at 10:21 am
Check the script library here, there are lots of index rebuild scripts there that satisfy your requirements.
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
June 13, 2009 at 10:17 am
Thanks. 😀
I'm presenting two sessions this year, one spotlight and one general (with my 3rd submission marked 'alternate'). I've got one confirmed full session at TechEd Africa as well, plus...
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
June 13, 2009 at 10:17 am
Use sys.indexes instead of sysindexes and you can get the index type as well from the column type_desc. For the columns that comprise the index, join in sys.index_columns
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
June 13, 2009 at 8:25 am
Sergiy (6/13/2009)
I did not find anything in the article which would contradict my point.Or was it in support?
No, it's in contradiction. I do not and never have agreed with 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
June 13, 2009 at 7:55 am
You can never view the estimated exec plan for a proc that creates and uses a temp table. The temp table doesn't exist at compile time, so you get 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
June 13, 2009 at 5:36 am
Aaron (6/13/2009)
**** Can I set READ UNCOMMITTED to write asynchronously to thie "buffer" (current) table?
The READ UNCOMMITTED isolation level only affects locking by selects. All data modifications will still lock....
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
June 13, 2009 at 5:06 am
Which line of code's throwing the error and what's the complete error message?
p.s. SA login and a simple password? I hope that's not what your system's actually using....
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
June 13, 2009 at 5:02 am
More information please. Where was the backup taken from and how was it taken? Where's the backup been restored to and what's the statement that you're running?
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
June 13, 2009 at 4:44 am
What do you mean by 'cannot view execution plan'? If you run the proc in management studio with the "Include Actual Execution Plan" option selected, what happens?
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
June 13, 2009 at 4:40 am
See yesterday's headline article for info on posting performance problems
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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
June 13, 2009 at 4:40 am
Lynn Pettis (6/13/2009)
Who decides who can vote and who can't, Steve?
Exactly the problem.
SO attempts to solve that by giving points for 'good' and 'correct' answers, 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
June 13, 2009 at 4:36 am
dxmer (6/12/2009)
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
June 13, 2009 at 4:16 am
Log backups do not shrink the log. If the physical size of the log file is dropping then there's a shrink database or shrink file operation somewhere. Check maint 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
June 12, 2009 at 12:57 pm
Compressed backups (either native SQL 2008 or 3rd party)
Differential backups (maybe)
Striped backups (maybe)
File/Filegroup backups
Fast backup drive(s) with enough space to keep one or two
A carefully designed and well tested 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
June 12, 2009 at 12:31 pm
Viewing 15 posts - 38,461 through 38,475 (of 49,552 total)