WayneS (12/20/2013)

---

I'm curious as to the different ways that you fine folks have seen / dealt with being on-call, and what you perceive the pros/cons of these are?

For instance:

on-call...

Then I'm not sure. You may need to contact Microsoft.

Rebuilding indexes is a costly operation. But, if it's not interfering with any of your code, running it once a day is not exactly a big deal. I've had systems...

Sean Lange (12/20/2013)

---

Well strange was not a good choice of words. Some are quite difficult to answer because there is no single choice that would work. On questions like who...

Wow, not sure why that's not working. It's Microsoft's link, so I can't fix it. I think this is the same one.

Yeah, networking is pretty near the bottom of my list for performance issues too. In addition to the network IO waits you can also look to bytes total/sec and %...

For just getting started, these are the things[/url] that I immediately look at for a plan. Yeah, there are tons more details, but this is the starting point. I did...

Good luck!

rajemessage 14195 (12/20/2013)

---

Thank u sirs ,

I will read those topics again from the books.

but if possible please write a word for use of (tsql vs trace) in Database Engine Tuning...

What about having a script that recreates the view when it creates the snapshot? That would ensure that the snapshot is in place and you'd always have the right view....

Seems OK to me. I'm not crazy about the pattern where you name each PK with the same name and then you have to figure out where it's used elsewhere....

Grab a copy of my book down in my signature. It tells you all about tuning your queries.

This really sounds like a job interview. If so, you ought to be able to 1) Answer these questions for yourself 2) Look them up through Google or Bing or...

Sean Lange (12/19/2013)

---

Koen Verbeeck (12/19/2013)

---

GilaMonster (12/19/2013)

---

Not that I would stoop so low as to beg for votes, but I do need a new costume (Star trek if anyone cares)

https://www.surveymonkey.com/s/TribalAwardsVoting

😀 :hehe:...

That is odd. Any chance those databases are set to auto_close? If so, they won't have performance counter metrics.