NOLOCK – truth
With the NOLOCK hint (or setting the isolation level of the session to READ UNCOMMITTED) you tell SQL Server that...
2010-11-30
1,506 reads
With the NOLOCK hint (or setting the isolation level of the session to READ UNCOMMITTED) you tell SQL Server that...
2010-11-30
1,506 reads
New Version Sql Server “11? code name “Denali” CPT1 is ready to download here: http://msdn.microsoft.com/en-us/sqlserver/default.aspx Here are experts comment and...
2010-11-10
922 reads
Everyone know how to uninstall sql server very easy : control panel -<Add remove programs ->sql server some times you can...
2010-11-02
553 reads
There are different ways you can communicate to sql server: 1. Shared memory: on the local server 2. Named Pipe:...
2010-10-21
551 reads
Schedule the backup job in Express Edition: Everyone knows that, you cannot schedule a job in Express edition, as Express...
2010-09-08
463 reads
for Sql server 2005, It was a bug when you modify maintainance plan you may get the error “no description...
2010-08-31
2,769 reads
When you configure the memory and on your system if other applications are also present, in such cases specially for...
2010-08-16
470 reads
It’s been quite some time that I blog, Sorry about that I was busy with my movement from USA to...
2010-08-07
858 reads
Important: System Objects/Views/DMV/DMF This is the some of the list of System Objects/Views/DMV/DMF. Catalog View: All system information is stored...
2010-06-17
1,010 reads
Today while being on forum found this information so though to blog for future reference. thanx Uri Dimant for sharing...
2010-06-03
466 reads
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Many years ago, before I joined Oracle, I was working on a major modernisation...
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
WhatsApp: 0817839777 Jl. Jend. Ahmad Yani No.91, Magersari, Panjunan, Kec. Kota Kudus, Kabupaten Kudus,...
WhatsApp: 0817839777 Jl. Pemuda No.90-92, Kembangsari, Kec. Semarang Tengah, Kota Semarang, Jawa Tengah 50133
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37What is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 3;See possible answers