2009-12-07 (first published: 2009-11-12)
3,073 reads
Display COUNT(*) but ONLY TOP 100
Let’s say you have a result set with 5000 records but you want to display only 100 of them and in the same time to display the count of ALL records (5000).
2009-11-20 (first published: 2009-11-05)
2,441 reads
Split string into table, separator can be more than 1 char
Split string like ('123,43,5465,6788,1231,111', ',') into table, separator (,) can be more than 1 char
2009-11-19 (first published: 2009-11-05)
1,364 reads
Blogs
Enabling an Index: #SQLNewBlogger
By Steve Jones
I don’t do a lot of work with disabled index, but I learned how...
Back to Boston for SQL Saturday
By Steve Jones
I’m leaving again tomorrow for a trip. This time I head back to Boston...
T-SQL Tuesday #179: What’s In Your Data Detective Toolkit?
By Tim Mitchell
Most of us who work with data have, at least a few times, been...
Forums
How are statistics stored?
Comments posted to this topic are about the item How are statistics stored?
Where's the Printer Friendly Option?
Comments posted to this topic are about the item Where's the Printer Friendly Option?
Switch from MSSQL SVC to MSA - Unable to start services
Using MSSQL 2019 standard edition It was installed using SVC Account. But now I...
Question of the Day
How are statistics stored?
How are the statistics for query optimization stored in SQL Server?
See possible answers