Cool thanks

Hi all for anyone who is interested I got the script created as follows:

--Code to pull out deltas between collected IO stats.

;WITH IOPS ([IO_STALL]

...

ah yes thanks, thats worked thank you.

Thanks - in the end I used the Generate scripts option of SQL

Yes thats right I was really just trying to understand the differences between the est. and actual number of rows, and the explanations you have given go some way to...

ChrisM@Work (4/9/2013)

---

An index on #d2 supporting this join ([#d2].MARIMSSALESID) = ([DynamicsV5Realtime].[dbo].[SALESTABLE].MARIMSSALESID) would reduce the exaggerated estimated row counts, but that's besides the point. This lot is unlikely to run well...

yes I am aware its a big of a nightmare this is what happens when BAs write code. I am currently tearing my hair out re-writing it.

After reading some articles on retention periods for example here:

http://www.mssqltips.com/sqlservertip/1823/troubleshooting-slow-sql-server-replication-issue-due-to-distributor-database-growth/

Even though my subscriptions are set to never expire I don't believe this is impacting on my MSRepl_commands table. I...

Hi there - I have attached it, I have already got rid of most of the RID lookups however it still takes 10mins to run I think mainly because of...

Yes you're right Lynn so I have posted it below, thanks - I have already stripped out the functions for temp tables. I would appreciate you taking a...

But it will be called once if your UDF returns a table and used in WHERE clause like that:

SELECT ...

FROM ...

WHERE Col IN (SELECT Item FROM dbo.YourSplitFunction(@InputParam))

Don't forget to...

Hi MyDoggie thanks for that some food for thought. To answer your question OPRID is nvarchar(10)

When you say how the rows are distributed what do you mean? I usually check in plans for estimated rows vs actual rows and if they are not close...

Yes there was nothing in sys.database_permissions for that role. I know it shouldn't make a difference but using SSMS 2012 to connect to a SQL 2008 instance with a...

Hi just to clarify in order to get this working I had to grant each object view definition explicitly. I noticed the DB was in SQL 2005 compatibility mode...