OT: Goodbye Dad
This is a bit of ramble.
At about 2:15AM November 21st, 2011 my dad, Arthur Corbett, went home to be with...
2011-11-21
851 reads
Blog Posts
See if Auto Create Statistics is enabled using PBM
We will walk through creating a policy to evaluate the status of “Auto Create Statistics” on our server named “File2”. ...
2011-11-21
1,393 reads
SQL Family – an Update
At the beginning of the month, we had a Meme Monday on the topic of SQL Family. I had a few things to say about the SQL community back...
2011-11-21
9 reads
SQL Family – an Update
At the beginning of the month, we had a Meme Monday on the topic of SQL Family. I had a...
2011-11-21
665 reads
SQL Server 2012 RC0 Is Here
SQL Server 2012 Release Candidate 0, Time To Get Serious
With the release of RC0 Microsoft has signaled that the release...
2011-11-21
1,531 reads
SSAS Processing Mode (Lazy Aggregations)
Processing mode property of a partition/measure group determines how partitions will be available to users.
Processing mode has two possible options.
Regular....
2011-11-21
3,274 reads
Table Space – CS Part Deux
Another script, another day. And as promised, I am providing an update to the Table Space script that followed the sp_MStableSpace script. Not a lot more to be said...
2011-11-21
9 reads
Table Space – CS Part Deux
Another script, another day. And as promised, I am providing an update to the Table Space script that followed the...
2011-11-21
659 reads
An Informal Compendium of SSAS Errors, Part 6: Common Errors
This is the last in a series of posts on some SQL Server Analysis Services (SSAS) errors for which there...
2011-11-20
1,297 reads
Content Shift, Still SQL, Just More SharePoint
Many of you may have notice that I have been a little inconsistent with my posts lately. It’s been a...
2011-11-20
645 reads
Blogs
KDA: Echoes of Deception - Case 6
By Zikato
A cryptic message, a book cipher hidden in art provenance records, and a trail...
Capturing My Own Metrics: #SQLNewBlogger
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
Forums
ALAMAT KANTOR BCA KCU KISARAN TLP/WA 08218200174
Telp Cso: (0821)8200174 Jl. Cokro Aminoto No.28, Kisaran Kota, Kec. Kota Kisaran Barat, Kabupaten...
ALAMAT BCA KCU PEMATANG SIANTAR TLP/WA 08218200174
Telp Cso: (0821)8200174 Jl. Merdeka No.39, Proklamasi, Kec. Siantar Bar., Kota Pematang Siantar, Sumatera...
ALAMAT KANTOR BCA KCU ASIA TLP/WA 08218200174
Telp Cso: (0821)8200174 Jl. Asia, Simpang, Jl. Bakaran Batu No.1 C, Sei Rengas 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