Jeff Moden (4/9/2014)

---

Eric M Russell (4/9/2014)

---

In Washington D.C., lobbyists use money, sex, and three martini lunches to promote their cause and grease the skids. Can we do that with Microsoft?...

Look around on the website http://www.sqlskills.com/blogs/paul/ for articles by Paul...

defyant_2004 (4/9/2014)

---

I am trying both these queries out, thank you.

It appears I have to run the first query individually for each database, unlike the dbcc sqlperf ('logspace') which gives all...

defyant_2004 (4/9/2014)

---

Hello,

I use dbcc sqlperf ('logspace') to keep an eye on the logs for our databases. I like that it tells me how big the log file is and...

In Washington D.C., lobbyists use money, sex, and three martini lunches to promote their cause and grease the skids. Can we do that with Microsoft? 🙂

enriarg (4/8/2014)

---

I was let go of a company when I first started as a programmer because I fall a doze of in a meeting... truth to be told I have...

Yet Another DBA (4/9/2014)

---

Eric M Russell (4/8/2014)

---

I hate to say it, but the only way we're every going to see any industry wide application of standard data security policies is...

I don't think anyone here has provided an example of executing dynamic SQL. There are various approaches and pitfalls, so I'll provide a link the definitive tutotial...

jay-h (4/8/2014)

---

Eric M Russell (4/8/2014)

---

I hate to say it, but the only way we're every going to see any industry wide application of standard data security policies is through government...

Jim P. (4/8/2014)

---

Eric M Russell (4/8/2014)

---

I hate to say it, but the only way we're every going to see any industry wide application of standard data security policies is through...

I hate to say it, but the only way we're every going to see any industry wide application of standard data security policies is through government regulation and oversight. For...

muthyala_51 (4/2/2014)

---

george sibbald (4/2/2014)

---

I am sure you have already thought of it, but change the sa password or disable sa, turn off xp_cmdshell if you don't need it. By having...

First, don't reboot the server or restart the SQL Server service, because you can loose valuable audit information doing that.

You can query sys.objects and order by modify_date desc, create_date desc...

Eric M Russell (4/2/2014)

---

Given the requirements, I don't think there is anything functionally wrong with the table and trigger as is, except that the QuestionID needs to be indexed and...

Given the requirements, I don't think there is anything functionally wrong with the table and trigger as is, except that the QuestionID needs to be indexed and the primary key....