You can look at queries in the cache to see if the database has been accessed recently: sys.dm_exec_query_stats. But that's only as good as the queries in cache. If the...

If you have a slow query that you've already identified as the point of pain, take a look at the execution plan for that query. That's going to tell you...

First, why insert twice? That's two times the labor and work for SQL Server.

Second, have you looked at the execution plans? That will tell you how things are behaving and...

You mean a user defined function in TSQL? That's just another way of writing a query (assuming we're not talking table valued user defined functions). There isn't, per se, a...

What are the statements after that in the transaction?

To my knowledge, this needs to be part of the backup command. I don't think there's a way to set a default value for all backups. I'm doing some checking...

That's a huge question and it begs clarification. At a very high level SQL Server architecture can refer to knowing the differences between the relational storage engine, reporting services, integration...

mtillman-921105 (8/29/2011)

---

GSquared (8/29/2011)

---

Marx/Engels called for the successful to be slaughtered by the unsuccessful in the establishment of "The Tyranny of the Proletariat" (Socialism) as a step on the way to...

But......

Data collection could affect performance. I've never seen it do that much to a system before though. Did you look at blocking processes or do you have a metrics of...

Since it's all on the same server you're sharing, by default, the same memory, CPU and tempdb. The one area of separation you can get is with disks. Not knowing...

WayneS (8/26/2011)

---

Grant Fritchey (8/26/2011)

---

Need the advice of the Thread.

Putting together an article on the most common backup errors (apart from not having one) and how to avoid them. I have...

GilaMonster (8/26/2011)

---

Grant Fritchey (8/26/2011)

---

Work is having me post at another forum, nameless, where I'm the lone voice suggesting that, oh, maybe setting all your databases to simple recovery is not...

I just want to say that I love it here.

Work is having me post at another forum, nameless, where I'm the lone voice suggesting that, oh, maybe setting all your...

SQLRNNR (8/26/2011)

---

Grant Fritchey (8/26/2011)

---

SQLRNNR (8/26/2011)

---

Grant Fritchey (8/26/2011)

---

Need the advice of the Thread.

Putting together an article on the most common backup errors (apart from not having one) and how to avoid...