Viewing 15 posts - 1 through 15 (of 69 total)
Thanks all, Jeff's reply had me thinking about Query Store as we're on SQL 2019. Potentially both worth looking into though, cheers!
March 2, 2022 at 11:36 am
You are probably right Jeff, the actual use case is to log specific query executions to a table...but now you've got me thinking of other potential ways...🤔
It's partly for performance...
March 1, 2022 at 5:13 pm
Brilliant, thank you both - very useful links!
March 1, 2022 at 5:08 pm
Thanks ChrisM, that's an interesting idea. I've just tried it using Phil's suggestion and it updated 20,000,000 rows on a cold cache in almost exactly 4 minutes (and only running...
March 1, 2018 at 7:34 am
Ah of course! That would make much more sense...why didn't I think of that.... :ermm: Haha
I'll give that a try - thanks very much!
March 1, 2018 at 6:44 am
ChrisM@Work (7/21/2016)
matt.gyton (7/20/2016)
I experimented with the plans by comparing the two XML versions on a diff checker and they came up almost identical with...
July 21, 2016 at 4:28 am
So it turns out my earlier optimism was slightly misplaced....the code change did not provide the fix 🙁
However, I noticed that it temporarily improved performance until the SP ran with...
July 21, 2016 at 4:10 am
Thanks Jeff, I wasn't aware of that...just read the article - looks interesting! I don't think we suffer too heavily from TempDB contention at present, but it's certainly worth looking...
July 21, 2016 at 2:18 am
Think I may have a solution!
I experimented with the plans by comparing the two XML versions on a diff checker and they came up almost identical with the exception...
July 20, 2016 at 10:21 am
Hi All,
Many thanks for all your responses. I have restored a fresh copy of the database to try and ensure there are no differences and all these things appear to...
July 20, 2016 at 6:19 am
Table definition:
[TK_ROWID] [int] NOT NULL,
[SEQ_COMPANY] [varchar](6) NOT NULL,
[SEQ_LEDGER] [varchar](6) NOT NULL,
[SEQ_TYPE] [varchar](6) NOT NULL,
[SEQ_DESCRIPTION] [varchar](40) NULL,
[SEQ_SHORT_DESC] [varchar](20) NULL,
[SEQ_NEXT_BATCH] [int] NULL,
[SEQ_NEXT_TRANS] [int] NULL,
[SEQ_ACTIVE] [varchar](1) NULL,
CONSTRAINT [PRI_SEQUENCE] PRIMARY KEY CLUSTERED
(
[TK_ROWID]...
October 10, 2014 at 4:55 am
Sorry just one more thing that's puzzling me about this....
The processes become deadlocked when both are attempting to run the following query:
UPDATE GL_SEQUENCE SET @NEXT_TRANS_INT_REF = SEQ_NEXT_TRANS = SEQ_NEXT_TRANS +...
October 10, 2014 at 4:29 am
Aaaah I see - many thanks....still getting my head round these a bit...!
October 9, 2014 at 9:07 am
Jason-299789 (9/18/2014)
as its possible a file that SSAS needs to start up may be corrupt or missing.
This might...
September 18, 2014 at 7:10 am
These are the only errors I get....
In the event viewer:
The service cannot be started: Message-handling subsystem: The message manager for the default locale cannot be found. The locale will be...
September 18, 2014 at 5:01 am
Viewing 15 posts - 1 through 15 (of 69 total)