-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Nebraska SQL from @DBA_ANDY

I’m a forty-something Microsoft SQL Server DBA of 15+ years, a devoted husband, and a father of three young boys. I have been a DBA at a public university, at a major bank, at a healthcare system, and I now work as a remote DBA with customers across the United States. I write and speak primarily about the tips and tricks that I discover along my SQL Server journey.

Archives: March 2017

Querying SQL and Windows Version Info with T-SQL

Just a quick one today - I see questions sometimes about polling Windows information from inside SQL Server itself.  There are a couple of frequently touted options:


--


(1)  SELECT @@VERSION


The most basic option, and it does return most of what we want but not in any kind of…

Read more

4 comments, 3,483 reads

Posted in Nebraska SQL from @DBA_ANDY on 24 March 2017

Embrace The Missing Index DMVs - But Proceed with Caution!

One of the performance tools I use all of the time is the set of Missing Index DMVs: 
·         sys.dm_db_missing_index_details– Detailed specifics on the missing indexes, including column lists 
·         sys.dm_db_missing_index_groups– relates individual missing indexes to index groups
·         sys.dm_db_missing_index_group_stats– information on potential…

Read more

1 comments, 2,413 reads

Posted in Nebraska SQL from @DBA_ANDY on 9 March 2017