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...

Use parenthesis around the two LIKE conditions:

select *

from resource

where [date] > '02/02/2010'

and ( [Alan] like 'In%' or [Alan] like 'R%' )