CptCrusty1 (10/18/2012)

---

UPDATE!!!

Ok... We interviewed 2 candidates that seemed to have plenty of exp. C1 had 17 years of verifiable exp, checked his references, etc. Candidate 2 had FIVE...

SQLRNNR (10/17/2012)

---

I had never considered scheduling a block of time for interruptions by coworkers. Interesting concept. I'm not sure I could do that. But I agree that...

Sqlsavy (10/15/2012)

---

Hi all,

We've a small database (1 GB) and SQL 2005 server is clustered one. Now Business is forecasting that database will be accessed by million users by early...

Accidental DBA: an application or user account that's been granted...

ChrisM@home (10/17/2012)

---

Eric M Russell (10/15/2012)

---

You can simulate the functional equivalent in SQL Server 2000 less gracefully like so:

select C_RECID, H_RECID from

(

select C.RECID C_RECID, H.RECID H_RECID,

(select count(*)...

Don. (10/13/2012)

---

Hi Guys,

Unfortunately neither of those scripts worked as there are multiple identical accountno and lastdate fields. Ideally Id need to filter on the History tables Recid field.

...

...

In my example...

TravisDBA (10/12/2012)

---

Miles Neale (10/12/2012)

---

Meetings can be good. However, they need to be short, to the point, make decisions, and not be rambling sessions where everyone gets their say three...

Fortunately where I work we have few corporate or department wide meetings where attendance is required, maybe we'll get that once a month or every three months. There is a...

Steve Jones - SSC Editor (10/11/2012)

---

kevin.stevens (10/11/2012)

---

Personally I find it much more productive to telecommute than to work from an office. The only downside is that you get busy...

I guess this infographic (sales pitch actually) makes a few points, but I doubt most of the actual numbers cited.

- The average employee checks their email 36 in an...

Speaking different SQL dialects is no problem for me, I routinely work with about four of them. But beware that Oracle thinks '' is NULL. It may seem like a...

From SQL Server you can query what accounts and groups are members of roles (particilarly SYSADMIN), but it won't tell you what domain accounts are members of a domain group...

SELECT INTO #TEMPTABLE will perform less transaction logging than INSERT INTO #TEMPTABLE, which should be considered when loading 100,000s or millions of rows, but with only 4,000 rows, that aspect...

Posers who have recently taken a crash course on SQL Server or memorized answers to questions have trouble putting what little they do know in context. On those occasions where...

CptCrusty1 (10/1/2012)

---

OK... so here's a question for you serious DBA's.

My DBA Vendor indicated that they had to delete indexes before creating primary key's on a table. They created the...