How To Get Table Row Counts Quickly And Painlessly
Use sysindexes\DMVs insead of select count(*) to retreive table row counts
2011-01-28 (first published: 2009-09-02)
57,795 reads
Kendal Van Dyke
Introducing MagicPASS - Orlando's New PASS Chapter
After a year of planning I'm proud to announce that South Orlando has a new PASS chapter: MagicPASS! Our first...
2011-01-13
996 reads
Resolutions For 2011
This post is a part of T-SQL Tuesday, a monthly event where SQL bloggers post about a common topic. This...
2011-01-11
675 reads
Presenting At SQLSaturday #62 - Tampa
Even though I live in Orlando - just a hop, skip, and jump away from Tampa - I've missed their SQLSaturday for...
2011-01-05
563 reads
SQLRally Session Voting Schedule Change
Jack Corbett posted the official announcement to his blog - I'm posting here as well to make sure we reach as...
2011-01-04
362 reads
2010 Goals Review
I started the year with 10 Goals for 2010 and now I'll end it by looking at how many of...
2010-12-31
1,593 reads
PASS Summit 2010 Session Eval Results
Speakers and bloggers alike crave feedback (good or bad) so I was excited to see my session evaluations from the...
2010-12-23
1,045 reads
Social Leadership And The SQL Community
2010 is rapidly coming to a close and in retrospect this has been a fantastic year of growth for the...
2010-12-17
1,190 reads
2010 PASS Summit Slide Decks and Scripts
How time flies - it really has been almost 2 1\2 weeks since the 2010 PASS Summit came to a close!...
2010-11-30
1,500 reads
2010 PASS Summit Recap
The 2010 PASS Summit has been over for a week and a half now and I've finally recovered & processed everything...
2010-11-23
683 reads
Blogs
T-SQL Tuesday #199 Invitation: Back to on-prem?
It’s time for T-SQL Tuesday again! And we’re almost to number 200! T-SQL Tuesday...
Data Skew in Data Engineering: What It Is and How to Fix It
You kick off a distributed job expecting it to finish in minutes — but...
Error Deploying GraphQL in Fabric: dm_exec_describe_first_result_set
A while ago we suddenly had an error while trying to deploy one Fabric...
Forums
Fuzzy String Matching in SQL Server 2025
Comments posted to this topic are about the item Fuzzy String Matching in SQL...
Representing Money
Comments posted to this topic are about the item Representing Money
Celebrating 30 years of PostgreSQL, A Thank you message
Comments posted to this topic are about the item Celebrating 30 years of PostgreSQL,...
Question of the Day
Representing Money
Which types of currency does the money data type represent?
See possible answers