Daily Coping 20 Sep 2022
Today’s coping tip is to find a caring, calming phrase to use when you feel low. Life is mostly good, but there are times I feel down, depressed, low,...
2022-09-20
12 reads
Conversion Precedence
Recently I talked about the difference between implicit and explicit datatype conversions. In it I ran this code: With the ... Continue reading
2022-09-20
25 reads
Meetings Are Work Too
So Many Meetings I’ve said it. We’ve all said it.
I can’t get any work done today, I’ve got so many meetings.
I need to be reminded on occasion that for...
2022-09-20
128 reads
Extended Events for Anything but Query Tuning: bulk_insert_usage
Wouldn’t it be great to be able to directly monitor specific behaviors within SQL Server, like, oh, I don’t know, knowing exactly when, and how, someone is using BULK...
2022-09-19
47 reads
Daily Coping 19 Sep 2022
Today’s coping tip is to make time to remember if you’re busy, allow yourself to pause and take a break. I’m in the UK today, and at the Redgate...
2022-09-19
15 reads
Book Review: SQL Server Query Tuning & Optimization
If you are like me and still prefer the physical book as your primary reading material, Benjamin Nevarez's book from Packt Publishing is a great book to add to...
2022-10-03 (first published: 2022-09-19)
429 reads
Comment might be free, but that doesn’t mean I have to listen
I have turned off comments on this site. All existing comments have been removed. Even the nice ones from awesome people, and the helpful ones, and the ones answering...
2022-09-16
74 reads
Daily Coping 16 Sep 2022
Today’s coping tip is to make time to aim to be good enough, rather than perfect. I find that many of us that work in technology want a solution...
2022-09-16
18 reads
Daily Coping 15 Sep 2022
Today’s coping tip is to make time to do something you really enjoy. I do enjoy life, and I’m lucky that I have the chance to do a lot...
2022-09-15
26 reads
Making the mouse pointer easier to see.
I know this is way off my usual content but the other day someone was mentioning how easy it is ... Continue reading
2022-09-15
37 reads
Blogs
How I Troubleshoot a Slow SQL Server Live
No two SQL Server environments are alike. A fix that resolves a performance issue...
T-SQL Tuesday #201 Invitation: Temp Tables, Friend or Foe?
By ReviewMyDB
My T-SQL Tuesday #201 invitation. Do temp tables help performance or hurt it? I...
Monday Monitor Tips: The MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, and pressing on...
Forums
Test topic for spam filtering
A new thread for testing the spam filter. Adding a link: https://www.bbc.co.uk/weather
Removing production permissions when restoring database to non-prod
Hello experts, An application team has asked us to modify a SQL Agent job....
Advanced T-SQL: Replacing Slow Cursors with Window Functions
Comments posted to this topic are about the item Advanced T-SQL: Replacing Slow Cursors...