well, because your query is a catch-all-query, it's going to be a table scan, which will not be efficient at all; read a little bit more hear:

http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/

you could probably address...

Jeff I've only file copied system files a couple of times when building backup machines; i know that the new server has to be the exact same version, ie you...

they are both the same, the keyword NONCLUSTERED is optional and is the default value when you create a new index.

Google Translate (5/21/2013)

---

Well, after reading it all, try to follow the best techniques on data replication scheme from a DB2 database to another SQL Server 2012, then I will tell...

most likely permissions, as previously identified, but maybe i can help you find out the specifics.

if i right click on my temp folder, and go to the security tab, i...

dndaughtery (5/21/2013)

---

I have a datadriven subscription that uses a stored procedure.

The code is below:

declare @ReturnValue int

exec @ReturnValue = s003pSRC.sp_Par_Rate_Compare_Report_Subscription_Condition

select @ReturnValue ReturnValue

I have run the sp in ssms and...

YSL I think i'd tackle it by changing one of the tables into a simple GROUP BY, that returns the distinct count inside it;

something like this is syntactically correct, but...

at three pages and growing, sometimes it's hard to track down everything.

this article has the Tally Table Definition and lot of usage examples:

http://www.sqlservercentral.com/articles/Tally+Table/72993/

I saw your other post...

cool to have such big table, I'm actually a bit jealous, because it presents a lot more...

yeah i would have thought of statistics as the issue as well;

ok we know it takes 20% of the rows int he table , + 500 rows to trigger auto...

i think using EXISTS is a little better, and is what I would typically do:

--does ANY data match the criteria?

IF EXISTS (SELECT

...

also, something like this, with a simple subquery would work as well:

SELECT * FROM MyTable

WHERE clientName IN (SELECT MIN(clientName) FROM MyTable)

ORDER BY clientName ASC;

are you familiar with Parameters yet?

DECLARE @Client varchar(50)

SET @Client = 'A123';

--SELECT @Client = MIN(clientName) FROM MyTable;

With MyCTE (clientName,col2,col3,col4)

AS

(

SELECT 'A123','val1','val2','val3' UNION ALL

SELECT 'A123','val4','val5','val6' UNION ALL

SELECT 'B234','val7','val8','val9' UNION ALL

...

here's an example of EXECUTE AS with a super user:

now even as a super user, if you are trying to touch network shares or special folders , you might still...