Five Facts about the SQL Server Resource Database
In this article we cover interesting facts about the hidden resource database in SQL Server and how this is used by SQL Server.
2021-04-28
System Databases
Five facts about the SQL Server Model Database
In this article we cover interesting facts about the SQL Server model database and how new databases inherit properties from the model database.
2021-04-08
Five facts about the SQL Server Tempdb Database
In this article we cover some interesting facts about the SQL Server TempDB database that could be useful to know.
2021-03-22
How to Move System Databases to a New Physical Directory
What is the easiest way to move SQL Server system databases. Let me walk you through it!
2020-05-25
26,613 reads
Blogs
Using a Local Large Language Model (LLM): Interacting with Local LLMs Using PowerShell
As AI continues to evolve, many of us are looking for ways to leverage...
Monday Monitor Tips: Finding the Hostname for Queries
By Steve Jones
I was chatting with a customer recently and they wanted to know which host...
Can AI Read Execution Plans?
Yeah, yeah, second AI post in a row. I promise not to make a...
Forums
Getting the TEXTSIZE
Comments posted to this topic are about the item Getting the TEXTSIZE
The Return to the Office Debate
Comments posted to this topic are about the item The Return to the Office...
Question of the Day
Getting the TEXTSIZE
How can I check what value I used for TEXTSIZE? I ran this code:
SET TEXTSIZE 8096But then deleted the code and couldn't remember. Is there a way to check this? See possible answers