1. Database corruption is almost always caused by storage hardware issues. You should be talking with your storage admins in addition to your VM admin to find out...

Anton Bardin (11/8/2015)

---

Hi everyone,

I am trying to import attendance data from MS Access DB to MS SQL 2012 with SSIS. Access staff table has text field with IDs matching MS...

1. Execute SQL Task that truncates Server2.Staging1

2. Dataflow task that reads all the data from Server1.Source1 and loads into Server2.Staging1

3. Execute SQL task that loads Server2.Destination1 using a query...

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