The 'Structured' part of SQL denotes the fact that queries can be nested inside each other in such a way that, wherever you can use a table, you can use a table expression. Such derived tables can provide powerful magic, to which is added CTEs and Lateral Tables.
SQL Server MVP Steve Jones will be hosting a free seminar in San Jose on Friday March 7 2014. Join fellow database professionals to learn best practices and practical tips for SQL Server version control, continuous integration and deployment.
We've made a change to the forums at SQLServerCentral. Learn how you can mark a post as an answer to your question and help others.
We've all been there, trying to improve performance in a panic situation and not making things better.
Not long ago, a crack team of SQL Server experts was flamed for a crime against database normalization they didn't commit. Today, Joe Deebeeay had a problem, no one else could help, so he found these exiled experts. Together Joe and the DBA-Team get to the bottom of high disk I/O.
In this piece, Josh follows up on his earlier article about smoothing DBA/Developer interactions, this time from the side of the developers.
Today we have a guest editorial from Andy Warren. He talks about strange questions in interviews and whether they help you assess the candidate.
There are several networking issues that can prevent the user from reaching or connecting to the SQL Server database. Learn how to test your SQL Server connectivity with PowerShell.
What are your options for sending a variable number of choices in a parameter to a stored procedure? Alex Grinberg looks at three techniques you can use.
Steve Jones likes the Cloud and gives a few reasons why. He also thinks we'll see more data in the cloud over time.
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
Comments posted to this topic are about the item SSRS Reminded Me of the...
I have a need to execute a stored procedure and return the results to...
Title pretty much says it all - can this be done? I've tried several...
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