Will something like this get you started?

SELECT TN.MSDATE, CASE WHEN TN.MSDATE > T.StartDate AND TN.MSDATE < T.EndDate THEN DATEPART(yyyy, T.EndDate) END

FROM Tablename TN

INNER JOIN

(SELECT '06/30/' + CONVERT(varchar(4), DATEPART(yyyy,...

On each of our servers, we have created a 'DBAUtilities" database.

This contains everything for maintenance, monitoring, capturing metrics and so forth.

This is a far better place to...

Either that, or she's not admitting it!

We have also been fighting this issue.

We notice it more when clicking from one "folder" to another. Such as procs to tables, databases to management, server to another server.

Some...

RonKyle (4/20/2015)

---

This is a response I've seen from designers who don't think primary and foreign keys are important. And that's just the start. And...

RonKyle (4/20/2015)

---

No, it's not. The function of the database is to store information in a manner from which...

This does not work:

IF @dbname <> NULL

It needs to be

IF @dbname IS NOT NULL

IceDread (4/20/2015)

---

Jeff Moden (4/20/2015)

---

Yet Another DBA (4/20/2015)

---

Jeff Moden (4/18/2015)

---

I read Rob's article when it first came out. What a refreshing change it was from the dogma that I've been...

run_duration is not in milliseconds.

This value 20457 translates to 02:04:57.

The code below should get you started.

isnull(CASE len(run_duration)

...

I'm merely stating a fact that in small and medium size companies, people don't tend to use DBA's. They use dev that double as "accidental dba's". Now if you make...

Kyrilluk (4/10/2015)

---

From a Dev perspective, I think that the article is a bit backward.

First of all, why does it suggest that only dev should come up with data to...

I don't have time to re-write this, but...

1. The 6 selects to load the variables can be one select using case statements

SELECT

@modulo = COUNT(*) %...

What have you tried? Can you show us what you may have attempted?

That was a great show from...

sp_addserver @server = 'Servername', @local = 'local'.

This re-sets the value of @@SERVERNAME