Sean Lange (8/26/2015)

---

Great question.

I have always laughed when I saw this because it is all caps it is not exactly clear when reading where the word breaks are. I have...

ygozudeli (8/25/2015)

---

I guess the question has a little mistake in the correct answer options.

When we use EXECUTE function, we have "Command(s) executed successfully" in stead of the default DBCC...

That changed fairly quickly.

TomThomson (8/25/2015)

---

Sean Lange (8/25/2015)

---

Ed Wagner (8/25/2015)

---

Alvin Ramard (8/25/2015)

---

Ed Wagner (8/25/2015)

---

I don't know if it's just me, but SSC has been having some blocks of time where it's very slow recently....

While that works to clear the plan cache, it does nothing for the sys.dm_os_latch_stats DMV. Additionally, it's not really recommended to do on a production server, especially since...

Alvin Ramard (8/25/2015)

---

SQLRNNR (8/25/2015)

---

Sean Lange (8/25/2015)

---

Alvin Ramard (8/25/2015)

---

OP is looking for: "... I just looking for good understandable explanation by pptx slides for (Index internals & Isolation levels as well)...

Sean Lange (8/25/2015)

---

Alvin Ramard (8/25/2015)

---

OP is looking for: "... I just looking for good understandable explanation by pptx slides for (Index internals & Isolation levels as well) and some demo...

Recline

oeuf

Sean Lange (8/19/2015)

---

I am working on putting together my first SSIS package. I haven't done this type of thing since it was still DTS packages. This stuff is a LOT...

Hugo Kornelis (8/19/2015)

---

I am happy to see questions about columnstore indexes, because I really love this feature. (I love everything that makes SQL Server go faster, actually).

But I am not...

Backup software? That has to be at least as current as many of the apps out there today. 😀

You run that risk as it is.

It works about the same either way with about the same amount of risk of another connection stealing the connection.

dan-572483 (8/18/2015)

---

We have a weekly job that restores a database from a copy downloaded from a vendor. It occasionally fails with the error:

Msg 3101, Level 16, State 1, Line...

GilaMonster (8/18/2015)

---

I'm not looking forward to September. One flight to Cape Town for SQLSaturday Cape Town, one flight to Durban for SQLSaturday Durban (first event in that city), one flight...