Viewing 15 posts - 76 through 90 (of 1,494 total)
I'm getting frequent blockage.
What makes you think this?
Will using SET XACT_ABORT ON can help?
Nothing to do with locking.
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
Will not affect UPDATE locks...
December 12, 2024 at 8:26 am
You should know how to use date functions by now!
1. DATEADD(minute, -15, CURRENT_TIMESTAMP)
2. ROW_NUMBER() OVER (PARTITION BY DATEDIFF(minute, '2000', datevalue), floatvalue ORDER BY datevalue) AS rn
December 10, 2024 at 5:20 pm
I do not expect much of it to reach on-premises SQL Server anytime soon as it would not surprise me if Microsoft announced it was moving to five year...
November 24, 2024 at 7:23 pm
I suspect a lot of AI for analytics especially for security and BI on Azure.
I do not expect much of it to reach on-premises SQL Server anytime soon as it...
November 6, 2024 at 11:50 am
Typically, the query takes around 15 minutes to execute
Why?
What reseach have you done?
What methodology did you use?
October 23, 2024 at 10:36 am
October 22, 2024 at 9:29 pm
We have a Production/Live version with up-to-date data and a Test version with older data where we have added new columns to tables and created new tables.
All this should...
October 15, 2024 at 8:16 pm
Are you using Windows authentication to connect to the database?
If so you might have a Kerberos double hop problem.
If you do, try checking the SPNs with the Kerberos Configuration...
October 11, 2024 at 3:36 pm
You have over 1000 points so should know how to post a question by now.
How to post a T-SQL question on a public forum | spaghettidba
October 6, 2024 at 10:45 am
If you are still looking for an ODBC connection, and are prepared to pay, look into the following:
October 2, 2024 at 7:38 am
If you are using the AD for a service account why not use a MSA?
Using Managed Service Accounts with SQL Server (mssqltips.com)
October 1, 2024 at 7:04 am
I have never used SAP HANA but suspect you would be better with Polybase rather than a linked server.
September 26, 2024 at 8:08 am
Things to try:
1. Run Wireshark and speak to your network people.
2. If you have not already done so, buy a decent ODBC driver for DB2.
3. Look at using
September 25, 2024 at 6:49 pm
Viewing 15 posts - 76 through 90 (of 1,494 total)