Viewing 15 posts - 1 through 15 (of 148 total)
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:
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
Also, don't set the max of SQL Server to max of the system. You have to leave room for the operating system to have memory as well. While you...
November 18, 2021 at 2:27 pm
SQL 2008R2 Standard Edition can only use 64Gb of memory, Enterprise Edition can use all of the memory available on the server. If you can upgrade to 2016 or...
November 18, 2021 at 2:24 pm
Dear Jeff Moden, thank you for you kind help! what you said is quite right.
if I ran it on the same server, sometimes it works fine, but sometimes not , ...
October 18, 2021 at 3:29 pm
thank you Jeffrey Williams, the table has clustered index, but when I used "alter table oldtable rebuild" , the table released a lot space, many thanks!
when I did this operation,...
October 18, 2021 at 1:34 am
in SQL Server, which operations will use more CPU resource? it seems that compilation and recompilation will lead to high CPU workload. are there any other operation will...
September 1, 2021 at 4:26 am
You can't really track user behavior through the logs. Without specialized tools, you can't view the information in the logs. That's really not what the logs are for. It's...
August 30, 2021 at 3:35 pm
FWIW, here's the worked solution, so folks at home can play along...
use tempdb;go/* setup script */CREATE TABLE LineItem(LineNum int not null,ItemNo char not null,Qty tinyint not...
August 30, 2021 at 6:08 am
892717952 wrote: Sorry! next time if have the same question I'll provide sample data, thanks! So, you're happy with the answers you got on this thread?
Sorry! next time if have the same question I'll provide sample data, thanks!
So, you're happy with the answers you got on this thread?
Yes, I have learnt...
August 27, 2021 at 3:11 pm
there are LineNo, itemNo and qty fields in one table, I want to the accumulative qty (totalQty) for each item and want to the totalqty shown as below...
August 19, 2021 at 3:35 pm
If you are hoping for a coded solution, please take the time to provide your sample data in a form which we can paste into SSMS and execute.
August 19, 2021 at 3:33 pm