Viewing 15 posts - 15,631 through 15,645 (of 49,552 total)
None of those can be merged, they're all distinct indexes.
Whether they're actually required or not you will have to test to determine. Don't accept the index suggestions as requirements, they're...
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 16, 2012 at 5:07 am
naga.rohitkumar (11/16/2012)
1. i followed ur posts and suggested same to my team also but not accepting just they want to reduce onlyy
Then you're going to have to educate your team...
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 16, 2012 at 5:03 am
naga.rohitkumar (11/16/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
November 16, 2012 at 3:17 am
Providing it's IN with a list of values, yes. Trivial to prove, just look at the seek predicate/predicate on the index seek/scan in the exec 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
November 16, 2012 at 1:53 am
thava (11/15/2012)
which is the best way to create this proc, using the if else or my code
Neither.
If, else - http://sqlinthewild.co.za/index.php/2009/09/15/multiple-execution-paths/
Your code - 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 16, 2012 at 1:44 am
Well, sp_dbcmptlevel is deprecated, so is sysdatabases.
ALTER DATABASE ... SET COMPATIBILITY LEVEL and sys.databases.
If you're using 2005 management studio to connect, it's not able to show compat mode 100,...
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 16, 2012 at 1:41 am
You don't have to change it. You probably want to change it to get access to all the new language options, but you don't have to if there's a reason...
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 15, 2012 at 4:13 pm
Nothing wrong with that. Better than trying to do a catch-all type query that can handle any number of optional parameters.
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 15, 2012 at 4:08 pm
The operating system decided that it needed memory (maybe some process, maybe a file copy, etc) and paged SQL Server's memory to the swap file, which is a rather bad...
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 15, 2012 at 1:59 pm
I usually say WITH ROLLBACK IMMEDIATE, that terminates connections and starts the rolback straight way. Depends how important what's currently running against the DB is.
Still, that only starts the rollback,...
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 15, 2012 at 1:57 pm
In that case you have queries that are very sensitive to stats inaccuracies and probably need to identify the tables involved and schedule more frequent stats updates on those tables/indexes/stats.
Edit:...
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 15, 2012 at 12:45 pm
Still not a SQL wait type or latch. There are 13 latches that have the word Cache in their name, 24 wait types that have the word 'latch' in their...
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 15, 2012 at 12:31 pm
There are some things that need lots of TempDB space. Let's take that 850MB table of yours, say a query needs 10% of it and needs to sort the results....
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 15, 2012 at 10:01 am
If a clustered index is created on a heap and one or more nonclustered index exists, all nonclustered indexes will be rebuilt as part of the process of creating 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
November 15, 2012 at 9:38 am
'Catch Latch'? That's not a SQL wait type or latch type. Can you be more specific please?
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 15, 2012 at 7:08 am
Viewing 15 posts - 15,631 through 15,645 (of 49,552 total)