2016-01-08
1,704 reads
Indexing
2015-12-16
1,549 reads
2015-11-09
1,625 reads
Strange Filtered Index Problem
What I thought was a strange filtered index problem but turned out to be a DB settings problem
2018-05-11 (first published: 2015-08-26)
5,286 reads
2015-10-08 (first published: 2015-07-02)
1,107 reads
The Importance of Database Indexing
In this article, James Munro demonstrates an example of a simple query without an index and then that same query again with the index. A simple introduction to database indexing.
2015-06-04
7,210 reads
2015-03-16
1,734 reads
2015-03-11
1,814 reads
The Real World: Rebuilding Index - 1 Instance, 106 Databases
The article show a simple way we managed to schedule index rebuild and reorg for an SQL instance with 106 databases used by one application using a Scheduled job.
2015-02-17
6,495 reads
Grant Fritchey Reviews Minion Reindex
Grant Fritchey reviews Midnight DBA's Minion Reindex, a highly customizable set of scripts that take on the task of rebuilding and reorganizing your indexes.
2015-01-27
2,605 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
Alamat Kantor BCA KCU HARAPAN INDAH Telp:082144477715
WA:0821-4447-7715 Jl. Sentra Niaga Jl. Harapan Indah Boulevard Kav. CP2 No. 1, RT.10/RW.8, Pusaka...
Alamat Kantor BCA KCU CIREBON Telp:08218154398
WhatsApp:0821-8154-398 Jl. Yos Sudarso No.27, Lemahwungkuk, Kec. Lemahwungkuk, Kota Cirebon, Jawa Barat 45111
Alamat Kantor BCA KCP Kalimalang Telp:08218154398
WhatsApp:0821-8154-398 Jl. Inspeksi Kav. PTB Blok A 2 No. 2 C-D, RT.1/RW.4, Pd. Klp.,...
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