Viewing 15 posts - 4,066 through 4,080 (of 7,504 total)
First notice:
[Customer_Business_Subset] starts with a full table scan in stead of an index seek !
([CMS3000_Reports].[dbo].[Customer_Business_Subset].[PK_Customer_Business_Subset])
152802 rows of 49bytes are expected
It wants so resolve [date_deleted] is null
It may be...
February 6, 2009 at 1:06 am
This is a SQL2005 forum .... you had better posted this Q in the SQL2000 one.
1) Check books online regarding filegroups and their behavior.
2) If you have control over to...
February 6, 2009 at 12:44 am
You can do it ... but should you ???
http://www.sqlservercentral.com/Forums/Topic639157-360-1.aspx
February 6, 2009 at 12:38 am
Thank you Max for the very informative refs.
More reasons for our devs _not_ to do decent db design 😉
February 6, 2009 at 12:12 am
Issues with linked servers can be:
- locking at linked server side
- network
- how and where does sqlserver solve the query to be executed at the linked server (full at linked...
February 5, 2009 at 7:47 am
scott_lotus (2/3/2009)
February 3, 2009 at 5:24 am
Oh, you're way behind with service packs :crazy:
You are running the RTM software level.
The url I provided concerns your software level.
SP3 is current and on our servers it runs just...
February 3, 2009 at 4:50 am
Can you post the results for
select @@version
or
Select Serverproperty( 'BuildClrVersion' ) as BuildClrVersion
, Serverproperty( 'Collation' ) as Collation
, Serverproperty( 'CollationID' ) as CollationID
,...
February 3, 2009 at 4:43 am
What's the effect if you alter the sproc using the
With recompile parameter ?
Seems to me cardinallity may be very different when using criteria 1 or 2.
February 3, 2009 at 4:36 am
Can you compare (or even post) the execution plans for both queries ?
February 3, 2009 at 3:34 am
Can you find anyting related in sqlserver errorlog or sqlagent sqlagent.out ?
February 3, 2009 at 3:22 am
Can you post the full dbmail setup ddl ?
(don't post the actual email address, but put in a dummy one)
February 3, 2009 at 2:40 am
kiranmca24 (2/3/2009)
February 3, 2009 at 12:31 am
Are you fetching XML data to a grid ?
I've experienced SSMS with results to grid generating our client antivirus to interfere (not with every select, but every time with the...
February 3, 2009 at 12:22 am
Is there a VPN in between you and your sqlserver ?
February 2, 2009 at 10:00 am
Viewing 15 posts - 4,066 through 4,080 (of 7,504 total)