Over the years the page size in SQL Server has changed, growing larger to fit larger data sets. However not all functions have been modified to work with larger page sizes. Or even exceed them. Steve Jones wonders if it's time to increase the page size.
2014-10-23 (first published: 2010-02-11)
393 reads
2014-10-23
2,101 reads
The 2014 PASS Summit is coming up in a few weeks and thousands of SQL Server professionals will be coming...
2014-10-22 (first published: 2014-10-15)
6,572 reads
Today I’m off across the Atlantic again. SQL in the City 2014 kicks off in London and I have 3...
2014-10-22
998 reads
Most people prefer to work with the platforms that they are familiar with, but there is always pressure to try new, exciting technologies when others have success. Steve Jones explores the idea of switching platforms.
2014-10-20
165 reads
2014-10-20
1,540 reads
What's the most important thing about your application? The code? The accuracy of its calculations? The layout of the reports? Steve Jones has another opinion.
2014-10-17 (first published: 2009-12-09)
204 reads
2014-10-17
1,768 reads
The 2014 PASS Summit takes place next month. Actually a few weeks, on Nov 3-7, 2014 in Seattle. While many...
2014-10-16
798 reads
London, Oct 24, 2014
Seattle, Nov 3, 2014
Come join us.
Filed under: Blog Tagged: Humor, syndicated
2014-10-16
814 reads
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...
EightKB is back again for 2026! The biggest online SQL Server internals conference is...
Comments posted to this topic are about the item Vectors in SQL Server 2025
Comments posted to this topic are about the item Odd Sequences
Comments posted to this topic are about the item Everything is the right question...
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