Should I use option(recompile)?
This will probably be a multiple stage discussion. The notes I’m providing today were sparked off of the content located...
2016-02-02
2,010 reads
Sheldon Hull
Easy way to test log shipping or availability groups setup
Have been working through the fantastic training resources from Brent Ozar’s Everything Bundle and on the recommended resources they mention...
2016-01-29
810 reads
Easy way to test log shipping or availability groups setup
Have been working through the fantastic training resources from Brent Ozar’s Everything Bundle and on the recommended resources they mention...
2016-01-29
600 reads
Transaction Logging & Recovery (part 3)
Transaction Logging & Recovery (part 3)
… Continuation of some notes regarding the excellent content by Paul Randal in *Pluralsight: SQL Server:...
2016-01-20
835 reads
Transaction Logging & Recovery (part 3)
… Continuation of some notes regarding the excellent content by Paul Randal in *Pluralsight: SQL Server: Logging, Recovery, and the Transaction...
2016-01-20
408 reads
Verifying Instant File Initialization
Verifying Instant File Initialization
Ran into a few issues verifying instant file initialization. I was trying to ensure that file initialization...
2016-01-13
254 reads
Verifying Instant File Initialization
Ran into a few issues verifying instant file initialization. I was trying to ensure that file initialization was enabled, but...
2016-01-13
321 reads
Transaction Logging & Recovery (part 2)
Transaction Logging & Recovery (part 2)
… Continuation of some notes regarding the excellent content by Paul Randal in Pluralsight: SQL Server:...
2016-01-08
441 reads
Transaction Logging & Recovery (part 2)
... Continuation of some notes regarding the excellent content by Paul Randal in Pluralsight: SQL Server: Logging, Recovery, and the Transaction...
2016-01-08
316 reads
Transaction Logging & Recovery (101)
Logging & Recovery Notes from SQL Server Logging, Recovery, and the Transaction Log (pluralsight) Paul Randal
Going to share some key points...
2016-01-05
454 reads
Blogs
Monday Monitor Tips: Configuring Access to the MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
Forums
A Challenge of Our Knowledge
Comments posted to this topic are about the item A Challenge of Our Knowledge
The memory toll of VARCHAR(MAX) in SQL Server
Comments posted to this topic are about the item The memory toll of VARCHAR(MAX)...
Transaction Log Truncation
Comments posted to this topic are about the item Transaction Log Truncation
Question of the Day
Transaction Log Truncation
In SQL Server 2025, where can I find information about items that prevent or delay the transaction log truncation?
See possible answers