Ed Wagner (3/17/2016)

---

Gary Varga (3/17/2016)

---

Steve Jones - SSC Editor (3/17/2016)

---

Gary Varga (3/17/2016)

---

Jeff Moden (3/16/2016)

---

The drawing in the article is what I've seen a whole lot of automated testing do. ...

It's worth noting that just knowing how to do something in theory doesn't mean you can do it in practice, as per the kung fu example from the matrix Neo...

Is there a reason you can't do it in SQL using the method I posted?

Have you tried updating the statistics on that table?

Well what format are you writing the data out from the program your using? If it's a csv then yes excel will treat those as text and not sum...

g.powers (3/16/2016)

---

I was rather impressed with this automation (assuming it's true).

A programmer wrote scripts to secretly automate a lot of his job — and email his wife and make a...

Junk

If you're running the rebuild index task built into SQL server it will run slower and slower and use more and more log space as the DB grows as it...

Gary Varga (3/15/2016)

---

Ed Wagner (3/15/2016)

---

Wayne West (3/15/2016)

---

I hope the SQL Agent job scheduler remains familiar, I'd hate the thought of doing those things through cron jobs, though that might be...

Ed Wagner (3/15/2016)

---

Wayne West (3/15/2016)

---

I hope the SQL Agent job scheduler remains familiar, I'd hate the thought of doing those things through cron jobs, though that might be a lack...

Are you sure that it's actually SQL injection and not just an issue with whatever application is writing to those tables? Putting HTML code in a varchar field isn't...

Interesting, so is this a move to try to take market share from MySQL? MS is already beating Oracle in the licensing department so it doesn't seem like this...

jimtimber (3/14/2016)

---

I'm not sure what to do with the DECLARE part of it. I have added the:

DECLARE @StartTime DATETIME2, @EndTime DATETIME2

at the beginning of my statement and then added to...

The method Luis posted should work if you'll never have differences more than 24 hours.

This should work to get the format you want.

SELECT RIGHT(CONVERT(varchar(30), DATEADD(second, DATEDIFF(second, CASE WHEN QueueDate IS...

Ah.. yeah true, didn't see that the dates would always be the same day.