I’ve been scouring my notes (old & new), wading through all my previous research and unearthing advice, tips & tricks that have all helped me in some way or another.

In this series of blog posts, I hope to share a mixture of them with you – some may be simple things you’ve heard read about a thousand times but the hope is that some of you out there, find something in this series they hadn’t heard about or possibly had even forgotten about !

Determining the number of processor cores in a SQL server?

Running the following code will quickly get this info for you :-

SELECT cpu_count/hyperthread_ratio AS cores

FROM sys.dm_os_sys_info

Keyboard Shortcuts

This is something I had completely forgotten about !

SSMS has keyboard shortcuts that allow you to execute TSQL commands at the push of a button. This not only saves time but arguably increases efficiency too.

The keyboard shortcuts menu can be found under Tools –> Options –> Expand Environment –> Keyboard. 

There are already some defaults configured, such as  sp_help (Alt+F1) and sp_who (Ctrl+2).

Of course you can create your own customised shortcuts to suit your needs.

Simply allows you more time to make your coffee then I guess !