I don't have a problem with triggers when designed and coded properly. For something like logging a change history I think triggers are the best way to do it.

I'm...

If I have the time, I prefer to to do a full scan. Sampling a small percentage, unless you know your data has a standard distribution, is going to...

Have you tried Adam Machanic's sp_WhoIsActive? I know it does a great job of showing what a query is waiting on. I haven't experienced your exact situation, but...

Luis Cazares (11/9/2015)

---

Does anyone here knows the site howtosql.com? I was searching for an old thread on Google and found that "I'm an author" for them. It was actually linking...

I use IsActive. I usually put a default on my bit columns and I use 0 because I explicitly want the row to be set to active. It...

Lynn Pettis (10/20/2015)

---

Jack Corbett (10/20/2015)

---

Not to make those of you not able to attend the PASS Summit jealous, but I just went through and setup my schedule and...

Not to make those of you not able to attend the PASS Summit jealous, but I just went through and setup my schedule and there are multiple session in each...

Eric M Russell (10/16/2015)

---

As for the option of sticking around and "fixing" your current job, unless you're in a position of influence, I find that ideal outcome to be...

I just installed Win10 on my laptop last night. But only because my main hard drive failed and I had to buy a new one. The failed SSD...

WayneS (10/7/2015)

---

GilaMonster (10/6/2015)

---

#gloat Company's paying for the trip to the US. If I was speaking at Pass Summit, they'd be paying for hotel too. They paid for my trip to...

Thanks. I also tested the RowCount thing in SSIS 212 and see the same...

shahzadazizpk (10/5/2015)

---

Thank you for your reply!

I have tried the mentioned steps but stuck when i run the application, actually Row Count is not updating the value of the variable...

shahzadazizpk (10/4/2015)

---

I am new in SSIS, i would appreciate if anyone can provide me solution to my problem

My requirement as mentioned below...

1. Read records from a source table using SQL...

BrainDonor (10/5/2015)

---

At SQL Pass there's usually an SSC night. I'm certain I saw mention of it somewhere but can't find it again.

Could somebody tell me which night it is?...

Michael L John (10/2/2015)

---

SQLRNNR (10/1/2015)

---

Ed Wagner (10/1/2015)

---

I'm headed to SQL Saturday Pittsburgh this weekend. I'll be my first visit to this location, but I've heard good things about it.

If...