SELECT COUNT(*) vs COUNT(1) vs COUNT(ColumnName)
What is the difference between COUNT(*), COUNT(1) and COUNT(ColumnName)? A mystery that will never be known… ok that was a...
2011-09-15
13,155 reads
What is the difference between COUNT(*), COUNT(1) and COUNT(ColumnName)? A mystery that will never be known… ok that was a...
2011-09-15
13,155 reads
Those who know me will know that this post is a little out of the ordinary… I am posting about...
2011-08-12
4,480 reads
I’ll be honest, I am partially writing this because I always forget how to reset the identity column on a...
2011-08-11
1,334 reads
First of all if you came out to my webinar this morning let me say a huge thank you! I...
2011-08-10
651 reads
Tomorrow I will be presenting a webinar at 11 AM eastern time for the Pragmatic Works Training on the T’s. ...
2011-08-08
912 reads
SQL Saturday in South Florida is quickly approaching in just 2 short weeks. As usual, if you are in the...
2011-08-03
662 reads
Oh no you, you got the Could not load type ‘Microsoft.AnalysisServices.SharePoint.Integration.ReportGalleryView’ error!!! What to do now? Why did you get...
2011-08-02
1,069 reads
SQL Saturday #85 is quickly approaching. It will be held in sunny Orlando, FL so if you live in the...
2011-07-30
2,068 reads
One of the most annoying processes with SharePoint is backing up a site collection. There is a build in tool...
2011-07-13
1,889 reads
It has been a few weeks since I last posted. I know, I’m a slacker, thanks for pointing that out. ...
2011-07-10
394 reads
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
You can find the slides and SQL scripts for my session “Spice up your...
Comments posted to this topic are about the item Communication, For Incidents and Life
Comments posted to this topic are about the item PostgreSQL psql Meta Commands: Tables
Comments posted to this topic are about the item Building a Support Ticket Triage...
Which of the following psql meta commands (also called backslash or slash commands) will provide information about tables within a database?
See possible answers