Viewing 15 posts - 2,701 through 2,715 (of 2,883 total)
As a thought, did you backup and restore the encryption keys when moving the SSRS database?
And if this is SQL Standard, did you remove the entries to the...
March 14, 2017 at 11:30 am
Sounds to me like the plan cache got cleared out and things improved.
Might want to check on the age of your statistics and possibly schedule an update on...
March 14, 2017 at 11:22 am
People keep talking about using a Calendar table to solve the "correct age...
March 14, 2017 at 11:13 am
March 14, 2017 at 10:59 am
In our production server, we are using one query to fetch the result...
March 14, 2017 at 10:45 am
March 14, 2017 at 10:27 am
March 14, 2017 at 10:15 am
March 14, 2017 at 10:13 am
Jeff, that makes sense then. I had it set to results to grid, so I did get the million rows plus those messages. Well, on one of the 2 SSMS...
March 14, 2017 at 9:47 am
March 14, 2017 at 8:50 am
That's nice info but you've not solved the problem that was defined by...
March 13, 2017 at 4:27 pm
That'd be my next guess. I would think that SQL would need to do some form of sanity check to make sure that the data pages are all properly in...
March 13, 2017 at 10:20 am
You say you have 18,000 data files. are those all on different disks? If not, you will not really get a performance benefit and I can see that causing a...
March 13, 2017 at 8:45 am
I might have an idea - how many VLF's do you have?DBCC LogInfo(<database name>)
If you have a crazy high number of VLF's, that will greatly...
March 10, 2017 at 7:45 am
Viewing 15 posts - 2,701 through 2,715 (of 2,883 total)