michael.french 172 (12/12/2011)

---

An exponential advance in technology is an understatement. Think of how far we come in just the last 50 years or even five years. Think about how young...

If you have a Numbers table, you can do something like this:

SELECT DATEADD(DAY, Number, DATEADD(week, -5, CAST(GETDATE() AS DATE))),

DATEADD(MINUTE, (12 *...

I'm not clear on what you need. Are you just looking for a way to determine 30 minutes before and after the current time?

Couple of options. You could use the T-SQL Pivot operator, as per http://msdn.microsoft.com/en-us/library/ms177410.aspx, or you could build a query for each count and use Union All to connect them...

Since SQL Express doesn't have the SQL Agent service for scheduling jobs, you'll either need to build something that can use the Windows task scheduler (perhaps through the command line,...

Change "COUNT" to "SUM" and you should get what you need.

bradmcgehee@hotmail.com (12/12/2011)

---

My editorial got edited after I wrote it, and one important part of the message I was trying to get across apparently got deleted. In the original draft of...

Of all the forum threads available, the one resurrected a year later is one about resume fonts .... interesting.

I agree with the split. DBA = admins the database, Management = analyzes data and makes+implements decisions based on it, Analyst = support for management when specialized knowledge/skills are...

From today's ToDo: Catch up on missed week in The Thread done

Had a good week. Looks like I didn't miss too much here. Brandi and Gail...

Just got back from being off for a week. Didn't need to bother with work e-mail at all. Definitely a good break.

Evil Kraig F (12/2/2011)

---

Barkingdog (12/2/2011)

---

We have a third part app that needs to store a PDF file in a sql 2008 database. I recommended using varbinary(MAX) but the app doesn't...

Use the month and year to get the first day of that month. Then use DateAdd to add a month to, then DateAdd again to subtract one day, and...

But I was just quoting Blazing Saddles because of the...

Dev (12/2/2011)

---

cfradenburg (12/2/2011)

---

There are some very good reasons...