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,931 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
1,012 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
682 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
569 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
368 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,612 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,056 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,194 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,510 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
693 reads
Blogs
Are Blogs Still Relevant? I Think They Still Are.
As for me, I'll keep writing whenever time permits. I don't expect every post...
Reading Blogs: T-SQL Tuesday #204
By Steve Jones
This is an interesting invitation this month. Jeff Ianucci is a new host, and...
Are Blogs Still Relevant? - T-SQL Tuesday #204
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Slow - Linked server query
Hi I have this slow query that is pulling data from a linked server....
Too Many Choices
Comments posted to this topic are about the item Too Many Choices
Question of the Day
Too Many Choices
I have a table, dbo.MasterBrands, with this data:
BrandID OfficialName 1 Samsung 2 Apple 3 Microsoft 4 Adidas 5 Coca-ColaI run this query. What is returned for Coca-Cola?
SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel') FROM dbo.MasterBrands;See possible answers