Like many SQL Server (and other technology) people, I utilize several social networking vehicles to stay in touch with others in the SQL community. Some of those who don’t use Facebook and Twitter (among others) have expressed skepticism of the real value of social networking. Does it work? Does it provide any value beyond entertainment? Can it actually help your career? I believe the answer to all of these queries is Yes.
Microsoft SQL Server 2008 collects statistical information about indexes and column data stored in the database. These statistics are used by the SQL Server query optimizer to choose the most efficient plan for retrieving or updating data. This paper describes what data is collected, where it is stored, and which commands create, update, and delete statistics. By default, SQL Server 2008 also creates and updates statistics automatically, when such an operation is considered to be useful. This paper also outlines how these defaults can be changed on different levels (column, table, and database).
This week Steve Jones asks about how important reading is to you, and also about what our digital rights might be in a world where we have connected platforms.
This week Steve Jones asks about how important reading is to you, and also about what our digital rights might be in a world where we have connected platforms.
This week Steve Jones asks about how important reading is to you, and also about what our digital rights might be in a world where we have connected platforms.
This article, the first in a series, discusses T-SQL coding best practices. Join Greg Larsen as he explains how to write queries to optimize SQL Server resources and improve performance.
Steve Jones is more willing to ask for changes in software than the real world. Is that a good thing or not? Read on to find out.
Continuing with his videos on Foreign Keys, MVP Andy Warren shows us how to set constraints between two tables.
Out of all the problems you can have with SQL Server troubleshooting connectivity issues can be the most challenging. When you factor in the complexities of Active Directory and SQL Server’s interaction with it fixing SSPI errors can be down right baffling...
Paul S. Randal answers your SQL questions: How can I tell when there’s a checksum problem without waiting until the monthly maintenance plan? Is it true that using a GUID as the clustered index key can lead to performance issues with indexes? How can I choose the correct recovery model? And more!
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
By John
Today is Christmas and while I do not expect anybody to actual be reading...
I have a SQL Agent job for backing up a set of Analysis Services...
Comments posted to this topic are about the item SQL Server 2025 Backup Compression...
Comments posted to this topic are about the item The Large Encoded Value
I want to use the new BASE64_ENCODE() function in SQL Server 2025, but return a string that isn't large type. What is the longest varbinary string I can pass in and still get a varchar(8000) returned?
See possible answers