What’s your build number?
Without looking, name your most important server. Or if you have a bunch, name the top 2 or 3.
Now tell...
2011-12-04
931 reads
Blog Posts
Getting data and log size of all databases
Hi guys.
The procedure bellow get the data and log size of all databases in current instance.
CREATE PROCEDURE dbo.uspDatabaseSize
AS
declare...
2011-12-03
1,925 reads
Installing SQL Server 2012 Release Candidate 0
In my last post, I indicated that my plan was to post by Dec. 3 on the topic of data...
2011-12-03
2,203 reads
“Beyond Rounded Corners” at the Microsoft BI User Group of Minnesota-Dec 6, 2011
Come join me and other Business Intelligence professionals at the Microsoft BI User Group meeting at Microsoft’s new offices in...
2011-12-02
460 reads
Autogrow guidelines
I always enable autogrow on my databases. However, it’s there for emergencies, not as a space management tool. I monitor...
2011-12-02
5,821 reads
DBA in Space: Behind the Scenes—Question 10
This is a continuation of my DBA in Space journal.
Alien Brad is not looking very well (more boils), or very...
2011-12-02
861 reads
MythBusting–“Table variables have no statistics”
Ok, as myths go, its a pretty weak one. In fact, it is true, this whitepaper explicitly states that. But...
2011-12-02
3,075 reads
Now to End of Year
My friend Steve Jones posted Shutting Down for a Week and in that he talked about doing too much, trying...
2011-12-02
757 reads
Re-blog – November 25 – December 1
Welcome to the Friday Re-Blog summary post. The aim of these posts is to bring some old posts that newer...
2011-12-02
504 reads
SQL Server 2008 R2 Installation Step by Step Guide - Saving System Admins, DBAs, Developers and Support Technicians A Wee Bit O' Misery
I've uploaded to SkyDrive a complete step by step guide for a SQL Server 2008 R2 installation because I prefer...
2011-12-02
34,467 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 Kontak Bank BCA KCP Surabaya WA {08218154393}
WA:08218154393 Jl. Surabaya No.88 B-C, Ps. Baru, Kec. Medan Kota, Kota Medan, Sumatera Utara...
Alamat Kontak Bank BCA KCP Perak WA {08218154393}
WA:08218154393 Jl. Perak Bar. No.267, Perak Utara, Kec. Pabean Cantian, Surabaya, Jawa Timur 60165
BIT_COUNT II
Comments posted to this topic are about the item BIT_COUNT 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