SQL Server Statistics

INTRODUCTION
Statistics contain information about the data. How the data is distributed inside the table. They are representation of a table....

Do you want me to tell you the truth or do you want me to tell you what you want to hear?

We live in a Dilbert age.
If you are a DBA and have worked in organizations of any size you are...

Houston Tech Fest 2013 - SQL Admin Best Practices with DMV's

Here is the downloadable file with all my sample scripts and slidedeck from my SQL Admin Best Practices with DMV's presentation from...

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...

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...

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...

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...

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...

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...

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...