Laden...
|
|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
Opening Multiple Symmetric Keys | |
Can I open multiple symmetric keys at once? As with this code: OPEN SYMMETRIC KEY PIIKey DECRYPTION BY PASSWORD = 'MyS3cr#tP@ssword' OPEN SYMMETRIC KEY PIINewKey DECRYPTION BY PASSWORD = 'MyS3cr#tP@ssword2' | |
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) |
The Upgraded Stored Procedure I had a SQL Server 2014 database. In it, I created this function: CREATE FUNCTION OPENJSON (@json varchar(1000)) RETURNS TABLE AS RETURN SELECT CASE WHEN SUBSTRING (@json, 1, 1) = '{' THEN 1 ELSE 0 END AS json_string;This works, and this call: SELECT * FROM OPENJSON('{ "key":1 }')Returns this result: json_string -------------- 1Now I restore this database on a SQL Server 2019 instance and set the compatibility level to 150. I run this code: SELECT * FROM OPENJSON('{ "key":1 }')What happens? Answer: I set a result with one row and three columns Explanation: When you change the compat level, the OPENJSON() built in function is activated. This code will return the results from that function, which is 1 row with three columns. Ref: ALTER DATABASE - https://learn.microsoft.com/en-us/sql/t-sql/statements/alter-database-transact-sql-compatibility-level?view=sql-server-ver16 OPENJSON - https://learn.microsoft.com/en-us/sql/t-sql/functions/openjson-transact-sql?view=sql-server-ver16#examples |
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 |
Rebuild index for system database - I do check database integrity for system db,is there need to do system rebuild index if yes what is fragmentation? |
shrinking a large data file - Hi All, One of our drive got filled (E: drive) and we decided to shrink the data file from 1.6TB to 500GB. While trying to shrink the file with didnt work. USE [dbname] GO DBCC SHRINKFILE (N'db_name_dat' , 0, TRUNCATEONLY) GO it completed successfully but it didnt release any space to OS. --then, tried below. […] |
unable to see job history for some jobs - Hi All, I am unable to see job history for some jobs. Usually, we run some maintenance jobs. for example) index maintenance and updating stats. Why it is not showing up? anything needs to be changed in SQL Agent Properties? Regards, Sam |
Administration - SQL Server 2014 |
HI need latest service pack or latest cu update in 2014 ,2012 sqlserver - HI need latest service pack or latest cu update in 2014 ,2012 sqlserver Microsoft SQL Server 2014 (SP3-CU4-GDR) (KB4583462) --Need link for latest service pack or CU upadate for this Microsoft SQL Server 2012 (SP4-OD) (KB4091266) -- Need link for latest service pack or CU update for this |
SQL Server 2019 - Administration |
RAM on the SQL Instance - Hi everybody, I have a 500 GB highly transactional database on the SQL 2019 Enterprise instance, running on a Windows Server 2019 box with two Intel Xeon 2.20 GHz processors. All the other databases on the instance are tiny and do not take resources. This is a SQL Server box; nothing else is running on […] |
Non-yielding Scheduler every 30 days - I have problem with SQL Server 2019. Of course I have new update 2019.150.4322.2 from August 2023 but problem stil exist. SQL Server 2019 Standard. OS Windows 11 PRO. Machine Dell 7910 2xXeon(R) CPU E5-2695 v4 @ 2.10GHz. Dozen cores. Database size about 1GB (about 20 users). Every month between 26th and 28th without any […] |
SQL Server 2019 - Development |
Conversion failed when converting the nvarchar value to data type int on insert - I have a table with an Int column.. this is being loaded with a JSON file...containing various values One of this is a numerical value which i have found a bug My code as follows: DROP TABLE IF EXISTS [#ReturnItemsCalibration_Points] CREATE TABLE [#ReturnItemsCalibration_Points]( [ReturnItemsCalibration_PointsID] [int] IDENTITY(1,1) NOT NULL, [ReturnItemsCalibration_ChannelsID] [int] NOT NULL, [Points] [int] NULL […] |
SQL Azure - Administration |
Azure SQL database: How additional storage (beyond 250GB) being charged? - Hi All, I have a question on how additional storage (beyond 250GB) will be charged for Azure SQL databases. Is it charged based on Max storage limit (MAXSIZE) or is it based on Allocated space? Thanks. |
Reporting Services |
Tables and Stored Procedure not showing up in while adding the dataset - Hi, I am using VS2022 Reporting Service Project. In that I am using Oracle Datasource. When I am trying to add a new dataset to the project , It is not showing tables and stored procedures in the dropdown. Let me know where is the problem. |
Tabs in SSRS Report - Hi, I have 2 tabs created in SSRS Report.There is calendar Day prompt in the report. By Selecting the Calendar Day Prompt the 2nd tab displayed in the report varies from 2nd Page and 3rd page. Is there any option to display the 2nd tab of the Report to display in 3rd page irrespective of […] |
SSRS 2019 Custom Authentication: error occurred when invoking the authorization - Hi, I am upgrading SSRS 2014 to 2019 and custom form based authentication is implemented with SSRS 2014. I followed the steps https://github.com/microsoft/Reporting-Services/tree/master/CustomSecuritySample and implemented same for SSRS 2019. While Web Service URL works fine but while accessing Web Portal URL I am getting below error and the web page displays. The service is not available. An […] |
SSRS 2016 |
Migrating SSRS power bi version 15 database to new server - Hello, I seen many articles, one such as this: https://www.mssqltips.com/sqlservertip/2692/migrating-sql-reporting-services-to-a-new-server-by-moving-the-reporting-services-databases/ and its pretty straight forward, backup database, restore, backup keys, restore, and point database to new location... got it... my biggest concern... and worry especially to the user, is the subscriptions... will the subscriptions come over to the new server.. I have about 100+ subscriptions, […] |
SQL Server 2022 - Administration |
issue with backup cleanup step - I have a maintenance plan for my nightly backups. It consists of three steps: Back up my databases to a folder on another server - in this case it's literally just a Windows server with a lot of drive space. Run DBCC check db against my databases. Cleanup - delete any backups older than five […] |
SQL Server 2022 - Development |
User does not have access to reports - Hello, I would like advice on how to allow users to open reports. So far, we have the home folder (which users cannot view), two sub folders, one of which users can view. This one contains three reports. They can see the reports exist but cannot open them. The users have permission to Browse and […] |
SQL2022 UPDATED FROM SQL2014 - PARALLELISM ISSUES - Hi We just updated from SQL2014 to SQL2022. Most everything went fairly well - except I have about 6 stored procs that move allot of data around that are suddenly not working. When looking at whoisactive they are generating CX waits. They stall all day with no results. They ran fine in SQL2014. I enabled […] |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Laden...
Laden...
© 2024