joins are often on columns defines as...

As Jeff said if you can upgrade this database first because investigating the performance problems will be so much easier. However that may take a while because you will need...

not in that direction no, you will not be able to do the initial full database restore as the version of SQL is lower.

thats me out then, xquery gives me a headache. 🙂

profiler as a server side trace is another option. I presume would be more intrusive than the trace flag though, but gives a graphical representation.

Grant, is system_health extended event available...

debanjan.ray (2/27/2014)

---

we dont want to run a trace from SQL Profiler since it will slow down the server. Is there any query or ETL, so that we can get those...

below86 (2/27/2014)

---

george sibbald (2/27/2014)

---

below86 (2/27/2014)

---

I have often said I avoid stored procedures for the most part. But this too has always seemed odd to me. You are essentially replacing...

you could run profiler as a server side trace

below86 (2/27/2014)

---

I have often said I avoid stored procedures for the most part. But this too has always seemed odd to me. You are essentially replacing the entire code...

this mode is more normally refered to as just 'single user' mode

Tom,

I only brought this option up as your post contained the phrase 'however created'. The thing is it is the DEFAULT behaviour of the GUI to inherit the model database...

that error will come with a value for 'state', what is that equal to, and what message does SSMS give you?

please post the exact error you get.

Igor Micev (2/23/2014)

---

george sibbald (2/23/2014)

---

TomThomson (2/21/2014)

---

The read_only property of the model database has no effect on newly created databases, however created. Whatever the model value is, the value for...

TomThomson (2/21/2014)

---

The read_only property of the model database has no effect on newly created databases, however created. Whatever the model value is, the value for database created by restore...