How to find out whether your database is transactional, analytical or hybrid?

If you are a DBA, especially Infrastructure DBA, Production DBA or Operations DBA then you don't necessarily always know what...

Get SQL server database size, location and volume info using DMVs

SELECT * FROM sys.master_files AS f 
CROSS APPLY sys.dm_os_volume_stats(f.database_id, f.file_id) v; 

GUID or Integer Primary Key?

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

Easy to use WMI commands to query windows system

WMI has been around for a while and it has grown significantly over the years. With Microsoft's focus on powershell,...

SQL query to shrink all log files on sql instance

USE master

exec sp_MSforeachdb '

use [?]
 print ''?''
 print cast(databasepropertyex(''?'', ''Updateability'') as varchar(200))

 if databasepropertyex(''?'', ''Updateability'') = ''READ_WRITE ''

   dbcc shrinkfile(2,1)

'

T-SQL Developer Interview Questions with Answers

What SQL command do you use to pull and filter data from a table ?  

SELECT [Column List] FROM [Table Name]...

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

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