Pre-Compiled Stored Procedures: Fact or Myth
There’s a very common belief among DBA’s: Stored procedures are pre-compiled. I had someone tell me all about it just...
2009-09-30
1,912 reads
Minor Celebration
A little cheap thrill for me. I passed 50,000 views on the blog yesterday. Thanks to everyone who has stopped...
2009-09-30
1,389 reads
The old INNER JOIN syntax vs. the new INNER JOIN syntax
I was in a presentation last week where the presenter was talking about the ANSI/ISO SQL standards. For the most part the...
2009-09-30
47,110 reads
Heading Down to the Basement
I'm taking the next two days off, heading down into the basement for a four day weekend. Nothing particular going...
2009-09-30
1,476 reads
Idea for PASS Summit 2010 – Share Your Other Passions
I’ve had the glimmer of this idea since I posted about the idea of bringing my chair to the 2009...
2009-09-30
1,389 reads
TechEd Online Interview
Back in August at TechEd Africa I did a TechEd Online interview with Frikkie Bosch. Frikkie’s the marketing manager for...
2009-09-30
1,473 reads
On vs. Where
Does it matter if you put your criteria in the ON clause or the WHERE clause? Well, as with most...
2009-09-30
1,773 reads
Eliminating Empty Output Files in SSIS
So you’ve got some packages that regularly extract data to one or more text files, but you know that from...
2009-09-30
13,980 reads
Jack Corbett Now Co-President of oPASS
I’m late announcing this here, but I’m pleased to announce my friend Jack Corbett is joining me in leading oPASS...
2009-09-29
1,613 reads
More on the MVP SQL Server book
If you buy from Manning directly today or tomorrow, there’s a 50% discount . Use the code pop0928 at the checkout....
2009-09-29
1,367 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 BANK BCA KCU PEMATANG SIANTAR TLP/WA 08218200233
Telp Cs: 08218200233 Jl. Merdeka No.39, Proklamasi, Kec. Siantar Bar., Kota Pematang Siantar, Sumatera...
ALAMAT KANTOR BCA KCU ASIA TLP/WA 08218200233
Telp Cs: 08218200233 Jl. Asia, Simpang, Jl. Bakaran Batu No.1 C, Sei Rengas II,...
ALAMAT KANTOR BCA KCU WISMA ASIA TLP/WA 08218200233
Telp Cs: 08218200233 Wisma Asia, Jl. Letjen S. Parman No.Kav. 79, RT.4/RW.9, Kota Bambu...
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