Viewing 15 posts - 16 through 30 (of 465 total)
And, I think it was mentioned earlier, but any chance you have "autoclose" or "autoshrink" turned on? I doubt that autoshrink would cause this issue, but I could see...
September 7, 2023 at 4:21 pm
And your backup process is done outside of SQL? Is there a reason you don't use the SQL Agent to schedule the jobs? I mean, nothing against doing it...
September 7, 2023 at 3:57 pm
That sounds like it may be a bug in SSMS then... but oof... using the edit GUI in SSMS? I find that to be clunky and painful to work...
September 7, 2023 at 3:48 pm
As another random thought - Are you seeing any pattern to when it blanks out? Like is it good at 8:02 but by 8:15 it is blank? If so,...
September 7, 2023 at 2:58 pm
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...
September 7, 2023 at 11:34 am
Even weirder. I just made some manual changes, in a table that I confirmed has a primary key. Initially, it showed a change in only one of the tables, from...
September 7, 2023 at 11:30 am
Just thought of a small scenario that MAY not impact you, but thought I'd toss this in here too - do you have any heaps? The reason I ask...
September 6, 2023 at 7:53 pm
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
Viewing 15 posts - 16 through 30 (of 465 total)