Nice straightforward question.

For something over 6 years transactional replication (on sql 2000) was a critical component of disaster recovery for systems scattered around the world that I was responsible...

I'm aiming to get there for...

Brandie Tarvin (7/24/2015)

---

So everyone at work is thrilled with me right now for solving a slow-running report issue when I discovered 4 table scans (of the same table) in a...

Alvin Ramard (7/22/2015)

---

Brandie Tarvin (7/22/2015)

---

Gotta love it when someone schedules a software change/update at month end. Because "there's no impact to the business" and all that.

<headdesk>

This too I will survive.

I...

Squander

Yes, it's very easy to translate that to ordinary English 🙂 : In this phrase "Mickey" means "piss" (and the...

GoofyGuy (7/20/2015)

---

The problem with BI is that "Business Intelligence" is frequently an oxymoron. No matter what the data is or how it is presented, the people that it's all provided/presented...

Evil Kraig F (6/8/2011)

---

Revenant (6/8/2011)

---

Craig Farrell (6/8/2011)

---

The only thing a previous employer must disclose is your existance at having worked at a firm and your hiring/leaving dates. That's...

Revenant (6/8/2011)

---

Michael Valentine Jones (6/8/2011)

---

. . . My experience is that people that are good programmers in one langage are good programmers in other languages. . . ....

Jeff Moden (7/18/2015)

---

This is the most important...

One of the best things you can do as a developer or DBA is ensure you can write efficient queries that assemble data from...

I don't really understand the point of this shiny new tool.

More than a decade ago there were perfectly adequate methods of shipping small-scale databases around. One method...

Nice question, but much too soon after the one without SMB storage which made this one very easy for anyone who had seen the previous one and looked at the...

I am rather surprised that so many DBAs, DBDevelopers, and others here are apparently willing to put up with overprscriptive dress codes and even to pay to be allowed...

Koen Verbeeck (7/17/2015)

---

TomThomson (7/17/2015)

---

Even DuckduckGo includes pages with "temporary table" in the results, but it does at least return several pages on temporal tables at the top of its list...

Heals (7/17/2015)

---

Koen Verbeeck (7/17/2015)

---

TomThomson (7/16/2015)

---

edit: I don't mean I read up dropping it; I read up all I could find in the MSDN library on Temporal Tables (and absolutely...