I'd recommend expanding existing files or adding a file to the primary file group so that it has enough room to get the work done.

Not sure based on what you've posted, but it's possible that you're filling the log file (and the drive). Is your database in Full Recovery mode? If so, are you...

Yeah, pretty much SQL Agent. You can set up multi-server management with it too. I wrote an article on this topic a little while back that might be a little...

It kind of depends on how you define database dictionary, but check out Red Gate SQL Doc[/url].

Disclaimer: I work for Red Gate.

Since this is posted in the 2008 forum, you can use extended events to capture the query metrics at an extremely low cost to the server. That's what I would...

Have you looked at the execution plans for the queries? Is it taking advantage of indexes you have in place? If not, can you adjust the indexes, add new ones,...

Based on what you've said so far, I assume you've identified the queries that are running the longest and/or are most frequently called. Have you then looked at the execution...

I would change it immediately after installing SQL Server. The default value is just ridiculously low.

Good answer, but that's not even "from SSMS" That's Agent using PowerShell. There's no way I know of through SSMS directly. You'd have to do some command line magic of...

No, it's not a good idea to change it at the server level. Most of the time you get parallelism on queries that are not complex enough to justify it....

Oh, nice catch, I didn't see that.

Still look at the execution plan. It's a foundational start to everything you do when trying to tune performance problems on queries.

However, I'm still...

Ed Wagner (1/6/2014)

---

I think I'd have to vote for the 270-column table where the upload is not working properly. It made me...

All you did by detaching the database was flush queries out of the cache (and probably flushed data out of the cache too). That's not a solution. Instead, you need...

It could be process, your server set-up or your code. Most of the time, it's the code. I've got a book on SQL query tuning that walks you through gathering...

Ed Wagner (1/6/2014)

---

Well, we got hit pretty hard by the recent storm just north of Detroit. I've got over a foot in my driveway now and it was cleared...