jbrandenburg (11/16/2015)

---

We have 75 databases being backed up using simple recovery model on a nightly basis. We have no custom applications, but we have the following 3rd party apps...

The simple answer is that you do this in a reporting tool like Reporting Services instead of straight out of SQL. Certainly there are ways to do this directly...

call.copse (11/11/2015)

---

cphite (11/10/2015)

---

...

It was comprised of a join between two other views - their names don't matter - what matters is that each of those views was comprised of other...

I want...

When I first started my current job about 5 years ago, pretty close to the first week or so I was working I noticed the production SQL server being slowed...

jared.smith (9/30/2015)

---

I'm new to SSRS and am wandering how to do something that is pretty straight forward with other reporting tools I have used.

I have two parameters, employee_code and Business_Unit

I...

I would create a lookup table: lookup_Policies (Policy, SubPolicy)

The data in that table would be like:

Policy1, Policy_Name 11

Policy1, Policy_Name 12

Policy1, Policy_Name 13

Policy2, Policy_Name 21

Policy2, Policy_Name 22

...etc

Then I would do something...

...and he's never heard of hdd encryption?

so the thumb drive is...

Steve Jones - SSC Editor (6/23/2015)

---

This is exactly what DLM Dashboard was designed to do. Catch changes in schema. It works well for me in small projects here.

Disclosure: I work...

I've been running Red Gate's DLM Dashboard for a while now on one of my dev servers, and it does a good job of tracking any DLM changes. Right...

Will it work? Yep.

Will it eventually fail in a spectacular manner? Yep.

I tried this once just to see what would happen; on my play laptop, with...

Try opening the maintenance plan in BIDS and run it manually... disable the other steps if you prefer, but see if it'll perform the delete. If it can't,...

I had this problem a while back and it was aggravating the heck out of me... in the end, it turned out to be pretty simple and stupid: ...

SQL-DBA-01 (6/19/2015)

---

Hello Experts

I wrote a custom procedure to shrink the db log files alone. It works well always but yesterday in one of the server the job execution was failed.

Error...

Sean Lange (4/17/2015)

---

Please note that the query in the apply from cphites excellent solution is using TOP 1 but it also needs to have an order by so you know...