SQLRNNR (7/21/2014)

---

Jeff Moden (7/21/2014)

---

Jack Corbett (7/21/2014)

---

SQLRNNR (7/21/2014)

---

I am a bit surprised this hasn't been asked yet and it seems REALLY important.

Why do you have 2000 log backups to...

Minnu (7/21/2014)

---

Actually Performance is not a major issue in my case, trying to implement the table management.

i want to store the older records away by creating partitions.

my overrall request is,...

"For every complex problem, there is an answer that is clear, simple--and wrong."

H.L. Mencken, "The Divine Afflatus"

Zahid Naseer (7/3/2014)

---

Isn't it as simple as below:

select

case when col1>= col2 and col1>=col3 and col1>=col4 then col1

when col2>= col1...

GilaMonster (7/3/2014)

---

Do note that using functions on the columns like that prevents any index seek for that predicate.

If that column is a date, then:

SELECT

dbclaimcnt, dbclaimentered

FROM

EPSClaimsUOA

WHERE

dbclaimentered >= '2014-01-01' and...

The most basic thing is to make sure you really understand the real-world entities that you are trying to model, and to make the tables as close as possible to...

If it turns out that the time is stored in milliseconds with a base of 1970-01-01 00:00:00.000, then this code will work.

-- Milliseconds since 1970-01-01 00:00:00.000

declare @TimeMS bigint = 1397750400000;

select

[Date/Time]...

Those features...

Maybe this was the missing Crystal Ball:

http://penn.museum/blog/wp-content/uploads/2011/03/Crystal-Sphere.jpg

Chinese Crystal Ball’s Mysterious Past:

http://www.penn.museum/blog/museum/chinese-crystal-balls-mysterious-past/

Jack Corbett (6/25/2014)

---

I'd rebuild the indexes before I did a shrink as you might shrink below what you need for the rebuild and then the rebuild will take...

Michael Valentine Jones (6/17/2014)

---

Lynn Pettis (6/16/2014)

---

Michael Valentine Jones (6/16/2014)

---

For about a week, the code tags feature has not been working for me in IE 10.0

It's fairly annoying to have to...

Beatrix Kiddo (6/17/2014)

---

My Senior DBA likes to be the only one that knows some stuff so (in my opinion) he actively excludes me from situations where I might be able...

Lynn Pettis (6/16/2014)

---

Michael Valentine Jones (6/16/2014)

---

For about a week, the code tags feature has not been working for me in IE 10.0

It's fairly annoying to have to put in a...

Koen Verbeeck (6/16/2014)

---

Michael Valentine Jones (6/16/2014)

---

Koen Verbeeck (6/14/2014)

---

Michael Valentine Jones (6/13/2014)

---

Something no one has mentioned is DATETIME in the fact table for situations where it may be important. I...

Koen Verbeeck (6/14/2014)

---

Michael Valentine Jones (6/13/2014)

---

Something no one has mentioned is DATETIME in the fact table for situations where it may be important. I have seen people break date...