We recently looked at implementing vertical partitioning on a set of data. In an earlier introduction post we also mentioned the benefits which can be seen as a result of the partitioning in both our maintenance and querying of the data. Here we’ll take a look at those benefits with a little more evidence. We’ll be using the data […]
Within SQL Server we can store Boolean data using the BIT data type. This value is a single bit which will store a True or False (or null) value. However if you dive a little deeper with the data type it’s actually a little less clear cut in terms of the storage needed for this data type. […]
For March’s T-SQL Tuesday invitation, Damien has asked us to consider a wish list for Microsoft’s partnership with OpenAI. AI has been a hot topic in recent months, largely due to the attention from tools such as ChatGPT and DALL-E from OpenAI. These tools and future iterations or derivatives will almost inevitably shape the way […]
We previously looked at an introduction to Vertical Partitioning where we covered what it is and the potential benefits and drawbacks of using it. Here I wanted to build up some data and show how we may vertically partition it to help make it more manageable for us. So that we’ve got some relevant data to use […]
Andy Brownsword 