Viewing 15 posts - 16,546 through 16,560 (of 49,552 total)
stevro (9/20/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
September 20, 2012 at 12:20 pm
To start with...
http://sqlinthewild.co.za/index.php/2009/04/29/functions-io-statistics-and-the-execution-plan/
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 20, 2012 at 10:29 am
Andy Hyslop (9/20/2012)
Someone else also asked thishttp://www.sqlservercentral.com/Forums/Topic1361763-149-1.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 20, 2012 at 10:27 am
SELECT LEN('a')
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 20, 2012 at 9:38 am
Be very, very careful with that option. It's undocumented for a reason, it does not always work, it's not completely tested. If it leaves your databases damaged, MS will offer...
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 20, 2012 at 9:30 am
PiMané (9/20/2012)
if I have a table with an index with (col1, col2, col3) and another with (col1, col2) is the 2nd one necessary? will it ever...
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 20, 2012 at 9:22 am
PiMané (9/20/2012)
GilaMonster (9/20/2012)
Use SET TRANSACTION LEVEL READ UNCOMMITTED if the SP has no need to lock records or the NOLOCK
How is a developer going...
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 20, 2012 at 8:49 am
Index key columns, index include columns and either the clustered index key or a RID (depending what the base table is)
You could use something like DBCC Page to pull up...
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 20, 2012 at 7:55 am
There's no real way to see, because there's no reason you'd need to. A nonclustered index contains just the columns specified for the index, for every row in 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
September 20, 2012 at 7:42 am
PiMané (9/20/2012)
GilaMonster (9/20/2012)
* When using multiple parameters on an SP that can be NULL and use WHERE (@prm1 IS NULL OR tbl.Col = @prm1) AND (@prm2 IS NULL...
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 20, 2012 at 7:41 am
It's not just that something else is using the table, that'd just be blocking.
http://www.simple-talk.com/sql/database-administration/handling-deadlocks-in-sql-server/|
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 20, 2012 at 7:37 am
PiMané (9/20/2012)
* SP name patterns (not sure to use usp_... or sp[AppName]_[Action][Table])* Triggers name patters (tr__[action])
Why use prefixes at all? Doesn't add any clarity as to...
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 20, 2012 at 7:28 am
Of course.
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 20, 2012 at 7:16 am
Pretty much. The new page does not have to be page 11, can be any page anywhere in the filegroup.
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 20, 2012 at 4:36 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
September 20, 2012 at 1:41 am
Viewing 15 posts - 16,546 through 16,560 (of 49,552 total)