|
|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
Data API Builder APIs | |
What formats of API endpoints can the Data API Builder present to clients when exposing the database? | |
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) |
Quiesce What does it mean to quiesce a system? Answer: This refers to pausing or altering the systems to achieve a consistent state. Explanation: This refers to This refers to pausing or altering the systems to achieve a consistent state. Often in a database system where we need exclusive access we may choose to let current connections complete, but preventing new ones to quiet the system in preparation for maintenance. However, the VSS actions on a SQL Server database server will quiesce the system. Ref: |
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 |
Events of System_health extended event serious or not - I have listed the event names present in my system_health extended event report. Based on these groupings, can I decide whether a group needs to be checked or not? Which ones are serious and must be checked, and which ones can be ignored? Specifically, I want to know how to determine if the following event […] |
SQL Server 2017 - Development |
Database Archive missing FK - Bonjour à tous, je vais bientôt démarrer un projet d'archivage de données pour alléger la base de production. Dans la configuration spécifique de la base d'archivage, il a été décidé qu'elle ne contiendrait pas de clés étrangères (FK), ce qui fragilise davantage la base. En effet, un TRUNCATE TABLE pourrait être effectué sur toutes les […] |
Testing whether TRY_CONVERT is losing precision - Hello All, I am using TRY_CONVERT to parse character data into a decimal column. I want to generate alerts when the value is not null and TRY_CONVERT returns a null. That works. SELECT '5254.15',TRY_CONVERT(DECIMAL(5,2),'5254.15') But I am running into situations where TRY_CONVERT truncates precision. In the cases I want to be alerted. SELECT '6.125',TRY_CONVERT(DECIMAL(5,2),'6.125') Any […] |
Timeout Error while executing a TSQL statement in Sql server Express Edition - I am getting the below error when I execute a SQL command in SQL Server 2017 Express Edition Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding The same query works fine in SQL Server Standard Edition. What might be the reason for this issue? […] |
Timeout Error while executing a TSQL statement in Sql server Express Edition - I am getting the below error when I execute a SQL command in SQL Server 2017 Express Edition Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding The same query works fine in SQL Server Standard Edition. What might be the reason for this issue? […] |
SQL 2012 - General |
sqlbackups through veeam not updating msdb tables - We have veeam backups happening everyday on a server where all sql databases are also getting backed up but the same is not reflecting in the msdb.dbo.backupset table. Why is it so ? Where do I start troubleshooting ? |
SQL Server 2019 - Administration |
Vendor claims unused table space impacts performance - Hello experts, I got a report from an application owner of degraded performance for an application. To paraphrase: The unused table space is quite large when compared to the actual data space used. Per the vendor, this would impact performance. Has anyone ever heard of unused table space causing performance issues? I haven't. In addition, […] |
SQL Server 2019 - Development |
dont want pkg to abort if someone is in excel source document - Hi, is there a way when using excel as a flat file source in ssis to forgive the fact that someone has it open? in my mind analogous to a dirty read in sql? maybe read what it had at last save? i'd hate to have an error handler alerting the file owner for hours […] |
need help with assigning a value to a variable - Hi I am trying to assign the value of the variable using the output of a query but I am getting an error. How do I fix it? Query: DECLARE @LATEST_DATE DATE; SET @LATEST_DATE = SELECT MAX(MY_DATE) FROM DBO.TABLE Error: Msg 156, Level 15, State 1, Line 8 Incorrect syntax near the keyword 'SELECT'. Thank […] |
String Variable and sp_executesql - I am not understanding why this command completes "successfully" and it seems correct to me. However, the focus of the session does not switch to the database specified in the USE clause. Is there something I am missing? I am trying to make my script able to run on any database it finds, and change […] |
adding dtc to my pkg - Hi below i show the control flow of my pkg. I'd like to enlist any component that updates into dtc. I havent used dtc in a long time. i tried reading what's posted at the links you see below but id really like to get to the finish line faster. my understanding is that all […] |
Powershell |
printing complete path - get-ChildItem C:\ -recurse -erroraction silentlycontinue | sort length -descending | select -first 10 FullName,length Result: C:\Program Files\Microsoft SQL Server\120\Setup Bootstra... 88821760 FullName is not getting printed.How can I fix this ? Thanks |
Working with Oracle |
SQL Server 2005 service fails to start - Hello, I’ve been trying to install Ms SQL Server 2005 for over two weeks now, and I’ve finally gotten to the point where the prerequisites all seem to be in place. Unfortunately, every time I try to install SQL Server itself, I get the following message: “The SQL Server service failed to start. For more […] |
SQL Server 2022 - Development |
Automating Export of PowerQuery to SQL Server using DAX Studio...? - I wrote a PowerQuery that parses a table from a PDF, and I want to export it to SQL Server. I tried using the PowerQuery source in SSIS, and it wouldn't let me map the columns. (Maybe I did it wrong???) I got DAX Studio to export the result of the PowerQuery to SQL Server, […] |
Sql script replace and rearrange numbers - Hi everyone. I have this table and this information. (left side of the image) I need to replace Black with White and rearrange the numbers of the priorities. After the replacement, the numbers should be rearranged. (right side of the image) CREATE TABLE [dbo].[Priorities]( [Airplane] [nvarchar](50) NULL, [Priority] [int] NULL, [Color] [nvarchar](50) NULL ) ON […] |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |