SQLSaturday (Silicon Valley) Detect Worst Performing SQL Queries During Peak Hour
Detecting worst performing queries executed in a particular duration and how many times it got executed and fine tuning them...
2016-04-05
506 reads
Blog Posts
2016-04-05
16 reads
2016-04-05
11 reads
2016-04-05
6 reads
2016-04-05
9 reads
Views and Simplification
I’ve been getting lots of questions on views lately. Must be something in the water.
Because SQL Server allows you to...
2016-04-05
560 reads
Weekly Roundup–SQL Server and Related News
Welcome to this weeks weekly round up of links, SQL Server and other news. Its been a busy week on...
2016-04-05
408 reads
#SQLNewBlogger–Adding Local Accounts
What do you do if you need a process running under Local Service to connect to your SQL Server? Most...
2016-04-04
652 reads
Complex/Conditional ORDER BYs
Typically it’s considered best to run your queries without an ORDER BY and let the application do any sorting needed....
2016-04-04
483 reads
Don't Use Delimiters In Your Object Names!
It started with a failed backup status check:
Msg 50000, Level 16, State 1, Line 73
** Backups listed in this file...
2016-04-04
2,285 reads
Blogs
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Local Models Using GPUs with Ollama
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
Forums
Absolute and Relative References
Comments posted to this topic are about the item Absolute and Relative References
Moving Beyond the Reboot: Finding the Culprit Behind Memory Pressure
Comments posted to this topic are about the item Moving Beyond the Reboot: Finding...
Reserved Words I
Comments posted to this topic are about the item Reserved Words I