robert.sterbal 56890 (10/3/2016)

---

Its a balance of risks. Private VPNs were very expensive and I would bet more likely to fail than the public network.

Additionally the risks on a private network...

First I'd just like to mention that vertically partitioning across multiple tables, when there...

Also, put this all into the...

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...