Latch = is a type of lock you place in buffer cache

locks = are placed against resources.

Correct me if...

Andrew G (7/3/2013)

---

You don't need to fail-over at all, just break mirroring, then RESTORE WITH RECOVERY on the mirror to make it useable. Then recreate the mirror after the...

Joie Andrew (7/8/2013)

---

Copy-only full backups are the same concept as copy-only log backups. It does not write an archive bit so the log chain is not interrupted with the backup....

Thank you all for your feedbacks.

I checked with the user now and it seems it resolved itself. Maybe as you guys mentioned, it was due to some long running...

Sean Lange (6/24/2013)

---

SQLCrazyCertified (6/24/2013)

---

Sean Lange (6/24/2013)

---

SQLCrazyCertified (6/24/2013)

---

Hi,

When a user tries to edit a table, he is getting a timeout error.

Here is a brief details about the error.

"Executed SQL Stmnts:...

Sean Lange (6/24/2013)

---

SQLCrazyCertified (6/24/2013)

---

Hi,

When a user tries to edit a table, he is getting a timeout error.

Here is a brief details about the error.

"Executed SQL Stmnts: "the stmnts" from...

J Good (6/17/2013)

---

Times are in microseconds.

SELECT TOP (250) p.NAME AS [SP Name]

,qs.execution_count

,ISNULL(qs.execution_count / DATEDIFF(Second, qs.cached_time, GETDATE()), 0) AS [Calls/Second]

,qs.total_worker_time / qs.execution_count AS [AvgWorkerTime]

,qs.total_worker_time AS [TotalWorkerTime]

,qs.total_elapsed_time

,qs.total_elapsed_time / qs.execution_count AS [avg_elapsed_time]

,qs.cached_time

FROM sys.procedures...

bitbucket-25253 (6/15/2013)

---

we need filtered dump (only once) on the exception 12345 then we can enable trace flag 2551,8026 :

dbcc traceon (8026,2551,-1)

2551 –> To configure the filtered dump

8026 –>To clear...

Matthew Darwin (6/11/2013)

---

Is that the actual size of the data files or the log files?

I've seen interesting things with tempdb following runaway transactions whereby the log showed a negative available...

george sibbald (6/10/2013)

---

The SQLAgent files are the errorlogs for SQLAgent. Do not delete the .OUT file as that is the current one. there should be no more than 6 cycles...

Why don't you guys run dbcc inputbuffer (spid#)

It will show which tsql code is currently running.

SueTons.

Thanks Sean & Lowell. I'll test and see.

SueTons.

Sean Lange (4/26/2013)

---

SQLCrazyCertified (4/26/2013)

---

I need to grant a user to select & exec permissions to SP, inline, scalar & table-values functions....but I need this done in every databases. There...

I don't understand your question, you are missing your backup files? And you...

If these servers have mirroring in place, when the principal server shuts down, do I need to shutdown the mirror server(DR) as well? Or it's okay to leave mirror...