SKYBVI (10/27/2010)

---

@ azad...

r u running ur log shipping 24 hours??

u can skip for 5-6 hours everyday and during that time you can run this reindexing job..

Mine works like this only...

Your friend solved the problem using a CTE, which is a feature not available in sql server 2000. The solution can be reworked to work in sql server 2000, but...

Ah, its refreshing to know that I'm not alone in my quest to quell the uprising of 1,000 page reports. "A data dump is different than a report. SSRS is...

This isnt really a direct answer to your question but more of a suggested workaround -

Typically when I've come across this issue, I'll move some of that work off...

We're gonna need more details from you to give you a satisfactory answer. Think we can get you to post some code/table definitions of the poorly performing proc?

A good way...

So, assuming I understand you correctly, #t1 is already populated and you just want to split the data into 2 different tables?

SELECT ID, pre

INTO #t2

FROM #t1

SELECT ID, post

INTO #t3

FROM...

Since a subscription is really just a sql server job, I'd just create a new job that executes a proc. the proc executes "SELECT job_id, [name] FROM msdb.dbo.sysjobs;" and store...

upstart (10/15/2010)

---

Something to keep in mind for those currently using 2008 or moving to it:

Using SET ROWCOUNT will not affect DELETE, INSERT, and UPDATE statements in SQL Server 2008. Avoid...

can you post a table definition with index defs on the konten table?

Looks like you are facing into a DELETE..CASCADE performance issue... this delete has to touch alot of objects...

The short answer is, there's really no way to tell for sure if query plans will change without testing.

If it were me, I'd probably collect a replayable trace from the...

Can you provide more details? Maybe post the actual painful query, show the query plan as a view, ordered one way, and as just a query?

SSAS and MDX doesnt solve...

When I've been tasked with doing similar kinds of deletes, I try to spread the pain out over time, and hence spread it out over transaction logs as well so...

Trina Blazek-394828 (10/14/2010)

---

I am trying to do something that seems very simple, but isn't working properly. A stored procedure is returning data to a matrix report where one of...

Warren Peace (10/14/2010)

---

So your saying that "If the second subreport is not embedded in a tablix" it shouldn't re-query SQL for the same recordset and the subreport will use the...

If the second subreport is not embedded in a tablix, but just in a rectangle on the report it will only be called once. If you have a dataset where...