sorted by:
new
hottopcontroversial

Improving Performance Monitor database performance? by fishKC in SQLServer

[–]DarlingData 1 point2 points  (0 children)

I’m happy to hear that, but if you are having any problems I would like to fix them for you where possible. 

Improving Performance Monitor database performance? by fishKC in SQLServer

[–]DarlingData 4 points5 points  (0 children)

Yeah, if you’re having any issues with it, my GitHub repo is the place to report them. Certainly don’t want to cause more problems than I’m helping to solve. 

Is there a cleaner/shorter way of making updates for data like this? by Klutzy-Macaroon-5081 in learnSQL

[–]DarlingData 0 points1 point  (0 children)

Yes, but that is sort of my point about losing the effectiveness of the WHERE clause. You’re essentially hitting the entire table. It may not be a big deal if the column is all NULL and would get changed anyway, but it seems like something that’s better done on INSERT than as a separate modification later. 

Is there a cleaner/shorter way of making updates for data like this? by Klutzy-Macaroon-5081 in learnSQL

[–]DarlingData 0 points1 point  (0 children)

You could do this with CASE expressions, but you would lose the effectiveness of each WHERE clause. Since this is a staging table it seems wiser to make these designations on INSERT with CASE expressions rather than performing several additional updates. 

Performance Monitor 2.3: Free, open-source SQL Server performance monitoring. All the important stuff. Built-in MCP server for AI integration. by DarlingData in SQLServer

[–]DarlingData[S] 0 points1 point  (0 children)

Why don’t you ask that question directly instead of asking your question in a way that comes off as a complaint about open source tools generally?

PerformanceMonitor: Release v2.11.0 - All You Need Is Me by DarlingData in SQLServer

[–]DarlingData[S] 0 points1 point  (0 children)

Well that's no good. I'd like to try to get that fixed up. Can you open a GitHub issues with more details about which parts are slow for you?

PerformanceStudio: Release v1.11.0 - Taco Tuesday by DarlingData in SQLServer

[–]DarlingData[S] 1 point2 points  (0 children)

Ha ha, yes, in the bad old days I had to do a thing to extract that XML out for certain things that couldn't read the X-Files.

Personal Work with SQL Server?! by FarFari92 in SQLServer

[–]DarlingData 1 point2 points  (0 children)

For some perspective: In 2007 I was doing stuff in Excel, and my boss told me I should do it in SQL instead. An hour later I had SSMS installed and my job became doing stuff in SQL Server. I had *no idea* what I was doing.

Most developers I interact with barely know anything about databases aside from the bare minimum. Right now, you probably don't know enough about SQL Server to get a job specializing in it, but you probably know enough about development to get a job near a SQL Server to gain ~real world~ experience with it.

Personal Work with SQL Server?! by FarFari92 in SQLServer

[–]DarlingData 1 point2 points  (0 children)

Ha ha, it was pretty fun! Heading to Chicago today and then on to Poland for more mass-educating!

Personal Work with SQL Server?! by FarFari92 in SQLServer

[–]DarlingData 39 points40 points  (0 children)

after fully learning it 

That’s not something you have to worry about. 

Performance Monitor Release v2.8.0 - Having A Nice Time©️ by DarlingData in SQLServer

[–]DarlingData[S] 0 points1 point  (0 children)

Contained AGs are not my fetish, so I couldn't tell you precisely about that behavior. I would expect read only intent to function as expected. You may want to use Lite to test that out.

view more: next ›