Viewing 15 posts - 2,596 through 2,610 (of 22,202 total)
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...
April 23, 2019 at 10:10 pm
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...
April 22, 2019 at 1:32 pm
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,...
April 22, 2019 at 1:26 pm
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
Viewing 15 posts - 2,596 through 2,610 (of 22,202 total)