Why I am called BlobEater
It’s coming towards the holiday season for me and I thought that I would wind-down a little with a non-technical...
2016-12-17
517 reads
It’s coming towards the holiday season for me and I thought that I would wind-down a little with a non-technical...
2016-12-17
517 reads
I look at locking resources within Azure as a safety mechanism where it can protect users from accidental deletion, it...
2016-12-16
518 reads
Did you know that you can run DBCC CHECKDB (WITH PHYSICAL_ONLY) and issue page restores from SSMS (SQL Server Management...
2016-12-15
463 reads
Following on from my previous post on NOLOCK (https://blobeater.blog/2016/12/09/nolock/) I want to talk about another hint called READPAST. This hint tells...
2016-12-13
446 reads
NOLOCK, some say it’s a fast option for queries and will never cause blocking, I say it’s quite dirty and...
2016-12-09
2,320 reads
This week’s TSQL Tuesday is being held by the mighty Kenneth Fisher – Backup and Recovery- see this link, how can...
2016-12-26 (first published: 2016-12-07)
1,496 reads
Wait stats is my go to thing, however I do get bored just querying it via a table so I...
2016-12-06
797 reads
When you have many SQL databases that are required to run your environments and they show signs of specific usage...
2016-12-12 (first published: 2016-12-02)
1,438 reads
Not a technical post today (not that I am technical) but still an important one. I have been using Azure...
2016-12-01
626 reads
Trace flags are used to temporarily set specific server characteristics or to switch off a particular behavior. They are usually...
2016-12-01
573 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