|
|
|
|
|
|
|
| Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
No More Deadlocks | |
| After detecting deadlocks in SQL Server 2025 and lowering the time threshold for detecting future issues, when does the Database Engine return to the 5s default interval? | |
Think you know the answer? Click here, and find out if you are right. | |
| Yesterday's Question of the Day (by Steve Jones - SSC Editor) |
QUOTENAME Behavior I use QUOTENAME() like this in code? DECLARE @s VARCHAR(20) = 'Steve Jones' SELECT QUOTENAME(@s, '>') What is returned? Answer: Explanation: This returns , the same as this code: DECLARE @s VARCHAR(20) = 'Steve Jones' SELECT QUOTENAME(@s, '<') Ref: QUOTENAME() - https://learn.microsoft.com/en-us/sql/t-sql/functions/quotename-transact-sql?view=sql-server-ver17 |
| Database Pros Who Need Your Help |
Here's a few of the new posts today on the forums. To see more, visit the forums. |
| SQL Server 2016 - Administration |
| SQL Server Showing Out of Space But Plenty of Drive Space - We have a SQL Server installed. We have a 500GB drive for the database. Currently, we have 95 GB free on this drive. When I go into the database, and look at the Shrink File toolset, it shows the database at 410000 MB and the Available Free Space at 4500 MB, but the drive itself […] |
| Data Transformation Services (DTS) |
| Before Using AI with Business Data, Read This - Artificial intelligence tools are quickly becoming part of daily business operations, from document analysis and reporting to workflow automation and customer support. While these systems can improve productivity, many organizations are adopting AI faster than they are addressing potential privacy and security risks. One of the biggest concerns is how sensitive business information is handled […] |
| Editorials |
| What Can AI Really Do? - Comments posted to this topic are about the item What Can AI Really Do? |
| We Are Eating Our Own Seed Corn - Comments posted to this topic are about the item We Are Eating Our Own Seed Corn |
| The New Wave of Security Threats - Comments posted to this topic are about the item The New Wave of Security Threats |
| There's Too Much to Learn - Comments posted to this topic are about the item There's Too Much to Learn |
| Article Discussions by Author |
| Why Your Index Isn't Being Used? - Reading Execution Plans to Find the Real Culprit - Comments posted to this topic are about the item Why Your Index Isn't Being Used? - Reading Execution Plans to Find the Real Culprit |
| Distance Metric Algorithms - Comments posted to this topic are about the item Distance Metric Algorithms |
| Designing SQL Server ETL Pipelines That Don't Break at Scale - Comments posted to this topic are about the item Designing SQL Server ETL Pipelines That Don't Break at Scale |
| Detecting Deadlocks Quickly - Comments posted to this topic are about the item Detecting Deadlocks Quickly |
| Creating a JSON Document IV - Comments posted to this topic are about the item Creating a JSON Document IV |
| Restoring Azure Key Vault Keys and Validating SQL Server TDE Recovery: Level 7 of the Stairway to TDE - Comments posted to this topic are about the item Restoring Azure Key Vault Keys and Validating SQL Server TDE Recovery: Level 7 of the Stairway to TDE |
| SSRS Is Dead. Here Are Your Real Options - Comments posted to this topic are about the item SSRS Is Dead. Here Are Your Real Options |
| The Distance Metric - Comments posted to this topic are about the item The Distance Metric |
| SQL Server 2022 - Development |
| Permissions Removal When Changing Object Schema - When the schema of an object is changed, SQL Server wipes out the previous set of permission grants. Usually this applies when the permissions are granular. Such as "GRANT SELECT ON abc.MyTable TO Mylogin." And usually, I only care when I have to drop the schema-owning user from the database for whatever reason. What I […] |
| |
| ©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |