Planes Trains and Automobiles
I was going to write a short post showing some useful queries that can help you manage your vCentre environment,...
2011-06-10
510 reads
Statistics IO parser in Ruby & Python
Here I am working on tuning a rather large stored procedure; old school. I have statistics IO and showplan turned on. I work through the obvious missing indexes and improper...
2011-06-10
12 reads
Statistics IO parser in Ruby & Python
Here I am working on tuning a rather large stored procedure; old school. I
have statistics IO and showplan turned on. I work through the obvious
missing indexes and improper joins and now...
2011-06-10
52 reads
Statistics IO parser in Ruby & Python
Here I am working on tuning a rather large stored procedure; old school. I have statistics IO and showplan turned on....
2011-06-10
671 reads
Stored procedures vs. Do-It-At-Application-Layer-At-All-Costs
Many years back when ASP 2.0 (not ASP.NET) was used as primary server language for web application on Microsoft platform,...
2011-06-10
769 reads
Easier way to view SQL Server job history
Ever get a timeout error when using the “View History” for a SQL Server Agent job? I find this happens...
2011-06-10
4,392 reads
Microsoft TechDays 2011 in Kosova, Prishtina
It's late but I need to say some words about our local tech event, it is the only one that...
2011-06-10
2,000 reads
Book Review: Make the Impossible Possible: One Man”s Crusade to Inspire Others to Dream Bigger and Achieve the Extraordinary
I finished reading Make the Impossible Possible: One Man”s Crusade to Inspire Others to Dream Bigger and Achieve the Extraordinary...
2011-06-10
797 reads
Re-blog – June 3-June 9
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Some posts...
2011-06-10
553 reads
How Query execute
*This is my Opinion Whenever you execute any query…. Everything will be on Memory unless data is not available from...
2011-06-10
482 reads
Blogs
Flyway Tips: Object History
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
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...
Forums
Looking for old SQL Server 1.x - 4.21 disks, manuals, boxes, etc.
Hi everyone, I'm hoping some of the longtime SQL Server professionals here might be...
Checking the Error Log II
Comments posted to this topic are about the item Checking the Error Log II
Parameter Sniffing on SQL Server 2025: A Walkthrough with Real Numbers
Comments posted to this topic are about the item Parameter Sniffing on SQL Server...
Question of the Day
Checking the Error Log II
What is the reason I should change my old code that uses xp_readerrorlog?
See possible answers