Viewing 15 posts - 421 through 435 (of 2,051 total)
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
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
https://www.sqlskills.com/blogs/glenn/setting-your-page-verify-database-option-to-checksum/
May 15, 2020 at 2:24 pm
Me neither, apparently EDI-files https://en.wikipedia.org/wiki/X12_Document_List
May 5, 2020 at 2:30 pm
Recommendations: keep it within the applications specs.
Downside of having nvarchar too big:
More memory reserved in applications / sql server for retrieval of data as each field can hold more data.
No...
April 30, 2020 at 11:57 am
Thanks for mentioning sys.dm_db_persisted_sku_features, didn't know it existed
April 30, 2020 at 11:22 am
I personally dislike single letter aliases, usually too short to have a representative meaning. With a as (), b as (), c as (), d as () . Select ......
April 28, 2020 at 10:11 am
Probably there is a filter active on tablix, dataset, ... Do you have the same problem in a blank report with just the sp?
April 21, 2020 at 8:28 am
Use synonyms, views on srv 2 ? Srv3 queries srv2 (which queries srv1)
April 21, 2020 at 8:27 am
Viewing 15 posts - 421 through 435 (of 2,051 total)