Also, so it's more readable, you can convert miliseconds to hh:mmss format using something like the following.

...

,convert(varchar,dateadd(ms,last_elapsed_time,getdate())-getdate(),108)last_elapsed_time

...

First, attempt to rename the .mdb file. If you get access error, then another process has it open.

Also, one of the sysinternals tools can tell you who has the file...

The following "first responder" query will provide us with some execution statistics like execution time, blocked vs working time, page read count, write count, etc. for each statement contained in...

Because you're new to this, I'd like to add one final note about filtering on dates. If OrderDate column is a datatype that contains both date + time (ie: DateTime...

buddy__a (4/28/2015)

---

Yes, I'm running Profiler from my desktop but it works fine against servers, i.e. my local installation, to which I have full access. It's only those servers that...

Jeff Moden (4/28/2015)

---

I wouldn't be. I'm glad that...

Steve Jones - SSC Editor (4/28/2015)

---

Ralph Hightower (4/28/2015)

---

In the "Understand the True Source of Problems" article:

2 – NOLOCK is required on every query. It makes things run faster.

Instead READ_UNCOMMITTED is...

One problem you will encounter when digging into root causes is that your search will often need to cross departmental or even oganizational boundaries, especially in the realm of data,...

PHYData DBA (4/27/2015)

---

Eric M Russell (4/27/2015)

---

PHYData DBA (4/27/2015)

---

We would be running anything...

PHYData DBA (4/27/2015)

---

We would be running anything after 2008R2 if any of...

I wish Microsoft would drop support for v2008R2 this year; I'd love to upgarde to v2014.

Gary Varga (4/27/2015)

---

...and then read your post and feel patronised??? That's not collaboration!!!

(I am assuming that...

Gary Varga (4/27/2015)

---

...and then read your post and feel patronised??? That's not collaboration!!!

(I am assuming that...

I've been told by exectutive management that we'll remain on 2008 R2 until Microsoft drops support... so...

I'll step up to the plate and work 50 hours a week, if there is a deadline approaching or when troubleshooting an issue in production. Also when learning a new...