Replacing Cursors with Set-Based SQL Queries – Part 1
Part 1 of a discussion about replacing cursors with SQL statements for significant speed improvements.
In a previous post I discussed...
2011-06-27
7,988 reads
LulzSec: Why You Should Care
Updating Resume is NOT Lulz
Wow, it’s been a crazy last couple of months with LulzSec running around doing what they...
2011-06-26
1,522 reads
ALTER TABLE - Adding Column - Column Order Impact
Most of us would have altered a table structre by adding a column to the table. When an ALTER table...
2011-06-25
983 reads
Who Am I
If you’re anything like me, you use many different machines on a daily or sometimes weekly basis. Some of these...
2011-06-25
689 reads
Five Lines of Code
An interesting story on how a database speeds up by changing some application code. Worth the read for sure.
I caught...
2011-06-24
785 reads
Full Time Employees Per Number of Database Users? FTE/DB users? How Many Servers are too much to Handle?
After several days research, I have been trying to get a rough estimate on how many Full Time Employees are...
2011-06-24
3,250 reads
Configuration Manager for Sqldiag
SQLdiag is a diagnostics collection utility to collect logs and data files from SQL Server that you can use to monitor...
2011-06-24
1,119 reads
Growing Leaders
Here’s a two part story(Part 1, Part 2 from Information Week by Larry Tieman you should read. There’s a great...
2011-06-24
895 reads
SSRS 2005 Data Driven Subscription and Temporary table
Few days back I was setting up data driven subscription for a SSRS 2005 report. The command / query which populates...
2011-06-24
1,510 reads
Re-blog – June 17-June 23
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Some posts...
2011-06-24
566 reads
Blogs
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
My Social Media Rules
By Brian Kelley
I developed these rules a while back, before COVID. I had a period of...
Why Use TRY_PARSE(): #SQLNewBlogger
By Steve Jones
Someone asked why I would use TRY_PARSE after I posted a question at SQL...
Forums
ALAMAT BCA KCU SUBANG WA CS 082225313145
Hub 0822 2531 3145 Jl. Otto Iskandardinata No.37, Karanganyar, Kec. Subang, Kabupaten Subang, Jawa...
The SQL Server MCP Server
Comments posted to this topic are about the item The SQL Server MCP Server
The Hidden Danger of Wildcard Operators In Join Operations
Comments posted to this topic are about the item The Hidden Danger of Wildcard...
Question of the Day
The SQL Server MCP Server
How do I get an MCP server for my SQL Server 2025 database from Microsoft?
See possible answers