Did you know that we can have basic datetime arithmetics in SQL server? We can use subtraction to find an accurate difference between two dates, and use addition to add an accurate interval to a datetime column or variable.
Read this post to learn more.
This month’s T-SQL Tuesday is hosted by Brent Ozar, who asks us to Blog about our Favorite Data Type (or Least Favorite).
I find it actually quite easy to decide both on a most-favorite, as well as a least-favorite data type in SQL Server. So, why not blog about both?
This is one of those things that I would have never expected to adopt, and yet here I am! Not just loving “infinite” loops, but also confident enough that I can convince you to feel the same!
Read More »I learned to love WHILE (true) and you should too
This month’s #tsql2sday came to us from Rob Volk (b|t), who asks us to explain databases using an analogy, as if explaining to a 5 year old. I’m actually a big fan of The Feynman Technique (aka ELI5), so I really wanted to participate. But to be honest, I nearly missed out this time simply because I couldn’t think of an idea this whole week.
On the very last day, when the posts already started rolling out by all the bloggers, I’ve read a few, and only then the muse finally hit me. I kid you not, the time is literally 23:59 here in Israel as I hit the publish button!
So anyways, the idea I had was for the ALTER TABLE..SWITCH TO command in SQL Server.
Read More »T-SQL Tuesday #131 – Star Trek Candy and SWITCH TO
In this blog post I’ll help you troubleshoot the rare but critical issues of Deadlocked Schedulers and high THREADPOOL waits – using practical means.
Also, very useful T-SQL script towards the end.
Read More »How to Troubleshoot THREADPOOL Waits and Deadlocked Schedulers
Assume you have some kind of process outside the SQL Server which is supposed to record some kind of database activity. There are many ways to do it, most of which require constant and/or stable connection to the database. But what if that’s not good enough? Let’s consider our options.
Read More »Using Extended Events as a Buffer
In one of my previous blog posts, Automatically Enable or Disable Jobs based on HADR Role, I provided a solution for automatically enabling or disabling scheduled jobs in combination with Availability Groups and Database Mirroring. In this blog post, I’m going to build upon my previous solution and improve it even further – taking it to the next level of automation!
Read More »Control SQL Jobs based on HADR Role – Taking it to the Next Level
You might have seen this blog post by Paul White: New Metadata-Only Column Changes in SQL Server 2016. It talks about how, when a table is compressed, you can change (i.e. increase) a column’s data type without having to create a new table and migrate the data into it, and without having to refactor all of the underlying data. But, not everything is rainbows and unicorns…
Read More »The new “metadata-only column changes” feature in SQL Server 2016 is useless!
We all know the error log used by SQL Server to audit failed logins by default. But is it good enough? For many scenarios, it isn’t. It’s actually missing a lot of important information. But, worry not, for there are better solutions!
Read More »Finding the Details Missing from the SQL Server Failed Logins Audit
Today’s script has something very interesting to do with Heap tables. Specifically, how to turn them into something that’s not a heap. Continue reading for more info…
Read More »How to Un-Heap Your Heaps?