jasona.work (10/3/2016)

---

...

Which, really, comes around to "why in the H*LL does my refrigerator need to be on the internet in the first place?" So I can remotely check my...

One option is to use VPN/RDP to access your PC or server from where you can use SSMS or SQLCMD.

I'm only somewhat acquainted with Oracle, enough to form an opinion without forming an attachment. In my opinion, Oracle has a lot of "junk in it's trunk" dating back to...

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;