Viewing 15 posts - 2,956 through 2,970 (of 59,067 total)
Interesting... you expect that Developers don't need to learn SQL but you expect the DBA to know C#/EF well enough to help the Developers tune it.
Also, consider...
August 13, 2022 at 4:43 pm
Our C# developers (who know just enough SQL to be dangerous) write code using Entity Framework and I have trust that Microsoft will generate good SQL. So far so...
August 13, 2022 at 4:51 am
Post withdrawn. I found the info I was looking for.
August 13, 2022 at 12:06 am
One more small thing: if we are dealing with poor database design, sometimes neither tuning nor hardware helps.
That's frequently true with the code itself. Sometimes you've just gotta throw...
August 12, 2022 at 11:02 pm
We can agree to disagree - but let me ask you this: How can you determine which entry in your table was entered in New York - and how...
August 12, 2022 at 10:50 pm
Thanks for all the feedback everyone. Appreciated.
Me, I love tuning queries.
Yes Jeff, working on the new book. Chapter 20 right now, Graph data.
@Grant ,
Awesome... I don't...
August 12, 2022 at 4:24 pm
Having just written an article about UNIX TimeStamps, I'd done a whole lot of research on them and was just having a bit of fun here because it was fresh...
August 12, 2022 at 4:23 pm
Really nice article for those that need to use such a thing. With that being said, PLEASE don't take the following rant as any kind of demeaning of your fine...
August 12, 2022 at 2:20 am
@Jeffrey - we have shared infrastructure with thousands of sql servers, backups have dedicated network, but backups are throttled not to overutilize network and storage as backups run on...
August 12, 2022 at 1:55 am
You have to investigate what is causing that much tempdb consumption.
August 11, 2022 at 6:10 pm
My recommendation would be to start at the following URL...
August 11, 2022 at 6:05 pm
You have all the suggestions written out in your post. Just code to those. Like Granny used to say, "You can only peel one potato at a time". Pick a...
August 11, 2022 at 6:02 pm
Thank you for the advice of great books. Very useful for me. I think https://www.w3schools.com/sql/ is a good guide. I would like to ask where exactly in the programming...
August 11, 2022 at 5:50 pm
CREATE FUNCTION [dbo].[fn_GetSummaryReport] ( @pStartDate DATE, @pEndDate ...
August 11, 2022 at 3:48 am
This is resolved. Thanks.
I'm really curious... how did you resolve this, please?
August 11, 2022 at 3:41 am
Viewing 15 posts - 2,956 through 2,970 (of 59,067 total)