Sean Lange (2/11/2015)

---

BWFC (2/11/2015)

---

It's funny. When it snows in my area (usually get 1 snow/ice storm per year, of no more than 4 to 6 inches), we get all...

Ed Wagner (2/10/2015)

---

Sean Lange (2/10/2015)

---

You...

You may want to take a look at the below. This is a "Gaps and Islands" problem. The below is designed around a numeric gap, but can be...

Andy DBA (2/6/2015)

---

Thanks Kevin and Sean for the informative links. After reading them I'm actually less concerned about using MERGE for copy forward operations.

I apologize for not posting sample...

The explanation is not correct. We do not want all rows except for Jones on 2008-04-01. We want all where cnt > 1. This will remove 1...

dwain.c (1/27/2015)

---

Brandie Tarvin (1/27/2015)

---

WayneS (1/27/2015)

---

Congrats...

BrainDonor (1/27/2015)

---

Sean Lange (1/23/2015)

---

Oh the cursors are unbelievably stuipd. They are used to count!!!

set @Counter = 1

while exists(select * from StupidlyLargeHeap (nolock) where someColume = @Counter) begin

...

As someone with quite a bit of experience (8.5 years) in the Healthcare Industry in software development and databases, I can tell you that both Luis and Lynn are 100%...

EF/LINQ/Hibernate all have their place. The primary place* for them is to SELECT from a VIEW with limited columns (and no VARCHAR in the WHERE clause!). Anything more...

Sean Lange (12/1/2014)

---

Matt Miller (#4) (12/1/2014)

---

Ed Wagner (11/25/2014)

---

Eirikur Eiriksson (11/25/2014)

---

Ed Wagner (11/25/2014)

---

Eirikur Eiriksson (11/24/2014)

---

Jeff Moden (11/24/2014)

---

Evil Kraig F (11/24/2014)

---

Jeff Moden (11/24/2014)

---

Eirikur Eiriksson (11/24/2014)

---

Just a quick question to "the thread", am...

Either they fixed it or something because now options 1 and 4 are different.

Option #1: FROM,ON,JOIN,WHERE,GROUP BY,HAVING,CUBE | ROLLUP,SELECT,DISTINCT,ORDER BY,TOP

Option #4: FROM,ON,JOIN,WHERE,GROUP BY,CUBE | ROLLUP,HAVING,SELECT,DISTINCT,ORDER BY,TOP

Eric M Russell (9/30/2014)

---

GilaMonster (9/30/2014)

---

Eric M Russell (9/30/2014)

---

So, if a DBA removes an end user from the DBO role in the process of performing a migration to the next release...

Shall I make the obvious comment? "Safari can't crash, Apple engineers it to be bullet-proof" (yes, I've actually heard a fanboi say that).

Can you access the DB? If the Log is unavailable the DB may also be.

I'm sure someone with more experience can chime in... but it sounds like a bigger...

the 2 biggest sellers at the local hardware stores/walmarts are Grillmaster and Weber.