Viewing 15 posts - 1 through 15 (of 159 total)
if don't use linked server, how can I achieve my request ? could you kindly give me some suggestion? thanks!
One way to handle removing linked servers is...
August 6, 2025 at 12:49 am
The biggest issue is where does the processing occur. If you're running a query, with a WHERE clause, across a linked server, most of the time, ALL data will...
August 5, 2025 at 3:06 pm
You have discovered why most of us dislike linked servers !
How did you declare and configure the linked server? e.g. did you enable "collation compatible"?
Keep in mind data transfer...
August 5, 2025 at 3:03 pm
so as Johan mentioned, linked servers leverage tempdb. so if you are adding a WHERE or an ORDER BY, or joining it to your local data, the whole table...
August 5, 2025 at 2:54 pm
sorry , as sql type file is not allowed, adding its txt file
November 8, 2023 at 3:52 am
Thank you Erland Sommarskog. I have done some testing based on different cases ,thank you!
June 14, 2023 at 7:31 am
Thank you for your patience and help! but I still have some confusion regarding the unique index of idx1. sorry to bother you again, thanks!
if using index hints to use...
June 13, 2023 at 3:23 am
Or you need to include that information in the calls to SQL Server - as in a parameter to a stored procedure (e.g. User, UserID, etc.)
yes , this is ...
May 19, 2023 at 1:29 am
No you cannot get the true end users computer from profiler (or extended events for that matter) as that is not the computer connecting to SQL.
If you want to...
May 19, 2023 at 1:16 am
Thanks Jeff Moden for you kind help!
but it is a web system, there are many user accessing this system thru Google browser at the same time, and Google browser access...
May 18, 2023 at 9:06 am
Dear Johan Bijnens, I want to use a user-defined function to update some data in physical table if possible, when I searched and got a post, it was said that...
October 25, 2022 at 12:58 am
Have a look at https://www.sommarskog.se/query-plan-mysteries.html#dmvgettingplans where I have a query for this.
thank you for your kind help! I'll study it
and I also find that it can't parameter value...
April 7, 2022 at 10:27 am
error is very clear - that user (bit\pqScott) does not have permissions to create the table on database RRDB01 - fix the permissions as required.
actually, the user ( bit\pqscott)...
December 18, 2021 at 4:14 pm
thanks Mr. Brian Gale and Jeffrey Williams!
I tried to use proxy account, the setting as the pictures, when I created a job and executed it, the error message as below:
Executed...
December 18, 2021 at 7:43 am
Grant Fritchey and Jeff Moden, Thank you for your kind help ! much appreciated!
December 16, 2021 at 1:01 am
Viewing 15 posts - 1 through 15 (of 159 total)