Viewing 15 posts - 2,581 through 2,595 (of 2,756 total)
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
Did you look in the event log? I am willing to bet that that is exactly what it shows in the event log. I've sen those types of messages in...
March 9, 2017 at 11:12 am
I've not done much (ie anything) with windows failover clustering,but that dependencies list doesn't look like it lists cluster disk 5 as being included in the failover.
As a...
March 9, 2017 at 11:09 am
9 TB of data is a lot of data to restore, so it doesn't surprise me it takes a while especially on a system with that low of memory.
March 9, 2017 at 10:28 am
small progress again, firewall was blocking some ports on remote computer so i think i...
March 9, 2017 at 8:44 am
Right. About the CHECKDB thing. that threw me off. But you have not run checkdb in quite some time, no? 2017-01-19 appears to be the last time it was...
March 9, 2017 at 8:20 am
If I understand the logic correctly, I think this is more what you want for your loop:WHILE EXISTS(SELECT 1
...
March 9, 2017 at 8:09 am
Viewing 15 posts - 2,581 through 2,595 (of 2,756 total)