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