Just adding a vote for Lowell's solution. Extended Events are absolutely the right way to take care of deadlocks and deadlock monitoring. If you do the research, you're going to...

I don't have a web site I recommend for data modeling. I do have a book I recommend though: https://www.amazon.com/Server-Relational-Database-Implementation-Experts/dp/1430236957/ref=sr_1_1?ie=UTF8&qid=1464101129&sr=8-1&keywords=louis+davidson+database+design

It sounds like you have two problems, data modeling and data...

Thrilling stuff Steve. Congrats!

My two are graduating high school tomorrow (and turning 18 on the same day, **** I'm old).

If you have the business requirements for the data, by and large you should be able to design the tables without reference to a GUI that's going to query them....

There's not a way to specifically trace only actions against a given table. Instead, you can set up a trace that captures all T-SQL code (SQL Batch Complete is the...

There are four different buttons for downloading on that site. It's unclear which one is for actually downloading and which one(s) are going to launch some sort of virus. So...

A big part of this will be down to the structure of your table and the indexes in place. A delete based on thirty separate columns is going to be...

Does more than one account in your system have restricted user access? That would likely be what's occurring. Something else is there, preventing you from changing the database setting.

My immediate thought is to look to the cloud. Instead of writing to tape and physically transporting the tape, write to cloud storage (AWS or Amazon) and then download from...

Sean Lange (5/23/2016)

---

Jack Corbett (5/23/2016)

---

Sean Lange (5/20/2016)

---

GilaMonster (5/20/2016)

---

Ed Wagner (5/20/2016)

---

ON the SQL Saturday topic, the rumor is that a Detroit one will hopefully be scheduled for February 2017....

This:

ek.carriermemid <> ' '

In the WHERE clause is going to turn that LEFT JOIN into an INNER JOIN. Move it into the ON clause in order to retain...

Several things. First up, @Backupdrive2 is a parameter in the stored procedure, not a column. A parameter is a place holder that you use to pass in values to a...

It's at the domain level. To give permissions between domains, they have to talk to each other. I'm not a security expert so I don't have the precise walkthrough. That's...

You have to set up permissions between the domains. No other way to do it since the security is through your local domain. Another option would be to post the...

Smendle (5/12/2016)

---

TheSQLGuru (5/12/2016)

---

My...