2015-05-02
7 reads
New Bug: Change Data Capture (CDC) Fails after ALTER COLUMN
[read this post on Mr. Fox SQL blog] EDIT #1: Fri 19 Jun 2015 We received confirmation the Microsoft Support Team the bug can be reproduced – however at this point in...
2015-05-02
11 reads
New Bug: Change Data Capture (CDC) Fails after ALTER COLUMN
[read this post on Mr. Fox SQL blog] EDIT #1: Fri 19 Jun 2015 We received confirmation the Microsoft Support Team the bug can be reproduced – however at this point in...
2015-05-02
12 reads
New Bug: Change Data Capture (CDC) Fails after ALTER COLUMN
[read this post on Mr. Fox SQL blog] EDIT #1: Fri 19 Jun 2015 We received confirmation the Microsoft Support Team the bug can be reproduced – however at this point in...
2015-05-02
72 reads
2015-03-03
4 reads
NUMA remote (foreign) memory access overhead on Windows, SQL Server and In-Memory OLTP
In NUMA (Non-Uniform Memory Access), processors in the same physical location are grouped in a node which has its own local node memory. In a NUMA based system, there...
2014-12-04
38 reads
Slow performance due to SQL Server 2014 Buffer Pool Extension (BPE) and serial queries (MAXDOP 1)
The SQL Server 2014 Buffer Pool Extension feature can extend the buffer pool space on to Solid State Drive (SSD), where data and index pages can be cached. There...
2014-12-04
23 reads
2014-10-31
8 reads
2014-10-20
11 reads
2014-09-26
10 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