GilaMonster (7/14/2008)

---

Off hand, I don't know. I don't think it's 16 sec to compile. That's well over the maximum amount of time the optimiser would be allowed to work. Most...

GilaMonster (7/14/2008)

---

Hmmm....

Has the slow execution reoccured? Is it happening regularly?

As more general comments:

Why are you using dynamic SQL in one place? I can't see anything in there that would...

GilaMonster (7/14/2008)

---

That's a compile time of 16 sec! That's a little extreme.

Do you have contention for your procedure cache? (Are you seeing blocking with a [compile] description)

If you check perfmon,...

The image did not work. I think we should be able to upload small images directly into the post.

Dave Balsillie (11/23/2007)

---

There's actually a whole series of front end or tools. Third party tools (Like Cognos, Business Objects, etc.) are good as well, but be warned, each tool /...

Found a partial solution.  If you run this macro in a workbook:

Sub RefreshOnOpen()

For Each pc In ActiveWorkbook.PivotCaches

    pc.RefreshOnFileOpen = True

Next

End Sub

The workbook will try to refresh all external datasources.  The...

Just found it out: you have to manually backup and restore the database and the maintenance plan will pick it up.

Sorry, I probably did not put it clear.  I am not interested in the log backup files, but I am looking at the temp file which allows to keep databases in...

Sorry, did not quite understand...  Do you mean replacing this:

INSERT INTO OPENROWSET('Microsoft.Jet.OLEDB.4.0',

'Excel 5.0;Database=C:\Temp\NorthwindTest.xls;',

'SELECT EmployeeID,LastName,FirstName FROM [Sheet1$]')

SELECT EmployeeID,LastName,FirstName FROM Northwind.dbo.Employees

with this:

INSERT INTO OPENROWSET('Microsoft.Jet.OLEDB.4.0',

'Excel 5.0;Database=C:\Temp\NorthwindTest.xls;',

'SELECT EmployeeID,LastName,FirstName...

Just found this out.  The article had only some of the columns replicated, so the command obviously could not be executed on the publisher table.  As for the subscriber, the...

Just sent the code.

Thanks.

I already have some code which would filter out last week/day/hour from the log, but I would appreciate the code that works around the broken lines problem.

Thanks.

Is there a TSQL code that can do this?

Just found this out:

C:\diskpart

 

DISKPART> select disk 0

 

 

DISKPART> list part

 

I've got the table name, and this SP does not touch the table at all, that is why I thought I could be wraped around into a transaction which first queries...