Viewing 15 posts - 16,381 through 16,395 (of 49,552 total)
No, not as a blanket statement like that.
Depends on the type of inserts (end of index or anywhere), depends on whether updates will grow the row or not. Depends on...
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 28, 2012 at 8:40 am
ChrisM@Work (9/28/2012)
As Gail pointed out, the existing index isn't ideal, but it's close, and I think the estimated lift is wildly out.
The only thing that's not ideal about the existing...
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 28, 2012 at 8:28 am
In that case, you don't need to add another index, the current index will completely satisfy that query.
Now, it's not the perfect index, which is why missing indexes shows 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
September 28, 2012 at 6:18 am
Perry Whittle (9/28/2012)
SELECTt.name
, i.name AS index_name
, STATS_DATE(i.object_id, i.index_id) AS statistics_update_date
FROM sys.objects t inner join sys.indexes i
on t.object_id = i.object_id
where t.is_ms_shipped <> 1
order...
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 28, 2012 at 6:10 am
shield (9/28/2012)
But to be on the safe side ,I want some alternative to DISTINCT please suggest
There isn't one. You use distinct if you need to remove duplicate rows. If there...
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 28, 2012 at 6:08 am
Sure, see if you have full text enabled for it and full text indexes created.
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 28, 2012 at 5:57 am
The existing index isn't perfect for the query (and the missing index DMV lists the perfect index), but it may well be good enough. Is the query slow?
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 28, 2012 at 5:38 am
shield (9/28/2012)
GilaMonster (9/28/2012)
Change the view to use JOINs...
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 28, 2012 at 5:37 am
Why do you say they are not being updated?
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 28, 2012 at 5:36 am
Unless you tested the same query you probably won't trigger any error. Not all queries need workspace memory.
Could it be this:
http://support.microsoft.com/kb/982854
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 28, 2012 at 5:33 am
It's not 'allocated' per se. It's requested by queries and whatever this query requested was more than the resource governor defaults are (which are always in place, regardless whether you've...
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 28, 2012 at 5:11 am
I would recommend to start get rid of the distinct unless it really is necessary. Distinct usually indicates poor design or incorrect queries.
Change the view to use JOINs rather than...
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 28, 2012 at 5:09 am
Then maybe start by reading up on triggers
http://www.sqlteam.com/article/an-introduction-to-triggers-part-i
http://www.sqlteam.com/article/an-introduction-to-triggers-part-ii
http://msdn.microsoft.com/en-us/library/ms189799.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 28, 2012 at 5:08 am
vivekkumar341 (9/28/2012)
Hey please go through the below mentioned link.http://www.codeproject.com/Articles/173275/Clustered-and-Non-Clustered-Index-in-SQL-2005
I'd recommend not reading that. It has some fundamental errors in it.
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 28, 2012 at 5:07 am
Nothing to do with the buffer pool, it's a query that requires more workspace memory than is allowed.
What query is it?
This is not a memory leak.
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 28, 2012 at 5:01 am
Viewing 15 posts - 16,381 through 16,395 (of 49,552 total)