Getting Fast Counts of Large Service Broker Queues
Getting Fast Counts of Large Service Broker Queues
This question regarding getting a fast count from a service broker queue came...
2011-01-18
2,184 reads
Blog Posts
January OPASS Meeting
January’s OPASS meeting will be held this Thursday, January 20th at 6pm. We will be meeting at the Hampton Inn, 850 Village Oak Lane, Lake Mary. SQL Server...
2011-01-18
6 reads
January OPASS Meeting
January’s OPASS meeting will be held this Thursday, January 20th at 6pm. We will be meeting at the Hampton Inn,...
2011-01-18
608 reads
New Cumulative Updates for SQL Server 2008 SP1 and SP2
Microsoft has released new cumulative updates for both SQL Server 2008 SP1 and SQL Server 2008 SP2. Remember, both of...
2011-01-18
703 reads
PASS SQLRally Professional Development Vote Done and the Development Track Vote is open
Congratulations to the winners in the Professional Development Track Vote for PASS SQLRally. You can see the winners at http://www.sqlpass.org/sqlrally/2011/Agenda/Sessions/SessionsProfessionalDevelopment.aspx. Now the voting is open for the Database &...
2011-01-18
9 reads
PASS SQLRally Professional Development Vote Done and the Development Track Vote is open
Congratulations to the winners in the Professional Development Track Vote for PASS SQLRally. You can see the winners at http://www.sqlpass.org/sqlrally/2011/Agenda/Sessions/SessionsProfessionalDevelopment.aspx.
Now the...
2011-01-18
781 reads
PowerShell Week at SQL University – Post 4
Recap So far we’ve walked though how to turn on PowerShell and add modules, adding SQL Server 2008 snapins and using PowerShell variables, what cmdlets and functions are, what...
2011-01-18
24 reads
PowerShell Week at SQL University – Post 4
Recap
So far we’ve walked though how to turn on PowerShell and add modules, adding SQL Server 2008 snapins and using...
2011-01-18
1,371 reads
RTFM365, Week 6
Just a quick note this week….things are quite crazy right now, and I’m struggling to keep reading on my days...
2011-01-18
437 reads
SQL Lunch - Build Your First PerformancePoint Dashboard with MVP Adam Jorgensen
SQL Lunch - Building a Performance Point Dashboard
Don't forget to attend the SQLLunch tomorrow.
#35-Building your first PerformancePoint Dashboard in SharePoint 2010
Speaker:...
2011-01-18
1,227 reads
Blogs
Learn about Modern Microsoft Apps in San Diego
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
How To Deploy Fabric SQL and Azure SQL Databases with Azure DevOps
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
A New Word: Attriage
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
Forums
Getting results from a Procedure to join to a query
I have a need to execute a stored procedure and return the results to...
Upgrade 2016 Standard to 2022 Express
Title pretty much says it all - can this be done? I've tried several...
BIT_COUNT II
Comments posted to this topic are about the item BIT_COUNT II
Question of the Day
BIT_COUNT II
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37 4 NULLWhat is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 4;See possible answers