Combining views, nesting views, and taking large, large data sets without filtering through views, are very common code smells that inevitably lead to trouble. Because views act like tables within...

Hard to explain exactly what happened, but it's likely to be the network. It's good to measure some queries from the client to understand how your network behaves, but the...

I'm with Steve, Amazon or Azure blob storage. I lean pretty heavily towards Azure, but I nailed my flag to that mast a long time ago. Also, Steve has already...

PDW is parallel data warehouse. It's a huge appliance that your company paid a ton of money for. Read about it here. Polybase is a way to query other...

Well, for the one day loss, you can, if you want, leave the current backups in place.

As to the rest... woof! Huge task. I'll give you some things to do,...

The single biggest issue you're going to hit on the database side of things is the new cardinality estimation engine that was introduced with SQL Server 2014. The new CE...

Impossible to even guess at this without seeing the full sets of code and the execution plans. Also, when measuring the speed, also measure the resource use, CPU and the...

It looks like you could use some more study & knowledge in this area. Let me make a few suggestions.

Hi Thom, These are the answers i know (if i...

• This reply was modified 7 years, 2 months ago by Grant Fritchey. Reason: type

Not enough info to go on. Read the logs to determine what happened (or didn't) and why.

Are these interview questions?

Oh bugger....

Absolutely tell your manager, boss, team lead whatever. You don't need to tell the whole company. However, you don't want to look like you're attempting to hide it. Honesty and...

There was a time when my primary concern on something like this would be simple worries about whether or not the junior (or senior, or mid-range) developer should be on...

Same answer as on your other question. Parameterize the queries. Don't execute strings.

Switch all your dynamic T-SQL to use sp_executesql. As you can see in the documentation, you can write that such that it uses parameter values, not just constructed strings....

Sounds like you're progressing well. I can't see the execution plan to make any suggestions. Also, an execution plan isn't a picture. It's all the data in the properties behind...