Which version of SSIS-DTS Package Search is right for you
The download page for SSIS-DTS Package search presents three choices:
SSIS-DTS Package Search for SQL Server 2000 on Windows x86SSIS-DTS Package...
2009-08-12
1,465 reads
The download page for SSIS-DTS Package search presents three choices:
SSIS-DTS Package Search for SQL Server 2000 on Windows x86SSIS-DTS Package...
2009-08-12
1,465 reads
Although I tend to write a lot of formal scripts, as part of the development process I'll explore an object...
2009-08-12
564 reads
I thought I had captured statement start times within the DMV sys.dm_exec_sessions. I was absolutely wrong. However, this has sparked...
2009-08-11
956 reads
but I don't mean with respect to privacy. But I do mean with respect to the time it takes securing...
2009-08-11
710 reads
I took the final, non-BI Microsoft SQL Server 2008 Certification Exam on Friday, so now I have finished all of...
2009-08-11
544 reads
You may think that the task of teasing out the exact nature
of the data and processes within a company...
2009-08-11
2,494 reads
A very common need in SSIS is to check to see if a file exist before you run what could be...
2009-08-11
15,180 reads
Last week I posted about getting a new bluetooth speakerphone, so I thought I’d follow up with some notes about...
2009-08-11
520 reads
Is employee data theft on the rise? I saw this blog post on the subject, but I had to take...
2009-08-11
792 reads
I was working on a table partition management task yesterday. The table is partitioned on a datetime column, and each...
2009-08-10
8,943 reads
By Zikato
A cryptic message, a book cipher hidden in art provenance records, and a trail...
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
WA:08218154393 Jl. Surabaya No.88 B-C, Ps. Baru, Kec. Medan Kota, Kota Medan, Sumatera Utara...
WA:08218154393 Jl. Perak Bar. No.267, Perak Utara, Kec. Pabean Cantian, Surabaya, Jawa Timur 60165
Comments posted to this topic are about the item 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