Once, when disk space was at a premium, DBAs fought hard to keep the size of their database down. Now there seems less motivation to 'fight the flab' of a database. Fabiano Amorim was watching television recently when the subject matter, cosmetic surgery, gave him the theme and inspiration for this guide to keeping your database fit and trim.
I was recently asked a question on restoring a database using PowerShell with the following requirements
Take a database backup file...
SQL Connections, part of Dev Connections, is coming in a few weeks. Now is the time to register and get the chance to learn in a sunny location.
How can I change the collation of SQL Server 2008? Learn how in this short tutorial.
Once again SQLServerCentral is sponsoring a track at SQL Connections in Orlando this March. Read about the event and our speakers and join us for SQL Server training in Florida.
We have been doing some more work with SQL Azure lately, so I have put together a small collection of...
We experience regular slowdowns on our MS SQL database. After analyzing the memory usage we would like to continue the root cause investigation by examining CPU bottlenecks. What is your recommendation to recognize CPU related bottlenecks in SQL Server?
There are times when you need to use different network ports to communicate between two servers running database mirroring. Learn how to change the default ports.
NoSQL solves some problems in the database world, but not all of them. It's also not an evolution of the relational database, but as Steve Jones notes, it has some features we might see in SQL Server.
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...
Comments posted to this topic are about the item BIT_COUNT II
Comments posted to this topic are about the item I Can't Make You Learn
Comments posted to this topic are about the item Why Your SQL Permissions Disappeared
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