SET ROWCOUNT is supposed to be deprecated in the future. I'd try to work around it wherever you can

http://msdn.microsoft.com/en-us/library/ms188774.aspx

mikes 7125 (4/25/2011)

---

My cousin is now in the hospital, the outlook is not good. We grew up together and are more like brothers than cousins. Life is short. Make the...

Tom@Intel (4/25/2011)

---

Thanks for this message Steve - I am sorry for your loss.

I learned this same lesson last year when I lost my wife after a long battle...

Yes, check SQL Server Configuration Manager, click stop on the SQL Server database engine.

Do not change the max worker threads. That's an advanced setting, and only helps in very few and rare circumstances. The recommendation is to leave this at the default unless...

They will not be able to move the SQL files unless you shut down SQL Server. Those files are always open when the database is in use and SQL Server...

Strange. If you make the change in SSMS and then use the script button, can you run that script?

Are you use they are connecting with the same credentials?

There are plenty of posts like this out there. Please search. There are documents in Books Online that talk about the process.

It's as simple as running setup for SQL 2008,...

Does your stored procedure produce a file?

You could schedule a SQLCMD job that pipes output to a file, or a BCP job that pulls out data in a query.

The job...

Expanding volumes meaning adding new space or moving the volume to a large underlying disk structure?

If it's just expanding space, it shouldn't touch existing files and you ought to be...

Thanks, everyone for the kind words and thoughts.

there is a a white paper that talks about performance of Filestream v in database storage. Not completely applicable, but it basically says files < 256kb perform better from the...

Make sure you set max memory for all instances in there and leave 2GB for the OS. Watch the OS for paging too much (page file activity), as that can...

I tend to agree with Gail. The database is often a single point of failure, and the bottleneck, and contains all the data, which is often more important than any...

Optimize the database is so general. Looking at files and filegroups isn't the way to improve performance for most systems. Look at indexing and queries first. As Gail mentioned, without...