Try all three methods (CASE, ISNULL, and COALESCE) and see which is faster in your specific scenario. If you're encountering performance issues, then it's probably the sargability of the query...

He may also want to consider placing a unique key constraint on session + product + time or date with the ingore_dup_key option set to insure that redundant click events...

Jeff Moden (2/3/2015)

---

To cover some of what has been said, 35 inserts per second should be trivial for a well written audit system. It's usually the tables or a...

There seems to have been a spike in career oriented editorials and posts over the past year. I know it's been on my mind a lot lately too.

As for...

MMartin1 (2/3/2015)

---

Maybe I missed it somewhere but it seems as though you are reporting from the same system you insert into. You generally want to build a warehouse to store...

sys.sysprocesses is legacy, and there are a handful of DMVs that could do the same job better.

The following will simply return number of connections.

select * from sys.dm_os_performance_counters

where Counter_Name =...

Doctor Who 2 (1/31/2015)

---

I agree with you Steve, but sometimes I wonder. Where I worked we had 18 years worth of data which I've maintained and advocated for years, should...

David.Poole (1/31/2015)

---

I saw an amazing article on how Oracle would save hundreds of thousands of dollars per year because the tooling was so much better that it took Oracle DBAs...

sm_iransoftware (1/31/2015)

---

Hi Again

I want to do some thing on this database.

First Of All , I should start with a small database.

But current DB has many connection from site. And I...

RonKyle (1/29/2015)

---

I don't want to get in a back and forth about what a natural...

RonKyle (1/29/2015)

---

[Emphasis...

ScottPletcher (1/29/2015)

---

TomThomson (1/28/2015)

---

Eric M Russell (1/27/2015)

---

andrew gothard (1/27/2015)

---

Eric M Russell (1/21/2015)

---

ProductID, ProductId, and product_id are all respectable options, so long as it's done consistently.

However, I would take issue with...

Our ETL process ingests data from over a hundred external clients, and what is accepted as "normal" is a constant debate. There is a pre-production load step called AutoCertification that...

They're somehow assigning more weight to the negative rating then the all the others. There's perhaps some value here in doing so, since there might be a legitimate complaint, but...

Iwas Bornready (1/27/2015)

---

For me, over time, it has become increasingly more difficult to work full time and do any sort of serious studying. I don't have a solution. I just...