Laden...
|
|
|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
CONCAT NULLs | |
What is the result of this code? DECLARE @name VARCHAR(10) = 'Steve'; DECLARE @title VARCHAR(10); SELECT CONCAT (@name, 'Jones', ', ', @title); The answers use brackets to delimit the results. Ignore them. | |
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) |
Trigger Order II I have a table in my SQL Server 2022 database with two triggers, triggertest_tri_1 and triggertest_tri_2. I run this code to first set an order for my triggers. EXEC sp_settriggerorder @triggername = 'triggertest_tri_2', @order = 'first' , @stmttype = 'INSERT' GOHowever, I realize I've made a mistake, so I run this: EXEC sp_settriggerorder @triggername = 'triggertest_tri_1', @order = 'first' , @stmttype = 'INSERT' GOAnswer: An error is returned Explanation: An error is returned here. You can only have one trigger set to First, so trigger 2 must be set to None. Ref: sp_settriggerorder - https://learn.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-settriggerorder-transact-sql?view=sql-server-ver16 |
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 |
Does a Query Lock to the Table_Name or Table_ID - SQL 2017 ENT SCENARIO: Table_1 has a Sch-M lock on during an intended updating process. A QUERY is executed against Table_1 and is queued up, waiting for the Sch-M lock to release. While the QUERY is queued up on Table_1, Table_1 is renamed to Table_1_OLD A newly designed Table_2 is then renamed to Table_1 QUESTION: […] |
SQL Server 2017 - Development |
update field on a select query - I have a sql query that runs on demand to generate a report. I want to update a field REPORTSENT to a Y on the selected results. So the next time the report is requested only the Records with a REPORTSENT = N will be returned. Normally would run the query for the records and […] |
SQL Server 2019 - Administration |
Cluster Timeout Settings to handle transient network outages - I have an Availability group with 2 replicas on the same subnet. We've been experiencing short network outages that last a few seconds and cause connections to timeout. This causes the AG to fail completely (not failover automatically) and we have to manually bring it back online since the DBs are marked "not synchronizing" on […] |
Question about SQL Certs and DNS aliases - About 15 years ago we started creating DNS aliases for each database. This allowed us to move databases without needing to change client connections. We now use these aliases in all applications, reporting, ETLs, etc... When we upgrade SQL we create new servers and migrate the databases, using the aliases made this simple. We also […] |
SQL Server 2019 - Development |
ssis dashboard suddenly missing from reports option under catalog/ssisdb - hi i rt clicked ssisdb today under integration services catalog , chose reports and didnt see the dashboard option under my regular id. my id has sa. so i connected with my admin which also has sa and did see it. losing permissions would have occurred in the last 24 hrs. i saw in one […] |
SQL Azure - Development |
Hybrid Cloud Server Integration with SQLServerCentral’s SQL Server 2022 - Hello everyone, I’m currently exploring the use of hybrid cloud servers and am focusing on integrating them with SQLServerCentral’s SQL Server 2022. While hybrid cloud environments offer flexibility, managing and optimizing them with SQL Server 2022 presents several challenges. Here are some specific areas where I’m seeking advice: Integration Best Practices: What are the best […] |
SQL Azure - Administration |
SQL Server 2022 on Azure VM - I was provisioned this DB on an Azure VM. I needed to uninstall and reinstall it in order to set the proper collation. I dont know how it was originally setup or if it goes by another namelike "Managed SQL Instance" as another department handles setting these up. When they learned of my uninstall/reinstall they […] |
General |
Performance of Derived table in large data(12 crores and more) - Using Derived Table in query on large data (12 crores and more) results in CPU utilization greater than 90% resulting in performance degradation. Why Using Derived Table in query utilizes high CPU when it is created in memory |
Powershell |
dump to csv -- image column - If there is an Image Column in mssql table and I wanted to use export-csv to dump this info to file how do you handle that column to be able to import that csv to another DB. Thanks. |
SQLServerCentral.com Website Issues |
Future Post - This post is from the future! How did that happen? https://www.sqlservercentral.com/forums/topic/git-configuration-and-automated-release-for-azure-data-factory#post-4451220 |
SQL Server 2022 - Administration |
How to connect to Developer Server Edition - Hi, I am attempting to connect to a local instance of sql developer installed today. When attempting to connect to the Server Name: EHL5CD4254Q4G with Windows Authentication ( its a domain joined laptop btw), I get an error: TITLE: Connect to Server ------------------------------ Cannot connect to EHL5CD4254Q4G. ------------------------------ ADDITIONAL INFORMATION: Login failed for user 'mydomain\myaccount'. […] |
Alias woes on SQL Server 2022 - Our company is moving to the cloud. I have SQL Developer Edition 2022 on Windows Server 2022 Datacenter setting up our QA SharePoint Farm.. I've created a named instance running over port 55055 using TCP/IP. THis is what I have in my on premises SQL server that we set up about 10 years ago. The […] |
SQL Server 2022 - Development |
Text column is taking More time while Querying, Need to Replace DATALENGTH - select * from dbo.resolutions r where R.documentid = 828222222 and DATALENGTH(r.resolution_text) > 0 resolution_text Text column is taking More time while Querying, Need to Replace DATALENGTH, when i replace datalength condition as "r.resolution_text is not null" the above query is returning data |
SSIS package project connections don't work on upgrade - We're upgrading from SQL Server 2016 to 2022. The SSIS package project level connections don't work as expected. One queries the server as an anonymous logon instead of the domain account associated with the SQL Server Agent. One even affects both the original server and the new one to which it is pointed. I have […] |
2022 azure vm cant run same ssis pkg we run on prem - Hi, we set up an environment on our new azure 2022 vm with a cloned "prod target warehouse", ssis project clone from prod, cloned sql agent etc etc. amongst other things the ssis points at a new erp's sales data we are testing with in just one agent step/ssis project execution for that 2019 std […] |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. [email protected] |
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Laden...
Laden...