Lynn Pettis (8/13/2015)

---

Okay, the PASS Conference is October 27th through October 30th (not currently registered for any pre-cons). I'm thinking I should fly in on the 26th and leave...

I would do a separate database because:

1. Separation of processes

2. Faster recovery time of the Data Warehouse because the stage data is not in the Data Warehouse.

3. You typically will...

Good advice thus far. I didn't take the time to completely analyze your code, but one thing that I have seen help with looping inserts is to use explicit...

When I'm involved in interviews I ask if they know about the tally/number table. I'm always surprised how many people have never heard about it. If they have...

I'm going to do something I typically don't do and disagree with Grant and Erikur. Unless the vendor has specific policy that states that there are specific schemas or...

Unfortunately not a simple thing to do and any way to do it has performance implications. You can't use Fast Load because that uses bulk insert and not a...

Because consonants are free and vowels cost $250. 😛

That's why they are all 6...

Nice solution Drew.

I agree with Grant. Both of those tools are good and I've used both at some level. You can also sort of use both tools together as each...

I agree with Grant. Neither option is the best option. A separate Marks/grades table that stores each grade as a new record with proper data typing.

This would be the package protection level which will encrypt sensitive data.

There a couple of things that pop into my head:

1. Modify the triggers to insert into a table when they fire. Obviously adds overhead to each trigger firing.

2. Server...

A different person to each what?

Something like this will create a random order:

SELECT * FROM #temp AS T ORDER BY NEWID();

Yuck....