You can't take a backup for a single database object, at most you can take a filegroup backup, but I'm sure this is not what you're after.

You can make copies...

PARTITION BY is used in windowed aggregates, while GROUP BY is used in regular aggregates.

Look up OVER in BOL to find out more.

SQL Server doesn't need a front-end, it just needs a client connectivity library to be installed.

If you are using a front end, probably you have Access forms, so you might...

Yes, that's how it works.

SQL Server 2005 SSMS doesn't have a GUI switch to perform the copy only backup, but it's built into SQL 2008 SSMS.

I don't see how tempdb reads can grow its data file(s).

At least, I'm not aware of any way this could happen, but I could be flat wrong.

Can you please...

Grant Fritchey (5/3/2010)

---

Gianluca Sartori (5/3/2010)

---

I don't know if SQL 2008 R2 has changed something in connection limits for Express Edition.

The only thing I'm sure of is database size, that...

I don't know if SQL 2008 R2 has changed something in connection limits for Express Edition.

The only thing I'm sure of is database size, that changed from 4 to...

I see that this thread is still alive, so I'm throwing some more 0.02 € in.

Adam Machanic wrote a great monitoring procedure that could help you tracking down this issue....

Grant Fritchey (5/3/2010)

---

Gianluca Sartori (5/3/2010)

---

I think Paul wants to join the "world's worst procedure" competition... :-P.

I would have put some more BREAK / CONTINUE in it and maybe nested...

I would use SQL Server 2008 R2 Express Edition. It's free and should do whatever you need. SQL Server Express supports 1 physical processor, 1 GB memory, and 10 GB...

Reformatting a query with a CTE doesn't affect performance, it's up to the optimizer to choose the appropriate query plan and a simple CTE won't hurt.

I'm a bit concerned about...

Can't you apply the replace part later?

You could use a subquery or a CTE to do that.

I'm a bit confused...

Can you post table scripts, some sample data, expected output and what you have coded so far?

Please read the article linked in my signature, it will...

I think Paul wants to join the "world's worst procedure" competition... :-P.

I would have put some more BREAK / CONTINUE in it and maybe nested another cursor, but nice...

I'm sure you can't use Datediff to do that, if I understand what you're after.

Datediff returns the difference between two dates.

BOL says:

Returns the number of date and time boundaries...