Couple questions about this:

1. Can you execute any other CMDEXEC steps? Ignore what you're trying to do, try something simple first, like "DIR > c:\temp\dirlist.txt" and see if...

GilaMonster (3/10/2014)

---

Jack Corbett (3/10/2014)

---

My job title is Data Software Development Leader. I'll be doing a lot of design and architecture work. I'm going to kind...

SQLDCH (2/28/2014)

---

I'd love to see a reboot of the Barsoom (John Carter) series by Edgar Rice Burroughs. Disney already made an attempt, but it was pretty bad, leaving out...

Didn't think about comic adaptations, although being a Marvel fan for a long time, I'm quite happy right now...

Now, for an interesting idea for a comic movie...

Batman vs Aliens

Batman vs...

:w00t::cool:

Another book I wouldn't mind seeing made into a movie would be Fallen Angels by Niven / Pournelle / Barnes (I think...

Jim P. (2/28/2014)

---

jasona.work (2/28/2014)

---

I'd love to see a couple (OK, a lot) of books made into movies (heck some might be better as a mini-series on TV)

The Posleen War series...

I'd love to see a couple (OK, a lot) of books made into movies (heck some might be better as a mini-series on TV)

Ringworld - Larry Niven

Last Centurion - John...

Markus (2/20/2014)

---

I RDP into them quite often. Especially if it is late at night and we have an outage window to do major things like Service Packs or a...

Man, it got quiet in here...

Is the watercooler empty or something?

Gazareth has it right. The space available does NOT include the LDF / Log file space. If you add up the space available + space used results for...

Brandie,

I've always divided by 1024 when going from KB to MB.

I just tried your query against one of my DBs, replacing:

(FILEPROPERTY(a.name,'SpaceUsed') * 8) / 128.0000 AS MBSpaceUsed,

with

(FILEPROPERTY(a.name,'SpaceUsed') * 8) /...

7474 pages currently, according to sys.dm_db_index_physical_stats. The...

GilaMonster (2/10/2014)

---

How big is the table?

If I select the PK column only, then select again with an order by the PK column, both selects will return the same values in...

WELCOME BACK!

:w00t:

Luis Cazares (2/7/2014)

---

jasona.work (2/7/2014)

---

Knut Boehnert (2/7/2014)

---

"How would you fill a coffee cup in T-SQL?" There is no straight right answer, more of a way of showing how the interviewee thinks...