Viewing 15 posts - 2,611 through 2,625 (of 22,214 total)
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...
April 22, 2019 at 1:16 pm
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...
April 22, 2019 at 1:12 pm
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...
April 22, 2019 at 1:08 pm
Not enough info to go on. Read the logs to determine what happened (or didn't) and why.
Are these interview questions?
April 18, 2019 at 3:21 pm
MySQL and SQL Server use different methods to execute dynamic code. This is a forum for Microsoft SQL Server, you would get better help on a MySQL forum.
Oh bugger....
April 18, 2019 at 1:21 pm
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...
April 18, 2019 at 1:15 pm
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...
April 18, 2019 at 1:12 pm
Same answer as on your other question. Parameterize the queries. Don't execute strings.
April 18, 2019 at 1:09 pm
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....
April 18, 2019 at 1:08 pm
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...
April 18, 2019 at 1:05 pm
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.
April 17, 2019 at 11:48 am
Hey Barry,
Great to hear from you again.
Yeah, we sold everything to Oracle. Like it?
April 16, 2019 at 5:13 pm
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...
April 16, 2019 at 12:02 pm
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,...
April 16, 2019 at 11:02 am
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...
April 15, 2019 at 12:04 pm
Viewing 15 posts - 2,611 through 2,625 (of 22,214 total)