Maximum Row Size in SQL Server 2005
What is the page size in SQL Server 2005? That's an easy question, but what is the maximum row size? They're not the same thing and ANdy Warren shows you why.
Ninja's Return
One of our top posters and valuable member of the SQLServerCentral.com community weighs in on his absence.
Change SQL Server stored procedures with batch editing
Learn how to change a group of SQL Server stored procedures (SPs) that perform tasks in your databases. Edit SQL Server SPs at one time with these steps.
More Than One Way to Skin a Cat
There are many ways to accomplish a task in SQL Server, and almost every technology. But too much choice might not be the best thing for beginners.
More Than One Way to Skin a Cat
There are many ways to accomplish a task in SQL Server, and almost every technology. But too much choice might not be the best thing for beginners.
More Than One Way to Skin a Cat
There are many ways to accomplish a task in SQL Server, and almost every technology. But too much choice might not be the best thing for beginners.
Taking the Temperature of Your Data
Enhanced model performance comes from extracting as much information content as possible… relative to the specific performance metrics you are using to measure success.
And Then There Was One
Windows 2008 RTMs, a change from the SQL Server support team, and a Jump Start for Katmai.
The Identity Debate
Using the Identity Property might be one of the more debated features of SQL Server. This editorial was originally published on Mar 5, 2008. It is being re-run as Steve is on vacation.
Implementing a Generic Data Access Layer in ADO.NET Part 1
In Part 1 of a 3 Part Series Joydip Kanjilal discusses the implementation of a provider independent Data Access Layer in ADO.NET.
Blogs
On Speaking Well
By Brian Kelley
Professor Patrick Winston of MIT used to give a one-hour talk about how to...
Monday Monitor Tips: Oracle Custom Metrics
By Steve Jones
One of the popular features of Redgate Monitor has been the ability to add...
Walking Through a Planned Failover: SQL Server Always On Availability Groups on Kubernetes
When building the sql-on-k8s-operator, I wanted to make sure it could handle both planned...
Forums
Analysis of Locking Issues on Secondary Replicas in AlwaysOn Availability Groups
We have an AlwaysOn architecture with four replicas: two running in synchronous commit mode...
The Vector Data Type
Comments posted to this topic are about the item The Vector Data Type
What Power BI DirectQuery does to your SQL Server (and how to fix it)
Comments posted to this topic are about the item What Power BI DirectQuery does...
Question of the Day
The Vector Data Type
What is the vector data type in SQL Server?
See possible answers