Viewing 15 posts - 16 through 30 (of 9,208 total)
We've given you straight answers, but I don't think you understand Filestream, so they don't make sense. You have to invest a bit to understand how this works to...
June 20, 2024 at 7:24 pm
Stats are more important that index maint, indexes in sql server are fairly robust as long as the stats are good
June 20, 2024 at 3:53 pm
Will be disk issue most likely
June 19, 2024 at 10:08 pm
I dunno why I can't wrap my head around this... but I'm so confused how creating a brand new table that ISN'T filestream... still keeps the files intact. Where...
June 19, 2024 at 10:06 pm
though I'd recommend at least considering storing files w/ operating system and just storing paths in the database
That’s what filestream does, stores the files directly on a dedicated ntfs...
June 19, 2024 at 9:49 pm
Thank you for confirming that sql developer will accomplish what I wanted to move to Oracle.
never confirmed that, that’s a whole different ball game.
to get access to the raw...
June 19, 2024 at 9:46 pm
Yes, I have been scouring documentation for the past 2 days and finding it very difficult to get information on this feature.
I found multiple docs on first search
I...
June 19, 2024 at 6:07 pm
aside what Ken stated, what have you done so far to produce your own solution
June 19, 2024 at 9:49 am
anyone finding the posts in last couple months are real Facepalmers
June 19, 2024 at 9:47 am
Have you checked the documentation for Filestream.
The files are not stored in filestream data file, the symbolic links to the OS level file are stored.
I strongly recommend you read all...
June 19, 2024 at 9:44 am
you can't realistically expect the answer to this from a forum post, we have no way of knowing what's driving the size changes.
Check index create dates and find out if...
June 19, 2024 at 9:37 am
whats changed recently, has someone created new indexes by any chance?
June 19, 2024 at 9:35 am
There are 2 permissions that need to be applied to service accounts when running under a low privilege domain account
some AD admins don’t like to grant these some...
June 14, 2024 at 10:55 pm
You can see if SPNs are generated automatically from the sql error log
if not generated automatically would warrant further inspection to see if they have been manually created
June 14, 2024 at 8:58 pm
Viewing 15 posts - 16 through 30 (of 9,208 total)