GUID or Integer Primary Key?

If you are designing a new data model or maybe you are looking to improve an...

SQL server database size, location and volume info

For one of my clients, I needed to know and document not only database names, size and locations but also...

Generate SQL script to extract user permissions from a SQL database

When you restore a database, it will also restore all permissions along with it. But what if you are restoring...

How to check whether and when sql index statistics were updated last time?

I was working for a client on their very critical and heavily used database.  The application was an E-commerce website...

How to start SQL Server job using TSQL and wait for it to complete?

If you ever had a need to start a SQL job using sp_start_job stored procedure in msdb then you know...