March 2011 S3OLV Meeting Recap
The Las Vegas SQL Server Users Group met on March 10, 2011. The meeting was both virtual and in-person. Good...
2011-03-15
710 reads
SQL RNNR
March 2011 S3OLV Meeting Recap
The Las Vegas SQL Server Users Group met on March 10, 2011. The meeting was both virtual and in-person. Good news – we had just about as many person...
2011-03-15
7 reads
DB Benchmarking
As database professionals, we have a need to benchmark performance of the database, processes, and essentially overall performance. When benchmarking,...
2011-03-14
1,099 reads
DB Benchmarking
As database professionals, we have a need to benchmark performance of the database, processes, and essentially overall performance. When benchmarking, it is preferable to get a baseline and then...
2011-03-14
7 reads
SQL Bitwise Operations
How many DB professionals have never had to deal with bitwise operations in SQL Server? Who has never had a...
2011-03-10
2,828 reads
SQL Bitwise Operations
How many DB professionals have never had to deal with bitwise operations in SQL Server? Who has never had a single value in the database represent more than one...
2011-03-10
22 reads
Database Maintenance
I often see a request for some scripts to help with database maintenance. Sometimes those questions come in the form...
2011-03-09
1,040 reads
Database Maintenance
I often see a request for some scripts to help with database maintenance. Sometimes those questions come in the form of recommendation requests for maintenance plans. As many already...
2011-03-09
4 reads
T-SQL Tuesday #016: Aggregates and Statistics
Data Size Collection and Analysis
By now you should be well acquainted with this phenomenon we call TSQL Tuesday. This party...
2011-03-08
679 reads
T-SQL Tuesday #016: Aggregates and Statistics
For my data analysis and trending, I wanted to find a simple distribution across quartiles.
Related Posts:
T-SQL Tuesday 109: Influence Somebody Invite December 4, 2018
T-SQL Tuesday Participation Over the...
2011-03-08
8 reads
Blogs
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Blue Sky Programming – The Optimism Trap
Many years ago, before I joined Oracle, I was working on a major modernisation...
Setting Up a Mac for Data Engineering and AI Work
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Alamat Kantor BCA KCU KUDUS Telp:0817839777
WhatsApp: 0817839777 Jl. Jend. Ahmad Yani No.91, Magersari, Panjunan, Kec. Kota Kudus, Kabupaten Kudus,...
Alamat Kantor BCA KCU SEMARANG Telp:0817839777
WhatsApp: 0817839777 Jl. Pemuda No.90-92, Kembangsari, Kec. Semarang Tengah, Kota Semarang, Jawa Tengah 50133
Question of the Day
BIT_COUNT I
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37What is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 3;See possible answers