A filtered index eliminates unusable entries from the index, producing an index that is as beneficial as, but much smaller than, an unfiltered index. If a certain subset of a table's data is frequently requested, a filtered index can also be a covering index; resulting in a considerable reduction in IO.
Today Steve Jones talks about the relation between hurricanes and poptarts, and why you should be working on your T-SQL skills.
A blog from Dan Jones of Microsoft asks you to test the next release of SQL Server, in CTP3 now, and send your feedback to Microsoft to ensure that the product is well tested.
It seems that in some SQL Server shops the use of the NOLOCK (aka READUNCOMMITED) hint is used throughout the application. In this tip we take a closer look at how this works and what the issues maybe when using NOLOCK.
This article describes a utility that is able to report the most common DBCC CHECKDB errors significantly faster than DBCC CHECKDB does itself.
There seems to be no shortage of IT jobs in the US, and Steve Jones reminds us that the shortage is for talented workers, not just workers.
Often we face the situation where we need to check the total disk space and available disk space for both physical and LUN/Mount drives. See how this can be done using PowerShell.
With the one hand, Chris applauds the outstanding work of the SQL Server community, and tentatively raises the other to ask if we're on the cusp of a chance.
A new feature of SSRS 2008 R2 is the ability to name sheets in exported Excel workbooks. This article explains how to utilize this feature.
By Steve Jones
At the recent Redgate Summit in Chicago, I demo’d (lightly) the ML based Alert...
By Steve Jones
los vidados – n. the half-remembered acquaintances you knew years ago, who you might...
By Brian Kelley
I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class...
FARE Labs provides nutritional testing for food items and agricultural goods in order to...
I'm trying to get this string_agg to put all the 'comments' into one result...
Comments posted to this topic are about the item Vectors in SQL Server 2025
What values are returned from this code?
CREATE SEQUENCE NumericSequence
AS NUMERIC(5,1)
START WITH 1.0
INCREMENT BY 0.1;
GO
SELECT NEXT VALUE FOR NumericSequence
GO
SELECT NEXT VALUE FOR NumericSequence
GO See possible answers