Viewing 15 posts - 20,551 through 20,565 (of 49,552 total)
I think you also may need this:
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
February 6, 2012 at 8:25 am
Jeff Moden (2/6/2012)
Have any of you actually seen him post any code?
Oh yes, I've seen him post lots of code. Never any of his own though...
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
February 6, 2012 at 8:16 am
Please post table definitions, index definitions and execution plan, as per 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
February 6, 2012 at 8:15 am
Is it bad form, if you create a QotD, to list your own article as a reference?
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
February 6, 2012 at 8:15 am
Maybe
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
February 6, 2012 at 8:09 am
And another:
http://www.sqlservercentral.com/Forums/FindPost1247310.aspx (question on table variable, temp table, CTE or subquery, reply on best practices for using Hitachi Universal Storage Platform VM)
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
February 6, 2012 at 8:06 am
Steve Jones - SSC Editor (2/6/2012)
HowardW (2/6/2012)
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
February 6, 2012 at 8:04 am
Try ALTER INDEX ... REORGANISE (not rebuild, rebuild doesn't do anything to the LOB pages) and use the LOB_COMPACTION option.
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
February 6, 2012 at 8:02 am
Grrr...
1 - http://www.sqlservercentral.com/Forums/Topic1247308-391-1.aspx An article on SVVM in reply to a question on SQL versions.
2 - http://www.sqlservercentral.com/Forums/Topic1247195-392-1.aspx A while loop to delete all the rows in a table is more...
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
February 6, 2012 at 8:00 am
mohan.pariveda 18256 (2/6/2012)
Yes, i have to delete the complete data(~5 million) from the table . So can i go with truncate option?
Yes, if you are going to clear the table...
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
February 6, 2012 at 7:59 am
johnitech.itech (2/6/2012)
ok show link belowhttp://fawzi.wordpress.com/2010/12/04/upgrade-vmm-2008-r2-to-sp1/
Did you even read that article before you posted it?
This post provides step-by-step instructions for upgrading to System Center Virtual Machine Manager (VMM) 2008 R2 Service...
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
February 6, 2012 at 7:57 am
It's only a problem if you enable the 15000 partition feature that was added to 2008 SP2. Otherwise the upgrade is fine.
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
February 6, 2012 at 7:02 am
That is horrible mismanagement of the log.
Please read through this - Managing Transaction Logs[/url]
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
February 6, 2012 at 6:42 am
p.s. The procedure you posted and the code in the deadlock graph don't match.
Take those rowlock and nolock hints out. The rowlock's not going to help, without indexes 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
February 6, 2012 at 6:41 am
They're in the deadlock graph (and you have no selects in that procedure, so it can't be a select)
- <deadlock-list>
- <deadlock victim="process52fe8e0">
- <process-list>
- <process id="process52fe8e0" taskpriority="0" logused="0" waitresource="OBJECT: 6:751341741:0" waittime="1625"...
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
February 6, 2012 at 6:39 am
Viewing 15 posts - 20,551 through 20,565 (of 49,552 total)