Viewing 15 posts - 16 through 30 (of 458 total)
OK, I finally found notes on the sys view I was trying to remember:
sys.dm_db_file_space_usage
This time, that should (actually) help you determine what you need to know (you would likely...
September 6, 2023 at 7:49 pm
Well, it's consistent in that it makes a backup only if there is a reason to do so. I find it a more sensible strategy, but as you wrote, it's...
September 6, 2023 at 6:29 pm
Thank you, I'll give that a try and see how it works, although the problem I'm running into is that I'm not getting the datetime-last-modified reliably from the system. Other...
September 6, 2023 at 6:12 pm
I didn't want to go into to a bunch of unnecessary detail that has nothing to do with my specific problem, but since you ask...
The Windows scheduled task runs every...
September 6, 2023 at 3:46 pm
Take a look at sys.dm_db_index_usage_stats, it should give you what you want.
That's exactly where I'm reading from now - it's right in the quoted Select statement. That is what...
September 6, 2023 at 3:19 pm
Okay, thanks. I guess this is one of the pitfalls of using a declarative language instead of a procedural one. I still have trouble getting my head around it sometimes,...
July 22, 2023 at 7:51 am
But it blows up when I try:
Select * From Query1 Where tmpResult1 = 'D'
That, good Sir, is what I'm talking about being the problem. That...
July 21, 2023 at 8:45 pm
In calculated columns in a view, the calculations in columns must be executed to produce the values that can be filtered and only then can the filter be applied...
July 21, 2023 at 5:53 pm
That did it. I put the view into the FileTable database and changed it around a bit to eliminate Unions. It's massively ugly now, but getting rid of unions and...
July 21, 2023 at 8:03 am
If I'm reading all of this correctly, another issue with filtering the calculated columns of a view is that all of the rows must first be materialized and then...
July 21, 2023 at 6:29 am
Well, I did it with a stored procedure, but it takes some extra dicking around in the app, because it caches the results. I have to do some extra clearing...
July 20, 2023 at 11:11 pm
The Where clause in the base view is the most complex part of the whole thing. I am looking at various filenames and picking out those I want. Things like...
July 20, 2023 at 9:59 pm
I see. That makes sense, but my source view is rather complicated. The base view picks out all the stuff that is acceptable, and the application is then supposed to...
July 20, 2023 at 9:50 pm
Okay, thank you. I'll try messing with the permissions until I get it trimmed down to what looks sensible,
February 28, 2023 at 10:48 pm
Again, NT Service was not an option.It was not offered, and when I typed it in manually, I got an error message. The account named only Service worked.
So you say...
February 23, 2023 at 6:13 pm
Viewing 15 posts - 16 through 30 (of 458 total)