Return of Index Analysis Part 5
Let’s Anaylze An Index!Alright, up to the last of the changes I’ve made to the index analysis query that I...
2010-10-25
1,528 reads
StrateSQL
3-Weeks to PASS Summit 2010 Countdown -
Only 3 more weeks until the PASS Summit and it’s time for another countdown post. I’ve done a few of...
2010-10-23
749 reads
SQL Saturday 58 Next Week
Wow! Minnesota’s SQL Saturday event is next week already. We still have a lot to do to be ready. Some...
2010-10-22
554 reads
Return of Index Analysis Part 4
Let’s Anaylze An Index!We’ve got through the first three parts of this continued series on the Index Analysis query last...
2010-10-22
609 reads
SSWUG Fall 2010 Virtual Conference Starts Today!
Conference Time! The SSWUG Fall 2010 Virtual Conference is starting today. It’ll go on from today through Friday – if might...
2010-10-20
574 reads
SSWUG Fall 2010 Virtual Conference This Week
Conference Time! The SSWUG Fall 2010 Virtual Conference is coming up this week. On October 20-22, you can attend a...
2010-10-18
557 reads
4-Weeks to PASS Summit 2010 Countdown – Lunch
There are now 4 weeks until the PASS Summit and a few times now I’ve discussed ( 1, 2, 3 ) some...
2010-10-14
773 reads
Finding Missing Values from an Array
Missing NumbersToday a developer came up to me and wanted help solving a problem he was running into with a...
2010-10-13
1,033 reads
Return of Index Analysis Part 3
Let’s Anaylze An Index!Time for part three of my continued Index Analysis query. The previous posts in this series are:...
2010-10-13
967 reads
Project Phoenix
Project PhoenixSometime people need a hand up – an opportunity to rise from the ashes. Over the last couple of years...
2010-10-09
888 reads
Blogs
The CDO’s Playbook for AI Driven Decision Making
By Chris Yates
The New Arena of Leadership The role of the Chief Data Officer is no...
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,...
Forums
combining a param value with widcards in a foreach loop files property
Hi, it isnt clear from the web if something like this should work as...
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...
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