|
|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
Azure SQL Database Purchasing Models | |
What purchasing models are available for Azure SQL Database (as of Jan 2022)? | |
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) |
Managed Instance Database Limits How many user databases are allowed in an Azure SQL Database Managed Instance (as of Jan 2022)? Answer: 100 Explanation: Managed Instance is limited to 100 databases, the sum of the sizes for these must be under the storage limit. Ref: Resource Limits - https://docs.microsoft.com/en-us/azure/azure-sql/managed-instance/resource-limits#service-tier-characteristics |
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 |
Storage Performance Very low - At first I thought SQL was under high utilization, but now I'm thinking perhaps the SAN is under high utilization from other VMs, causing our disk IO capacity to diminish. Am I interpreting correctly that the disk IO performance during this peak (in stats) is bad? Avg Disk sec/Read the average is .159 which is […] |
SQL Server 2016 - Administration |
Where condition for performance - Hi, This is part of the query which I want to change by Removing OR. What is the best way to write a condition like this for better performance? Should I use IN( Looks like OR and IN works same when it comes to execution plan. Please advise. Where test_ID =@Some_CustID OR abcd.oldsome_custID =@Some_CustID If […] |
TDE implementation on sql 2016 version - Hi, I'm implementing TDE for first time I researched below steps are what it takes. However, is there any detailed demo on this or what are prerequistes to keep in mind? Please let me know thanks Create a master key. Create or obtain a certificate protected by the master key. Create a database encryption key […] |
SQL Server 2016 - Development and T-SQL |
SSMA - SQL Server Migration Assistant - Not bringing over PK / FK from Oracle - Hi everyone, I wasn't sure where to post this topic, so I'm just going to post it here. I'm using SSMA to bring over Oracle tables and data to SQL server. But it doesn't look like the SSMA brought over the PK & FK. Does anyone know if there is an option in SSMA to […] |
Administration - SQL Server 2014 |
Supported SQL version with OS - Hi All, Continuation of this post https://www.sqlservercentral.com/forums/topic/upgrade-sql-and-os-of-legacy Would like to know, SQL 2000 supported OS versions? and for SQL 2005 as well. So that, I can build 2 test VMs so that we can move - SQL 2000 to 2005, 2005 to 2008R2 then finally to SQL 2014. |
Development - SQL Server 2014 |
SELECTing into temp tables - Hi all Does anyone know if it is possible that when doing a "SELECT ... INTO #temptable FROM ... " something might happen (such as a deadlock) resulting in the temp table being created, but empty when it otherwise wouldn't be? Thanks |
SQL Server 2019 - Administration |
Fixing SCOM 2019 discovery and unhealthy state errors - Hello experts, We are using SCOM 2019 along with SQL Server management packs. I'm trying to resolve error alerts like these: Information : SCOM Alert: : MSSQL on Windows: Discovery error Warning : SCOM Alert: : MSSQL on Windows: DB Engine is in unhealthy state I know that certain permissions are required in order for […] |
SQL Server 2019 - Development |
Stored procedure insert data with an id & return a list of all inserted ID's - I need to create a SQL server stored procedure to insert records with an ID column that is an identity. After the insert if complete, I need to return all the records that were inserted by ID only. I need ALL inserted records. This table has stored data. There is a datetime column, but it's […] |
Encryption SQL2019 Decryption -SQL2016 - Hi Everyone, I am trying to encrypt a data column on SQL 2019 and decrypt on SQL 2016. I am not sure if it is possible to do this between SQL 2019 and SQL 2016. The data is replicated over to the SQL 2016 server. I am running the below on the two different servers […] |
Stored Procedure Error - Hi I am creating stored procedure for the first time. I am getting error: Msg 207, Level 16, State 1, Procedure CHECK_IMPORT_HISTORY, Line 9 [Batch Start Line 0] Invalid column name 'NUM_RECORDS'. Completion time: 2022-01-28T21:42:14.6129465-08:00 I even changed the name to NUM_RECORDS_1 in the output parameter and no luck with the error. What is wrong […] |
Analysis Services |
Change SSAS multidimensional default language / locale (e.g. for error messages) - Dear SSAS Fellows We have an SSAS server on premise, that had been installed in German language. That is, by default it displays error messages in German (screenshot attached). The server's Windows Regional format is German (Switzerland) and Windows Home location is Switzerland. The language of Analysis Services instance is set to English (United States). […] |
Administering |
SQLServer Error: 4060, Cannot open database in Availability Group DB - SQL Server Strange behavior: I have been Getting the following error massages nonstop after full backup fails. this massage gets generated for each database in this Availability Group. The job runs every night, and it call SSIS package. Both the SSIS and Job seems okay and the tricky part is that job fails once in a while […] |
SQLServer Error: 4060, Cannot open database in Availability Group DB - SQL Server Strange behavior: I have been Getting the following error massages nonstop after full backup fails. this massage gets generated for each database in this Availability Group. The job runs every night, and it call SSIS package. Both the SSIS and Job seems okay and the tricky part is that job fails once in a while […] |
SQLServer Error: 4060, Cannot open database in Availability Group - SQL Server Strange behavior: I have been Getting the following error massages non stop after full backup fails. this massage gets generated for each databases in this Availability Group. The job runs every night, and it call SSIS package. Both the SSIS and Job seems okay and the tricky part is that job fails once […] |
SQLServer Error: 4060, Cannot open database in Availability Group - SQL Server Strange behavior: I have been Getting the following error massages non stop after full backup fails. this massage gets generated for each databases in this Availability Group. The job runs every night, and it call SSIS package. Both the SSIS and Job seems okay and the tricky part is that job fails once […] |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |