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

Absolutely Eddie's answer, or, use parameterized queries and then you simply pass the normal string, Women's, to the parameter with no additional work required.

Hey Barry,

Great to hear from you again.

Yeah, we sold everything to Oracle. Like it?

Love to see the execution plan for this. Especially if it's estimating that many rows but choosing to do nested loops instead of hash or merge. It's estimating that many...

Applying for jobs the trick is to get past the HR department. You do this one of two ways. First, you meet all their requirements, which may include certifications. Second,...

I'll be the contrarian here.

What I heard is one organization where technology is a necessary evil. While it's quite comfortable, you're not really going to grow and expand much in...