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...

norbert.manyi (10/3/2012)

---

All the developers are on both SQL and .Net, so we will not have those kind of problems.

Most of my concerns are regarding keeping everything in one place, and...

CptCrusty1 (8/24/2012)

---

Hi dudes and dudettes...

The boss and I are conviced that we need a dba since the 3rd party firm providing dba services isn't doing the best job. I...

I've always told my managers that building software is a trade off. We can do things cheaply, or we can do them quickly, but we can rarely do both. We...