My SQLSat54 Experience
In case you hadn’t heard SQLSaturday #54 was Oct 23 in Salt Lake City. It was a dreary opening to...
2010-10-25
1,109 reads
SQL RNNR
A Haunting TSQL Tuesday Tale
Time for the ghouls and goblins to come out of the woodwork once again for another tale of deception and...
2010-10-12
1,419 reads
A Haunting TSQL Tuesday Tale
If you truncate a table, you cannot undo the action like you can with a delete. What is the difference between the two methods to remove data from a...
2010-10-12
October 2010 TSQL Tuesday Reminder
Holy Cow, another month has flown by without much of a hint. We now have upon us another TSQL Tuesday....
2010-10-07
635 reads
It’s Implied
This has been on my radar now for a little over a week. I ran across a request in the...
2010-10-05
736 reads
The Year of the Phantom
It is amazing how fast time moves the older (and slower) we as humans get. Looking back on time, it...
2010-10-03
621 reads
Red Pyramid
After having read the Percy Jackson series of books, I wanted to read a few more books by Rick Riordan....
2010-10-02
464 reads
SQLSat 54
Wow, I have really been kinda slow in the blog department for a couple of weeks now. I have a...
2010-10-01
578 reads
TSQL Tuesday Indexes and Blobs
Woohoo – chugga chugga chugga chugga – woo woo. The train is pulling into town once again for another installment in the...
2010-09-15
1,736 reads
September TSQL Tuesday
It is hard to believe that time is flying like it is. Already it has been a month since I...
2010-09-08
520 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