Cumulative Update 5 For SQL Server 2005 SP3
Microsoft has released the latest Cumulative Update for SQL Server 2005 SP3, which is Build 4230. They also released a...
2009-08-21
469 reads
Blog Posts
Denver SSUG – AUG 2009
I attended the Denver SQL Server User Group meeting, wanting to get a chance to catch up with some friends...
2009-08-21
1,107 reads
Ideas are a work of art
When you think about it, most of us in the IT field are paid to solve problems. Sure there are...
2009-08-21
377 reads
Keeping SQL Server Client Tools Up-to-Date
In a recent forum thread, someone asked to see who created/altered a particular object. Starting in SQL Server 2005, this information is...
2009-08-21
1,407 reads
SQL Down Under Code Camp to be Held in October
If you live in Australia, or are just looking for an excuse for a vacation in Australia, sign up for...
2009-08-21
659 reads
SQL Lunch
Baton Rouge SQL Server group leader and recent SQL Saturday host Patrick LeBlanc is putting together a new learning series. ...
2009-08-21
697 reads
SQL Profiler – Wild Card Filter on TextData
WARNING: This may be very obvious to most of you. However, several people that I have encountered did not realize...
2009-08-21
37,264 reads
SQL Quiz #5 – SANs the Star the Show Must Go On(Mirroring)?
Okay, Jorge Segarra (@SQLChicken) tagged me in Chris Shaw’s (@SQLShaw) latest SQL Quiz, SAN’s and Mirroring. I’m a little behind...
2009-08-21
331 reads
The Kindle Update - A Month on the iPhone/iTouch
Ever since my Kindle broke, I've been reading on my iTouch for the most part. I've been using both the...
2009-08-21
772 reads
What happens when you use WITH RECOMPILE
I saw this question and my immediate thought was “Well, duh, the execution plan is recreated by a recompile.” But,...
2009-08-21
1,321 reads
Blogs
sp_snapshot – The easy way to take database snapshots of one or more databases – V3.0
Presenting you with an updated version of our sp_snapshot procedure, allowing you to easily...
SELECT *
SELECT * feels convenient, but in SQL Server it bloats I/O, burns network bandwidth,...
SQL Server is Slow, part 3 of 4
By Kevin3NF
In parts 1 and 2 of this series, we’ve gathered info and done the...
Forums
Extract sql data in psh
# Load ImportExcel module Import-Module ImportExcel -ErrorAction Stop # File paths $outFile = "C:\Reports\SQLReport.xlsx"...
caught off guard by some greek lettering in a warehouse feed
Hi we run 2019 standard. Our warehouse's ssis based etl is klunky but so...
Unlocking High-Concurrency Inserts in SQL Server with OPTIMIZE_FOR_SEQUENTIAL_KEY
Comments posted to this topic are about the item Unlocking High-Concurrency Inserts in SQL...
Question of the Day
Vector Datatype
The new Vector datatype in SQL Server 2025 is a binary type that has a few parameters. What parameters are required?
See possible answers