Hi,

Thanks for you help.

I've been playing with this, and you're right it does work but doesn't give me the solution to the problem i have. I've given @table as an...

I was going to suggest the NOEXPAND hint! I couldn't see anywhere in the thread to see what edition of SQL Server the OP is using. Unless it's enterprise edition...

Worked an absolute treat! Thanks very much!!

Hi,

OK, so couldn't you just add the table you want to replicate and then use a row and column filter? I'm not sure how you'd do that in script but...

Hi,

Depending on where you are in the world you may or may not find this site interesting/useful.

http://www.metoffice.gov.uk/datapoint

I've never done anything with it myself but it looks like you can get...

Hi,

I'm not sure whether that would work or not. If you've got a smaller database to test it on then go for it, you've got nothing to lose if it's...

Hi,

I'd use rownumber() to do that. Given what you've described then this should do the trick:

SELECT

x.TargetID, x.TargetName, x.Interaction, x.Created

FROM

(

SELECT

*, ROW_NUMBER() OVER (PARTITION BY TargetName, [Interaction] ORDER BY...

Hi,

I'd say getting the answer out of the plan cache was your best bet. There seems to be a good article on it here:

http://www.sqlskills.com/blogs/jonathan/post/tuning-e28098cost-threshold-for-parallelisme28099-from-the-plan-cache.aspx

Thanks,

Simon

Hi,

The best way in my opinion would be to use Regex and some CLR functions to replace the characters. Read this article:

http://www.simple-talk.com/sql/t-sql-programming/clr-assembly-regex-functions-for-sql-server-by-example/[/url]

Once you've got the functions installed then it's as...

Could that query form part of a stored procedure that has a RECOMPILE hint either for the whole proc, or just that statement itself?

Hi,

Yes i used to work with a credit card processing system that used to increment by 10 and started seeding at 10000. I don't know why that was chosen as...

Hi,

When you said you could do the differential bakcup following the full backup how were you running this? Through the GUI? If it was, it could be that your sql...

Hi,

You can do it with Powershell. I'm not saying this is the best way but i tested it here and it seemed to work for me.

# This is the source...

No worries, glad it worked.

Thanks,

Simon

Hi,

You can do it with a CASE statement. I've included an example below.

DECLARE @Cars TABLE

(

BodyStyle VARCHAR(50)

)

INSERT INTO @Cars

SELECT 'Sedan'

UNION ALL SELECT 'Sedan'

UNION ALL SELECT 'Sedan'

UNION ALL SELECT 'Sedan'

UNION ALL SELECT...