Viewing 15 posts - 286 through 300 (of 1,491 total)
If you want to post a query plan use something like:
https://www.brentozar.com/pastetheplan/
Would you download a unknown file from the internet?
December 6, 2022 at 1:49 pm
If you have done a SQL course it will have covered how to do this; you have just not fully understood.
I reccommend you read books by Itzik Ben-Gan starting with...
December 4, 2022 at 3:48 pm
If your Windows Login is a member of the local administrator group, you can start SQL Server in Single User Mode and add your Windows user to the sysadmin server...
November 14, 2022 at 6:32 pm
WITH AnyProcessed
AS
(
SELECT [Name], FileId, recordCount
,MAX(CASE WHEN processed = 1 THEN 1 ELSE 0 END) OVER...
November 9, 2022 at 10:32 am
Using short aliases would make this easier to read.
To make reasonable suggestions about indexes, stats etc we would really need to see the ACTUAL query plan.
https://www.brentozar.com/pastetheplan/
At a guess, NOT EXISTS...
November 8, 2022 at 10:38 am
The log file is an important part of the database as it is used to both roll forward and roll back on recovery. (ie When a transaction commits it is...
November 2, 2022 at 9:01 am
You might be able to get some limited retrospective information from the log. Going forward the following gives an outline and also links to some details on how to access...
November 1, 2022 at 3:39 pm
Can you tell me some more about it? Any example related to my case....?
As you have not posted DDL and test data we can only assume you are happy...
October 19, 2022 at 7:26 am
What I am trying to do with above Update query is that I am updating value of Individual_Id of the those records whose Ind_PK_Value_Updated is null (basically those records...
October 18, 2022 at 8:08 pm
As you can tell IT had lost faith in management. We were just intrigued to see what they would swallow. It turned out to be quite a bit! I think...
October 18, 2022 at 7:53 am
Reminds me of sitting in a meeting with some of my colleagues and having to keep a straight face when it was my turn to incorporate the next phrase from:
October 17, 2022 at 7:59 pm
What did you not understand about the following?
https://www.sqlservercentral.com/forums/topic/increment-max-value-by-over-a-complete-dataset
October 17, 2022 at 7:46 pm
It is up to you but personally, if at all possible, I would avoid nested transactions like the plague.
I would still strip out the transactions from SubProc1 etc and rename...
October 12, 2022 at 2:03 pm
I think you should check for @@TRANCOUNT and not XACT_STATE().
Also remove all TRYs, CATCHes and TRANsactions in the SubProcs. Something like the following should then work reasonably well:
October 12, 2022 at 9:34 am
What I want to know is whether, in the same session, several independent stored procedures could be performed at the same time..
Obviously not. (Except if you are bold enough...
October 11, 2022 at 2:53 pm
Viewing 15 posts - 286 through 300 (of 1,491 total)