In some organizations, because of the way the pay grades and scales are structured, getting promoted to management is the only way for a senior level IT employee to get...

First, I'm assuming that these user login accounts are properly assigned as members of default [public] server role and NOT [sysadmin]. There is nothing you can do to hide things...

I also got my start back in late 80s and early 90s working with FoxPro and dBase on DOS, and later Clipper on OS/2. I thought I could build an...

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...