Viewing 15 posts - 1 through 15 (of 1,638 total)
Reasons why I go to/follow conferences:
General scope of what lives amongst the community: what are the new things, what is getting obsolete. .Net or .Net core etc
Some in-depth sessions about...
October 12, 2020 at 9:58 am
Was thinking about adding a computed column to the table and adding an index on it. Still a problem if you have multiple TRAN_TYPE per TRAN_AUTH_ID as the index might...
October 9, 2020 at 12:31 pm
(size of data table t1 + size of t2 join fields) * (number of rows in t2) ? SQL Server estimates it . Can be lower if data is streamed...
September 15, 2020 at 1:57 pm
I don't think that Read-Committed Snapshot isolation would help. Would be strange/bulky that sql server to keep the meta data of the table per new insert/update/delete
Changes to tablestructure takes a...
September 15, 2020 at 1:48 pm
Standalone config inplace upgrade december 2019 -> may 2020:
After upgrade it refused to recognise its configuration file. Solved after a repair installation. Still in test-phase. New powerbi reportbuilder will...
September 3, 2020 at 2:10 pm
Getting stackdumps is not a good sign.
Have you verified the integrity of the databases (DBCC checkdb)
On what patchlevel is the sql server 2014 instance
As you work with maintanceplans, I assume...
September 3, 2020 at 2:06 pm
15 min for one row is indeed very long.
Number of views shouldn't affect it unless it's an indexed view.
The number of indexes affected, more indexes: more housekeeping to keep everything...
August 24, 2020 at 8:18 am
Is it purely the engine or also other ms components like SSAS, SSIS, ...?
The major change is the new cardinality estimator introduced in 2014 which may effect the performance on...
July 2, 2020 at 2:11 pm
Rest in peace Mike
June 30, 2020 at 7:21 am
Sad thing that it has to come so far.
June 29, 2020 at 7:31 am
SSC Rookie, if you won't install .net 3.5 I would contact MS support to see what your options are
June 29, 2020 at 7:25 am
No apology needed. Thanks for posting the solution
June 24, 2020 at 9:24 am
Original way to put the brakes on. Get better soon Jasona.
For recovery you can train your hand with edge-browser easteregg edge://surf/
June 15, 2020 at 9:53 am
I applaud to all persons who have kids at home or other people /things that demands immediate attention.
We can still go outside, which is a plus
May 28, 2020 at 9:45 am
You might want to verify the integrity of the sql 2000 backup with dbcc checkdb
Not sure when page verify Checksum was introduced (better than torn-page detection) for corruption detection
May 15, 2020 at 2:24 pm