Proposed SQL Server defaults: disable lightweight pooling
A few months ago I suggested that the following settings should be the default for most SQL Server instances. Set...
2019-02-20
319 reads
A few months ago I suggested that the following settings should be the default for most SQL Server instances. Set...
2019-02-20
319 reads
A few months ago I suggested that the following settings should be the default for most SQL Server instances: Set...
2019-02-13
174 reads
Last time we looked at the four major components of a computer system, and then looked at the SQL Server...
2019-02-06
190 reads
I have been selected to speak for a second time at SQLBits, which is being hosted in Manchester UK this...
2019-01-30
229 reads
Today we’ll begin taking a look at the buffer pool in SQL Server and how it’s normally used. Before we...
2019-01-23
190 reads
A few months ago, Microsoft announced that SQL Server Management Studio (SSMS) will no longer include the visual Database Diagrams...
2019-01-16
227 reads
It’s January 2019 as I write this. I realized that I started on my journey with SQL Server in 1998,...
2019-01-09
224 reads
I consider Blob Storage to be the gateway drug to Azure, because it’s a really easy way to get going...
2019-01-02
235 reads
It’s the last post of 2018, and in years past I’ve recapped the year that has just been. This is...
2018-12-26
190 reads
I am still amused by terminology in the Information Technology field. Words like “Kubernetes,” “containers,” and the BASIC keywords PEEK...
2018-12-19
273 reads
By Steve Jones
The 11th episode is now live, recorded a few weeks ago at the PASS...
By Steve Jones
mornden – n. the self-container pajama universe shared by two people on a long...
This Black Week, don't just get a discount—get ahead! Whether you're a total newbie...
Dipping my toes into the waters of Azure and of course before I get...
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
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