Viewing 15 posts - 4,066 through 4,080 (of 7,502 total)
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
- did you grant the operatorid usage for the mail profile ?
- if you RDC (remote desktop connection) the server, are you able to send a testmail ? (so server...
February 2, 2009 at 9:59 am
did you check the various fn_split solutions posted at SSC ?
e.g.
February 2, 2009 at 9:56 am
Viewing 15 posts - 4,066 through 4,080 (of 7,502 total)