chandan_jha18 (1/7/2014)

---

Grant Fritchey (1/7/2014)

---

chandan_jha18 (1/7/2014)

---

Thanks John and Gail. Now I understood it more clearly after relating to the practical lab results and theory. The clustered index column is present in...

Without resorting to a third party software, you can't. The only way to access a backup is to restore it.

So, you're not getting table scans, but the performance is still really bad? It may just be your process then.

Also, even though it's Express, you can use extended events or...

chandan_jha18 (1/7/2014)

---

Thanks John and Gail. Now I understood it more clearly after relating to the practical lab results and theory. The clustered index column is present in all non clustered...

Thinking about it some more, it's also possible you need space in tempdb.

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