Viewing 15 posts - 22,246 through 22,260 (of 49,552 total)
Ok, and?
You have to make some effort here. I referred you to a very good book in an earlier post. Have you looked at it?
What about the wait stats concerns...
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
November 14, 2011 at 5:28 am
raotor (11/11/2011)
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
November 14, 2011 at 5:26 am
This: http://sqlinthewild.co.za/index.php/2009/01/09/seek-or-scan/
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
November 14, 2011 at 4:27 am
Ok, so it's less than 300. What's normal for your system?
Frankly it looks like you need to either do some serious tuning of your queries, or you need to get...
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
November 14, 2011 at 4:26 am
Lavanyasri (11/14/2011)
Why the SQL server is not releasing the memory ???
Because it's not supposed to. What you're seeing is the expected, documented behaviour. SQL won't release memory unless it has...
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
November 14, 2011 at 4:14 am
Something I keep forgetting...
If you're on 2008 SP2 or later, you should be able to just add OPTION (RECOMPILE) to that query (the non-dynamic form) and get optimal plans for...
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
November 14, 2011 at 3:46 am
SQLRNNR (11/13/2011)
I find the practice of prefixing with tbl_ just a waste of 4 chars in a table name.
Likewise and a waste of time when typing in object...
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
November 14, 2011 at 2:29 am
Dev (11/14/2011)
AND (( = @key) OR (@key = ''))I guess the line above will lead to Index Scan (or can skip the index).
AND (( = @key))
It should go...
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
November 14, 2011 at 2:18 am
You'll need to go for dynamic query
http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/
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
November 14, 2011 at 2:17 am
That's an immensely complex and less efficient way of doing 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
November 14, 2011 at 2:16 am
Dev (11/14/2011)
Never mind. I found the setting to turn on deadlock graphs in sql profiler. Working perfectly now. If anyone else is having this problem, be sure 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
November 14, 2011 at 2:16 am
That was funny. We managed to say just about the same thing, phrased differently, at the same time.
I'm getting so used to being misunderstood and outright ignored that it just...
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
November 13, 2011 at 5:06 pm
Graham-1036457 (11/13/2011)
I guess the answer is No, there is no Naming Convention, other than the prefix of sp_ for Stored Procs which I mentioned.
As I said, sp_ is not 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
November 13, 2011 at 4:59 pm
Don't use the view designer (the management studio query windows don't have a timeout set by default)
Optimise your view.
Timeout is a client setting, SQL Server itself doesn't have query timeouts.
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
November 13, 2011 at 3:23 pm
Graham-1036457 (11/13/2011)
We know that Stored Procedures names are prefixed with sp_
sp_ means system procedure and a procedure with that naming has special resolution rules intended for system objects. It is...
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
November 13, 2011 at 3:17 pm
Viewing 15 posts - 22,246 through 22,260 (of 49,552 total)