Adaptive Query Processing – Interleaved Execution
A quick blog post to start the day, If you remember a few months ago I blogged about SQL Server...
2017-05-02
472 reads
A quick blog post to start the day, If you remember a few months ago I blogged about SQL Server...
2017-05-02
472 reads
I promised a recap/review on my first SQLBits event so I finally got around to it, hopefully you will find...
2017-04-26
487 reads
I seriously finding searching for objects within SQL Server Management Studio (SSMS) via object explorer slow, manual and fiddly especially...
2017-04-25
441 reads
I hope you take backups or have a recovery plan in place before a SQL Server service pack upgrade, if...
2017-04-24
351 reads
Imagine this scenario, you are a database professional at your place of business and you look after a mountain of SQL...
2017-04-12
495 reads
This month’s T-SQL Tuesday entry hosted by Koen Verbeeck (http://sqlkover.com/t-sql-tuesday-89-invitation-the-times-they-are-a-changing/), a blog post about how we feel about the ever...
2017-04-11
312 reads
I want to show you how I went from having multiple single SQL databases in Azure to a database elastic...
2017-04-04
574 reads
A quick video clip where I show two things. Firstly I show how since SQL Server 2014 SP1+ the snapshot...
2017-04-01
359 reads
A very quick post for today, I was navigating my way through the Azure portal within my SQL databases section...
2017-03-28
982 reads
I have never been to SQLBits (https://sqlbits.com/) before (due to budgets) but I am really looking forward to attending which...
2017-03-27
301 reads
I wanted to figure out how big (or approximately how big) my dump file...
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Comments posted to this topic are about the item Announcing SQL Server 2025
Comments posted to this topic are about the item Running Steve's Code
Comments posted to this topic are about the item New SQL Server 2022 Functions
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc] AS SELECT Consumer_ID , Trend_Category , Bit_Trace FROM NewWorldDB.dbo.MarketTrend; GOSee possible answers