One major role of an aggregate data reports writer (i.e. "Data Scientist") was Business Analyst. You can do all the tests you want, but when the actual users are...

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

L' Eomot Inversé (1/11/2013)

---

I haven't done any database design that really matters for a few years, but I would do something very different from your idea.

Lets start with...

Perhaps most importantly:

The first, easy part:

If we assume that somehow a server is rendered unstable, excessively slow, incorrect, invalid, unusable or inoperable, what's the plan... and do you ever test...

Michael Valentine Jones (1/9/2013)

---

As...

I'd have to say that we do see security patches for SQL Server these days, and they certainly require more work for me than service packs.

SP# > current...

While I haven't done any experiments, I would caution against the thought patterns of discrete possibilities (if enough RAM then only in RAM). For anyone investigating, I would suggest...

Add up the RAM each machine you want to virtualize should have (at peak times), then add some more for overhead and growth.

If you keep the data being...

Bhuvnesh (12/26/2012)

---

i am bit confused in following CPU keywords

1) dual-core

2) quad-core

3) n-core processor

4) sockets

5) "number of processors" means ? It's physcial or logical ?

And on what basis (from...

GSquared (12/20/2012)

---

I wouldn't bother using a RAM disk for tempdb.

Most of what accesses tempdb will already be perfectly happy to live in RAM till it runs out and has to...

When I have a choice where, based on my constraints, I could reasonably rebuild or reorg, I always rebuild. In general, I've operated with set maintenance windows, where I...

Ah.... yeaaahhhh... you see, we've changed to a new TPS report format, and that... that's the old format. Yeahhhh... we send a memo...

The Meyers-Briggs 16 "type" approach is mirrored by David Keirsey in his book "Please Understand Me II: Temperament, Character, Intelligence", which is an excellent guide and very reasonably priced (MSRP...

It sounds like you have to be very careful of how you rebuild those large tables - note that index rebuilds can take TempDB space in a range of 0%...

Perry, excellent point on TRUNCATEONLY only applying to data files (and all arguments about 'do not shrink' apply to data files just as well as to log files).

For anyone wondering,...