It kind of depends on how much data we're talking about. If you're speaking of millions & millions of rows each month, you should look into setting up partitioning for...

You can't pass parameters to a view, so you'll have to answer Lynn's question in order to get any help. I don't understand what you're trying to achieve either.

Generally approaching something like this I would create three different processes. They won't "talk to each other" but the log backups on care that there has been a full backup...

TRACEY-320982 (4/24/2010)

---

We just installed our Sharepoint MOSS 2007 and the databases Content have already reached 25 GIG. It seems to me that the content data i.e pdf and word...

One thing you might want to look into, with 500 DTS packages, is a product called DTS Exchange[/url]. We've been using it and having very good luck with it.

You really need to identify what's causing the issue. One thing that does occur after an upgrade is that the statistics for every index are rebuilt as they are accessed....

Yep, I agree. Some time of network event, possibly a change in permissions? Hard to tell. Follow Lynn's advice.

From the sounds of it, the tables aren't terribly well normalized. This means you're going to be moving a lot more data around every time you want to do updates...

And if you really want someone to begin to evaluate the effects of your code choices on the structure, bare minimum, you need to include the actual execution plan, but...

SQL Server 2008 R2 is an incremental release, primarily focused on BI.

The next full version of SQL Server is due out in 2011, but I wouldn't count on it until,...

I'd start off with the Books Online. It covers a very large swath of this material right off the bat. After that, do a search on MSDN. Any time you're...

First, the advice to use ALTER INDEX is correct. But, just a point of clarification, DBCC DBREINDEX does support schema's. It just doesn't support the ability to run across databases....

Or it could simply be blatant misuse of temporary tables. You reall need to get a look directly at your code to try to identify the issues.

As a starting point,...

Can you get the information running this query?

SELECT CONVERT(sysname, SERVERPROPERTY('servername'));

If not, you may have an issue with the server, it's configuration, your connections... not sure.

It really depends on the error you're getting. I was able to compile the procedure on my machine, but since I don't have your structures, I'm getting an error because...