Grant Fritchey (5/9/2011)

---

It really depends on the size of the database and the rate of growth. I wouldn't get hung on specific numbers. If a database is growing very slowly,...

My take on this is to have enough space in the data file for at least 6 months growth, plus enough to rebuild the largest index in the database. ...

SQL Server 2005 RTM required SSIS to be installed to use the maintenance plan feature. As of service pack 1, that requirement was removed.

It sounds like you have not...

Tony,

Gail stated exactly what I would have stated - but better. 🙂

WebTechie38 (5/6/2011)

---

Sorry about that...I left out a step.

1) Does a differential backup

2) Sets the recovery model to simple

3) Checks integrity

4) Reindexes

5) Checks integrity again

6) Sets the recovery model to full

7)...

SELECT ...

FROM table1 t1

CROSS APPLY (SELECT max(timestamp) As t2MaxTimestamp FROM table2 t WHERE t.logid = t1.logid) t2

CROSS APPLY (SELECT max(timestamp) As t3MaxTimestamp FROM table3 t WHERE t.logid = t1.logid) t3

That is correct - let SSRS do the work for you. In most cases, it is just as efficient to allow SSRS to format that data - in fact,...

Looking at how you have this set up - what I see is this:

On failure, execute Notify Operator Task 1.

On success, execute Notify Operator Task 3.

So far, so good -...

Another option (requires Enterprise Edition) would be database mirroring. Once you have that set up, you would create a database snapshot of the mirrored database and run your reports...

bimplebean (5/4/2011)

---

Craig: Thanks for the input. I like the idea of replication, but I don't want to do it continuously during the day. The goal here is to offload as...

I have to agree with Craig here, well - sort of. SSIS is not going to be the right tool, but I also don't think replication is what you...

Are you doing a full refresh of every table - every time? Are there any additional transformations on the data being performed?

If this is a straight copy of the...

ByTheWestway (5/4/2011)

---

Although the year sort, month sort works in SSMS - when i pull through into SSRS it still doesn't sort in the correct way. My reporting period runs from...

Here are the 2 blogs where I first saw this as a possible issue:

http://blogs.msdn.com/b/mssqlisv/archive/2007/03/23/upgrading-to-sql-server-2005-and-default-schema-setting.aspx

http://www.sqlskills.com/BLOGS/BOBB/category/SQL-Server-Schemas.aspx

Maybe I am missing something here - but I don't think you need a 0 based tally table (perm) to make this work. If you change the following:

cteTally(N) AS...