Viewing 15 posts - 196 through 210 (of 5,842 total)
In the company I work for, we have a slowness problem in the SQL Server...
July 28, 2017 at 8:17 am
July 28, 2017 at 8:09 am
July 26, 2017 at 5:55 pm
Consider yourself lucky. I tried to encourage a developer while I was deployed to use proper data types, indexing, etc. All he would say is that the app he...
July 26, 2017 at 1:44 pm
July 25, 2017 at 12:57 pm
row_number() over (partition by a.accountnumber, a.closedChatDate order by...
July 25, 2017 at 12:48 pm
I have 45000 hours of experience with SQL Server, ALL of it with at least some focus (most with extreme focus) on performance tuning. I tell you this so you...
July 25, 2017 at 12:46 pm
Honestly your testing is will provide TRIVIAL benefits compared to the HUGELY more important issue here: your admission that you have no DBA. Thus you will ABSOLUTELY mis/suboptimally configure most...
July 24, 2017 at 9:39 am
Thanks for the response Kevin.
My take was that the SSDs are what they are -...
July 24, 2017 at 9:32 am
Can you please state what your desired output is for different inputs?
July 24, 2017 at 9:18 am
So you apparently have scalar UDFs, which a) hose the estimating ability of the optimizer, b) prevent the use of index seeks if appropriate and c) void the use of...
July 24, 2017 at 9:15 am
July 23, 2017 at 6:00 pm
I have been puzzling over this for some time and still can't grasp what the...
July 23, 2017 at 5:56 pm
July 22, 2017 at 10:47 am
Viewing 15 posts - 196 through 210 (of 5,842 total)