accelerant

While a decent question about an analytic function in SQL Server, I am not enthused by the terminology used in reference to the table variable.

Table variables are not "memory tables."...

Ed Wagner (11/21/2014)

---

lshanahan (11/21/2014)

---

Recently been trying to wrap my brain around APPLY and it's sibling CROSS APPLY as I have some situations where they could prove useful.

I'm using 2005 at...

It's great that the window shades all had RBAR...

Stewart "Arturius" Campbell (11/21/2014)

---

Sean Lange (11/21/2014)

---

Great question but the explanation and the linked article were terribly disappointing. The article says to use the table designer for creating indexes after it...

Koen Verbeeck (11/21/2014)

---

Nice question, not so great explanation.

Still wonder why number 1 is not a clustered index scan.

Does SQL Server always prefer a covering nonclustered index over a clustered index?

(still...

DBA_AUS (11/20/2014)

---

on one of our server tempd db grows upto 150GB and beyond. so we moved it onto a seperate disk. i have seen it goes upto 150 + and...

DBA_AUS (11/20/2014)

---

thanks that make sense. I was under the impression that after t-log backup if space is not in use it should be released to OS.

if this is the case...

Another trick to move that is to partition the table with an unbounded function. Then you can rebuild the clustered index and merge the data into the new partition.

It...

death

You are welcome.

The issues I have seen boil down to the tools not launching after the 2014 tools were installed. This persisted until the removal of the 2014 tools.

I'm not really...

I have done it both ways. It works fine for the database engine. I have seen some issues come about with the install of SSMS and that was...

Miles Neale (11/20/2014)

---

A friend last year was asked why he worked seven days a week and for 10-12 hours a day. A couple of us told him he...

Years ago I worked at a place that did not value vacation of the employees. I found myself working every day of family vacations because everything was a fire....