Everything you need to know is here:

Deadlocking

https://technet.microsoft.com/en-us/library/ms177433(v=sql.105).aspx

Detecting and Ending Deadlocks

https://technet.microsoft.com/en-us/library/ms178104(v=sql.105).aspx

Handling Deadlocks

https://technet.microsoft.com/en-us/library/ms177453(v=sql.105).aspx

Minimizing Deadlocks

https://technet.microsoft.com/en-us/library/ms191242(v=sql.105).aspx

Lynn Pettis (9/28/2016)

---

Pingala (9/28/2016)

---

Thanks. We implemented the RETRY to avoid deadlock. However, I am surprised how a queued DELETE got a deadlock in the first place if SQL Server does...

Welsh Corgi (9/29/2016)

---

Eric M Russell (9/29/2016)

---

GilaMonster (9/29/2016)

---

And, after you're read that, tell me whether 'CREATE PROCEDURE', 'ALTER PROCEDURE', 'DROP TABLE', etc are valid permissions to be granted...

Grant Fritchey (9/26/2016)

---

Thanks everyone for the feedback. I was hoping someone would come in and argue in favor of hiding information since it sometimes seems to be considered a valid...

I assume the...

You don't always need to use C# scripting tasks, especially not for reporting tools. About the...

Aggregating object level...

Reading the following article, it sounds like in addition to granting user as owner of the schema, you must also grant them permission to perform specific operations like creating tables....

-- return the last update date for each database:

select db_name( database_id ) as database_name

, max(coalesce(last_user_update, last_system_update)) as last_updated

from sys.dm_db_index_usage_stats

group by database_id;

If the delta for number of bytes written has changed, then you can assume that logs need to be shipped.

Also, the 2nd query will look at last update date...

Why are you wanting start a new development project using Clinton era technology like classic ASP ?

robert.sterbal 56890 (9/28/2016)

---

I wonder if PASS would consider using the service:

MP3 To Text Transcription

http://www.transcriptionstar.com/mp3-transcription/mp3-to-text.html

for the 24 hours of PASS recordings.

Do you have any actual experience with the service?

My real...

A backup is a page level copy of the original, so there is no need to perform another re-index or re-stat after restoring.

Also, if your reporting database is static after...

For about the 3rd time in the past week... sp_MsForEachTable to the rescue.

exec sp_MsForEachTable

'

if ''?'' like ''ntEventLog%''

begin;

print ''truncating.. ?'';

truncate table ?;

end;

';

robert.sterbal 56890 (9/28/2016)

---

My two practical test are podcast transcription and photo identification.

When this gets done affordably, we will have reached a new level of technology.

I'm more than happy to follow...