TheGreenShepherd (4/26/2013)

---

Don't mean to pile on here, but yeah. I fail to understand why someone would query this data in this fashion. Yeah, it improves performance for that query but...

ben.brugman (4/18/2013)

---

lptech (4/17/2013)

---

Yes, managers love their spreadsheets, and it is very annoying when there are five different versions of a given spreadsheet floating around, each with one or two different...

Yes, managers love their spreadsheets, and it is very annoying when there are five different versions of a given spreadsheet floating around, each with one or two different columns added...

In the last 1-2 years, I have given up on religious wars in technology (this should not be taken in any way to have anything to do with real religion)....

A lot of good points here. But there is always the option of running DBCC on a mirror or restored copy of the database. Now this is going to cost...

Storage replication (i.e. EMC SRDF) would be the easiest way of not worrying about 100 databases individually. Or you could write a custom log shipping routine that takes care of...

It's a good review for DBA's below the guru level, as we may get calls to debug code using some of the items mentioned. Or worse yet, requests from the...

Nadrek (1/18/2013)

---

That's a very disturbing question. I'd be torn between two responses:

I honor the contractual agreement with the social media sites I use not to divulge those credentials, just...

Steve, excellent point, to isolate 32 bit stragglers in their own VM's. For those who are content to be 'dumb and happy', and I got this term from a user...

There are always people who will be penny wise and pound foolish. Servers need to be replaced, so why not take advantage of more powerful hardware? Not everybody wants to...

I am dating myself with this one but.....

Back when i was a mainframe programmer trainee, I was browsing thru an old source library. There I found an IBM assembler payroll...

Wonder if said manager comes from another DBMS. I once had to prove all sorts of things in SQL Server were not the same as in Oracle.

From many rounds of patch management over the years, I would highly recommend the following:

1) Have a Computer Management Configuration Database (CMDB) in place, and make sure that the patch...

It pains me to say that in 10 years from now, there will be a whole lot more wrong answers. Many smart high school students would just whip out...

You could do it an extended stored procedure (xp).

http://msdn.microsoft.com/en-us/library/aa214418(v=sql.80).aspx