Strategizing your Index Maintenance in SQL Server
Index maintenance is part of the DBA’s life. Surely you have a maintenance task for this somewhere running daily or...
2013-09-28
1,258 reads
Blog Posts
Azure Offerings Continue to Expand
We just received word of a bunch of new functionality over at Scott Guthrie’s blog. Not a lot of stuff...
2013-09-27
1,322 reads
Interviews with Great SQL People – Authors, MVPs, many more
I’m trying really hard to write a blog that goes over all the great #sqlpass interviews we’ve done, but work...
2013-09-27
1,266 reads
List all mapping users of SQL login account
Find a useful system store procedure to list all mapping user of SQL login account.
sp_msloginmappings @Loginname , @Flags
@loginname: the login account name, If...
2013-09-27 (first published: 2013-09-24)
9,862 reads
Monday Night Networking at the 2013 PASS Summit
For the fourth year Steve Jones and I are hosting an informal networking dinner on Monday night at the PASS...
2013-09-27 (first published: 2013-09-25)
1,033 reads
Reblog: September 20 to September 26
I’ve always been a fan of the feeling when I find an old blog post that’s got just the information...
2013-09-27
1,352 reads
Can You Compress a Temp Table?
Hello Dear Reader! We are finishing up the final day of the Performance Tuning Workshop here in Atlanta and I...
2013-09-26 (first published: 2013-09-24)
7,515 reads
I Just Voted in the PASS 2013 Election
I feel like it’s been a good election cycle. Good set of candidates, good discussions, lots of good blog posts...
2013-09-26
575 reads
Images, charts, indicators and sparklines in a tablix stretch and degrade report performance
This fact is probably not documented very well but this is an important factor in SSRS visual report design… The...
2013-09-26
737 reads
Images, charts, indicators and sparklines in a tablix stretch and degrade report performance
This fact is probably not documented very well but this is an important factor in SSRS visual report design… The...
2013-09-26
369 reads
Blogs
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Forums
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
The String Distance I
Comments posted to this topic are about the item The String Distance I
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers