Viewing 15 posts - 1 through 15 (of 1,417 total)
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
SELECT servicename, service_account
FROM sys.dm_server_services;
September 25, 2024 at 3:39 pm
I want to know if Write operation also have same Pros and Cons in terms of CPU , time Etc.
What results did your research produce?
September 24, 2024 at 8:44 pm
To resolve deadlocks you should really start by looking at the deadlock graphs; I am unsure why you think a tablock is a good idea. There are plenty of resources....
September 11, 2024 at 7:59 am
As this is a SQL2022 thread, you could also look at using Polybase and an external table.
As mentioned by @Mr Brian Gale, cross server queries in SQL Server, for...
September 10, 2024 at 8:57 pm
Viewing 15 posts - 1 through 15 (of 1,417 total)