How Many Objects Can Own Pages in a Mixed Extent
I saw an exchange on Twitter this past weekend on the #sqlhelp hash tag about how pages are allocated for...
2015-09-14
656 reads
Robert Davis
- Interests: Poker, computers, reading/writing horror fiction
Oklahoma City User Group Presentation Files
Earlier this week, I got the opportunity to present online for the Oklahoma City SQL Server User Group on SQL...
2015-07-15
717 reads
Error Creating Remote Distributor When Creating a Local Distributor
Recently, I was working on a Peer-to-peer replication automation project. When I switched from my local test servers to some...
2015-04-16
751 reads
T-SQL Tuesday #65 – Overcoming Variable Limitations in SQLCmd Mode
It’s time again for that T-SQL blog party T-SQL Tuesday, and this month’s host is Mike Donnelly (blog|@SQLMD). If you...
2015-04-14
699 reads
Patching Master Data Services
I recently installed my first deployment of Master Data Services (MDS). I installed the SQL Server 2014 (Enterprise Edition) MDS...
2015-04-13
839 reads
Performance Counters: Why It Depends
When you’re working through some vague performance issues (e.g., “SQL Server seems slow today”), one of the common things to...
2014-08-18
1,252 reads
Speaking at SQL PASS Summit 2014
I am honored to be selected to deliver 2 sessions at the SQL PASS Summit 2014. I will be delivering...
2014-06-29
1,318 reads
Size Matters: 2 Products to Accelerate SQL Traffic
I talked previously about network pipelines and how to get the most out of a fat network in the post...
2014-05-07
1,184 reads
Why is Your SQL Server Slow? All-for-one and One-for-all
I have one more thing I want to talk about regarding the conversation I had recently with my friends and...
2014-02-14
1,113 reads
Why is Your SQL Server Slow? Here’s a Hint
I was talking recently with my friends and former colleagues at Idera about the things that slow down SQL Server....
2014-02-11
1,084 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 JOMBANG Telp:08218154398
WhatsApp:0821-8154-398 Jl. KH. Wahid Hasyim No.20, Jombang, Kec. Jombang, Kabupaten Jombang, Jawa Timur 61415...
Alamat kantor BCA KCU MADIUN Telp:08218154398
WhatsApp:0821-8154-398 9G9F+FFC, Jl. Jend. Sudirman No.79-81, Kejuron, Kec. Taman, Kota Madiun, Jawa Timur 63132...
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