As Dave has said, a resolution has indeed been provided for this on the MSDN link in his post. The question\problem is one and the same.

Only problem for me here is that I meed to push out 3TB data that takes three days and I can't have that downtime unfortunatley. The snapshot takes about 8...

look forward to hearing back from you. I haven't been able to find a solution to this

Sorry bout the wrong section! I have found that some sections on the forums would be better as a generic section. I.e Replication and TSQL. Some sections have more visitors...

Jeff, thanks for this. it works great!

In the end I opted for used a CTE as follows

WITH results (FILEID,FILE_SIZE_MB,SPACE_USED_MB,FREE_SPACE_MB, [NAME], [FILENAME])

AS

(SELECT

a.FILEID,

[FILE_SIZE_MB] =

CONVERT(DECIMAL(12,2),ROUND(a.size/128.000,2)),

[SPACE_USED_MB] =

CONVERT(DECIMAL(12,2),ROUND(FILEPROPERTY(a.name,'SpaceUsed')/128.000,2)),

[FREE_SPACE_MB] =

CONVERT(DECIMAL(12,2),ROUND((a.size-FILEPROPERTY(a.name,'SpaceUsed'))/128.000,2)) ,

[NAME] = a.NAME,

[FILENAME] = a.FILENAME

FROM

dbo.sysfiles...

A good tech Document can be found here

http://download.microsoft.com/download/d/9/4/d948f981-926e-40fa-a026-5bfcf076d9b9/ReplicationAndDBM.docx

I have set up Mirroring with Transactional Replication. Its very good for what it does. I would recommend you set this up in...

Here is the script I modified slightly from the above post

Set-Location C:$scriptArray = Get-ChildItem \\filesharelocation

$runArray = @()

Set-Location SQLSERVER:\SQL\SERVERNAME1\DEFAULT\Databases

$dbArray = Get-ChildItem -name

foreach ($script in $scriptArray)

{

foreach ($db in $dbArray)

{

if ($db -match...

I fixed it by creating a covering index

CREATE NONCLUSTERED INDEX [IX_TestIndex]

ON [dbo].[PAIRHIST] ([date])

INCLUDE ([JOINTICKER],[PRICE_LAST],[PERIOD])

GO

That got rid of the Key lookup and the query now take 3 seconds!

Thanks for your comments...

we run update stats with fullscan on the whole database every night. You are right though that should help but I fear if will continue to be a reoccurring problem....

thank you very much! It gives me something to go on 🙂

I understand the programming logic but need a bit of a pointer in the right direction when its comes to creating the code. I will give it a go and...

That makes sense. Was hoping I could get some help with the syntax?powershell is totally new to me...

Thanx

Gamamat7, this took me some time to figure out as well. I had the same problem. The only way to figure out what *Edition* you are running is by looking...

thanks for the suggestion. i found out the problem was because of overlapping objects. When they overlap the renderer does not like this. I had to get around the issue...

works a treat 🙂

thanks for your help...