SQLFool IDX Defrag Scripts
I just found out that Michelle Ufford (@sqlfool) has updated her Index Defrag scripts. Right now she is looking for...
2010-01-26
924 reads
SQL RNNR
Tweeting – I took the Dive.
In a previous post, I questioned how much Twitter could really do for me. After some comments made, and some...
2010-01-26
603 reads
Indexes Out the Window II
In Part I, I discussed some of the peculiarities and troubleshooting done in relation to a peculiar execution plan. In...
2010-01-26
840 reads
Indexes Out the Window
I ran into a peculiarly puzzling situation with a query I have been tuning of late. The query runs some...
2010-01-23
1,078 reads
PayPeriod Matching
Recently I was asked to alter a report to pull different more meaningful data. The particular report was pulling data...
2010-01-21
996 reads
Tweet, Tweet, Tweetilly Deet
In a day and age when information abounds and social networking is the only way to communicate (a bit of...
2010-01-19
525 reads
Leaving on a Jet Plane
Ok, so it’s not until November – but I am leaving on a Jet Plane nonetheless. It will have been four...
2010-01-18
554 reads
Presentations – Lessons Learned
This will be a very short entry. I just wanted to share a few things I learned very quickly while...
2010-01-15
863 reads
TSQL Tuesday – But I was Late
I was late to the game having discovered the Blog Post the day after entries were allowed. Despite that, I...
2010-01-14
828 reads
Primary Key Discovery II
In Part I, I discussed a couple of scripts that could be used to help discover some vital information about...
2010-01-13
636 reads
Blogs
Advice I Like: Training Employees
By Steve Jones
Train employees well enough that they could get another job but treat them well...
Creating a Striped Backup Set with AI
By Steve Jones
I needed to test a striped backup, so I decided to ask the AI’s...
SQL Server Migration Overview
By Kevin3NF
It’s Not Just Backup / Restore At some point every company faces it: the...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
Why Data Modelling Still Matters - More Than Ever
Comments posted to this topic are about the item Why Data Modelling Still Matters...
hops from sql server to mysql to s4 hana - possible?
Hi when i think of server hops , i think of how kerberos assists...
Question of the Day
Strange String Splits
When I run this code, how many rows are returned?
DECLARE @meals NVARCHAR(1000) = N'夕食昼食朝食' DECLARE @s NVARCHAR(1) = N'食' SELECT value FROM STRING_SPLIT(@meals, @s) GOSee possible answers