|
|
|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
Locating the PVS | |
In a new SQL Server 2022 database, I want to enable Accelerated Data Recovery (ADR) to speed up recovery time. If I run this, where is the Persistent Version Store (PVS) located? ALTER DATABASE VeryImportantDB SET ACCELERATED_DATABASE_RECOVERY = ON | |
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) |
Deterministic Encryption Operations In Always Encrypted, which of these operations are allowed with deterministic encryption? Answer: Equality (=), IN, GROUP BY, and DISTINCT only Explanation: You can use the equality, IN, GROUP BY, and DISTINCT operations with deterministic encryption. Ref: Always Encrypted Limitations - https://learn.microsoft.com/en-us/sql/relational-databases/security/encryption/always-encrypted-database-engine?view=sql-server-ver16#limitations |
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 2017 - Administration |
Missing perf-MSSQLSERVERsqlctr.ini - I attempted to install the latest CU (31) for my SQL 2017 server but received an error message stating "Service Pack Failure: MissingRegistryKeyException" due to a missing registry key. It appears that our SQL server is missing certain performance counters as I was only able to retrieve 57 row records after executing the command "select […] |
SQL Server 2017 - Development |
Transaction has no commit error - All, I have an unusual scenario. A developer sent me some code that has a BEGIN / COMMIT and a rollback right before the commit. It's all wrapped in a reasonable TRY...CATCH. The script builds some dynamic SQL INSERT statements using OPEN_QUERY, dynamic because the WHERE clause depends on some variables. The INSERT statements they […] |
SQL Server 2016 - Development and T-SQL |
How to remove special chars? - Hi everyone, So I have a xml file from which I am trying to import data into my sql tables. I noticed there are some special characters inside the file due to which I am unable to import data properly. Look at the below screenshot: Can anyone tell me what are there square boxes and […] |
Error trying to add columns to code - Hi there. Thanks for code from my previous post and so many good working options. Now I want to add 2 new columns and it gives an aggregation error. Appreciate any help. From this table, I have the code that selects the latest doctor visit record using the MAX function. If latest client record is […] |
SQL Server 2019 - Administration |
SSMS is filling up our C: drive -- installed on E: - Good day. I didn't know where else to post this, so forgive my ignorance if this isn't the place. I have a situation that involves a single Windows Server with SSMS installed that has the only permissions to hit another organization for our Data Warehousing team. There may be as many as 4 BIDS plus […] |
Trigger on update when changed only desired XML tag. - Hello! I have a task to configure for the Skype for business database logging of user status changes (Available/Away/Offline/etc). i found source for this data in XML field with content like: 15500 |
To get a list of un-used columns in all tables in a database - I am looking to get a list of un-used columns in all tables in a database. I would like the output to look like something like this. DatabaseName, SchemaName, TableName, ColumnName, etc If anyone has a handy script or any link, please share. Thanks. |
DBNETLIB] [ConnectionOpen (SECDoClientHandshake()).] SSL Security Error - Hi New server with SQL version 2019 has been created to host a DB for a Legacy App to use. This is working fine. The App has not changed. I need to get this working on a test Server. Test Server with 3 instances on it 1. Version 2014, Development edition uses port 1433 2. […] |
Hash Match performance issue - Hi I have a stored proc that is performing badly. When I look at the execution plan I can see a couple of instances where there are a large number of rows inputted into a hash match but the output is estimated to be only 1 row. The inputs into the hash match below are […] |
SQL Server 2019 - Development |
SQL Query to display having only values - I am having below -mentioned table1 and I would like to display it as shown in the below table Can someone help me with the query Thanks in advance |
SELECT with computed values - From a huge and ever growing table (tbl_Values) I need to select all records which conform to rules defined in another table (tbl_Rules). Each record in tbl_Values has a time_stamp (datetime) and a fvalue (float); the rules defined in tbl_Rules have a WeekDay (int), a HourOfDay (int), a MinValue (float), a MaxValue (float). Records from […] |
Relational Theory |
RIGHT-JOIN table not fetching all rows in WHERE clause - I'm trying to add an additional table (hrxoreturn) with RIGHT JOIN to return all records either with matching or no matched records to other tables. When i exclude "count(distinct hrxoissue.issuedte)as 'Total Count per RX'" , the fetched rows goes to 49 rows reading all the count in hrxoreturn table, but if i include count on […] |
SQL Server 2022 - Development |
Case and When Query - Hi All, I want to rewrite the below query using the Case and When statement Query 1 update [SF_Title_Update] set [Title_Proper]='Human Resource Management System Manager' from [SF_Title_Update] where ( title like '%Human%' and title like '%Resource%' and title like '%Management%' or title like '%HRMS%' ) and (job_level='Manager Level' ) and( [Title_Proper]=' ' or [Title_Proper] is […] |
Dynamic Query - Hi All, I have to generate a dynamic query for the below mentioned keywords to update them in Title_Update column Keywords Recruitment Employee Engagement Performance Management Training and Development Compensation and Benefits Human Resource Diversity and Inclusion Also it should have the below mentioned Job Level Chief Level Director Level Head Level Manager Level Managing […] |
Use a flag, or calculate, to retrieve counts - I'm working on a Holiday Leave system (for typically several hundred or more personnel). Currently, a person may request leave (in the future) and each Leave request can have one of a number of Status values: Pending Approval Approved Declined Cancelled There is a report required to sum up these totals for an individual, broken […] |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |