If you have SQL 2012 or up:

REPLACENULL(address1,address2)

If not:

(ISNULL(address1)) ? address2 : address1

wolfkillj (1/18/2013)

---

Except when working with SSAS. Analysis Services doesn't know decimal, it only knows float and money. So if you need a...

Great question, thanks!

Eirikur Eiriksson (3/17/2015)

---

You will have to ask Koen, he supposedly took it to the shop for...

Hany Helmy (3/17/2015)

---

Stewart "Arturius" Campbell (3/16/2015)

---

Koen Verbeeck (3/16/2015)

---

Carlo Romagnano (3/16/2015)

---

I tried just a...

Easy one and a bit of a déjà vu as well.

Thanks Steve for the question.

Jacob Wilkins (3/16/2015)

---

Koen Verbeeck (3/16/2015)

---

This makes it seem like you could only create nonclustered columnstore indexes in SQL 2012, but not...

Brandie Tarvin (3/16/2015)

---

So I'm reading my Database Weekly this morning and find a link to Brent Ozar's SQL Rally commentary[/url]. Funny, I thinks as I read. I didn't know DBAs...

Carlo Romagnano (3/16/2015)

---

I tried just a little. The answer is as usual "depends".

If...

This makes it seem like you could only create nonclustered columnstore indexes in SQL 2012, but not in 2014. At least...

In that case your options are more limited. You can use xp_cmdshell to call DTEXEC directly, or maybe call a...

DATEADD(YEAR,-2000,myDateColumn) ?

Nice question, thanks.

richard.vanveen (3/12/2015)

---

I also read that Sql Server Reporting Services aren't supported by SP2, as they were in SP1, and there's an add-in.

Does the reporting services add-in cost extra, or is...

You can use the sys.dm_db_partition_stats dmv to find the number of rows per partition for your table.