Viewing 15 posts - 18,091 through 18,105 (of 49,552 total)
Evil Kraig F (6/13/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
June 13, 2012 at 12:43 pm
Nope, they're available now.
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, 2012 at 11:39 am
imSQrLy (6/13/2012)
Yes that's exactly what i mean. Can you point me in the direction as to how to figure out which one they are?
Not sure there is a way.
If they...
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, 2012 at 10:45 am
If you mean things like #78F2A3, they're one of two things
* Table Variables
* Cached shells of temp tables that SQL has noticed are often used. Done to reduce contention 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
June 13, 2012 at 10:28 am
Indexing foreign keys is a good first step in an indexing strategy for a DB.
http://sqlinthewild.co.za/index.php/2011/11/11/sql-university-advanced-indexing-indexing-strategies/
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, 2012 at 10:17 am
Few problems
There's a missing comma after the log file's physical name (which is what causes that error)
You've given the data and log files the same logical name. File names must...
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, 2012 at 10:13 am
I've sped up a lot of procedures recently by removing SELECT ... INTOs and changing the procedures to work directly off the base tables. Try that if it's possible, see...
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, 2012 at 8:54 am
Yeah, first set your server's max server memory to a sensible value. For 144GB of memory, that would likely be around 130GB
Taking a few steps back... Why is a SELECT...
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, 2012 at 8:35 am
Typically with this kind of setup I would make the OrderDate the clustered index and have the PK be a nonclustered index. Makes things a little easier (not much 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
June 13, 2012 at 8:04 am
Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/, the one with the inline function as those are easier to optimise.
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, 2012 at 6:14 am
Depends on what you're doing. The in-line TVF will probably be fine if you can use 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, 2012 at 6:07 am
Please note: 8 year old thread that dates back from before SQL 2008 exited.
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, 2012 at 5:54 am
Sony Francis @EY (6/13/2012)
No effect when you index a nvarchar column.
By 'No effect', you mean??????
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, 2012 at 5:49 am
jeff.mason (6/12/2012)
GilaMonster (6/12/2012)
jeff.mason (6/12/2012)
Interesting that Prometric is updated but that the MCP website is not.
On the MCP site it states that it can take up to 7 days for 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, 2012 at 4:25 am
glamourth (6/13/2012)
Also, it should automatically kill queries that are running more than 60 minutes.
Why on earth would you want to do that, unless your goal is to seriously anger your...
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, 2012 at 4:23 am
Viewing 15 posts - 18,091 through 18,105 (of 49,552 total)