Viewing 15 posts - 28,651 through 28,665 (of 49,552 total)
Try using local variables in the procedure, as explained: http://sqlinthewild.co.za/index.php/2007/11/27/parameter-sniffing/
Do one at a time, until you find which parameter/variable affects the plan the way you want 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
January 4, 2011 at 5:47 am
My concern is the comment that was next to the definition of kind:
/* Kinds: Sale / Purchase */
If it's 2 values (and nvarchar255 to boot), it's going to be near-useless...
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
January 4, 2011 at 4:32 am
Those two queries are not equivalent.
select * from adventureworks
where id=@id or id is null
This will return any rows from the table where ID column is equal to the value...
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
January 4, 2011 at 4:23 am
Grant Fritchey (1/4/2011)
the PK is not being used to determine access to the table. That at least suggests you should be looking elsewhere for the PK.
Not the PK, 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
January 4, 2011 at 4:15 am
Can you try this, see if it makes any difference?
UPDATE STATISTICS Articles WITH FULLSCAN
The key point is that the plan in the procedure uses a different index on the Articles...
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
January 4, 2011 at 3:41 am
How much SQL experience do you have?
The basic structure of a cursor is shown here:
http://msdn.microsoft.com/en-us/library/ms180169%28v=SQL.100%29.aspx
The first thing you need to do to get this write is to take 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
January 4, 2011 at 3:35 am
No witness means no automatic failover. You can still manually fail over to the mirror, but it won't happen automatically if the principal goes down.
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
January 4, 2011 at 2:35 am
What do the two execution plans look like?
For that matter, what does the query look like as a procedure?
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
January 4, 2011 at 2:17 am
RaviinBne (1/4/2011)
and this goes on...
If you want help checking for duplicate (redundant) indexes, you'll need to post the whole lot, not a sampling
and due to this I am having 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
January 4, 2011 at 12:59 am
That proc is what you use to delete extended properties (and is the only thing that you can use)
Use the view I gave you earlier and you can either run...
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
January 4, 2011 at 12:54 am
Point-in-time is generally possible in bulk-logged recovery. The only time when it's not is when there are bulk operations within the transaction log backup that covers that time period.
So, if...
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
January 4, 2011 at 12:43 am
32 bit and 64 bit are not considered different editions from a licensing perspective. If you buy a licence for SQL 2008 Enterprise edition, you have a licence for SQL...
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
January 3, 2011 at 1:31 pm
Interesting.
I haven't got a kinect yet (too many other things on the hardware shopping list), but if it becomes possible to use it for PC games it's going to move...
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
January 3, 2011 at 1:27 pm
Craig Farrell (1/3/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
January 3, 2011 at 12:50 pm
Edit: No further replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1041962-146-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
January 3, 2011 at 11:24 am
Viewing 15 posts - 28,651 through 28,665 (of 49,552 total)