Viewing 15 posts - 91 through 105 (of 207 total)
Thanks for the reply.
Yes I understand the reasons for the difference in the read/write ratios and understand that the index helps certain queries that choose to use it (ie statements...
February 13, 2014 at 9:19 am
I have just tried closing ssms, reopening ssms as an admin, closing down the connection logon box, then click new query - the connect to box appears with the...
February 6, 2014 at 3:00 pm
Object explorer appears to be disconnected beacuse I have an option to connect and i cannot see any connections in the object exploer - its just blank !
February 6, 2014 at 2:43 pm
Are you using this box as its own distributor?
No this box is just used as a subscriber. We have 2 separate servers for both the Distributor and the Publisher.
Also there...
February 4, 2014 at 5:09 am
Gail in answer to the following:
Check that it's scheduled, check that the settings are correct, check that it's actually running.
The job is scheduled and the job is enabled -...
January 30, 2014 at 2:28 am
Yes I have opened the job up. It is under the 'Management' \Maintenance plans folder and when i open it I see that it is a 'Check database Integrity Task'...
January 29, 2014 at 7:21 am
When you say linked servers will fail ? I presume you mean if they are configured to use sa as the login account - which ours are not !
January 24, 2014 at 3:03 pm
Hi
Yes I noticed that yesterday when I disabled the sa account on my test laptop and jobs still ran ( i had a ssis transaction log backup that i set...
January 24, 2014 at 8:05 am
Lowell - thanks for the input. I have managed to fix without using the script you mentioned but it does look good and I will be checking it out and...
January 23, 2014 at 3:01 pm
Fantastic ! Thanks very much for this info - so all is not lost then ?? 🙂
I'll have to google how to do what you suggested but thanks very much...
January 23, 2014 at 9:58 am
Find out what is generating the hash\sort warnings and fix it. Just extending TempDB is merely putting a sticky plaster over the real problem.
This may warrant a seperate discussion....but...
January 15, 2014 at 6:43 am
So do I have to kind of just guess what size I need to allocate to the files then ? As I say the 2 20Gb files have never had...
January 15, 2014 at 4:38 am
Ok thanks for the replies everyone - looks like a complicated process to implement. I'm going to have to give this some serious thought.
:-):-)
January 15, 2014 at 4:20 am
Just in case anybody else has the same problem........a new snapshot is required, so i did this out of hours since it locks the tables involved in the replication. 🙂
January 7, 2014 at 9:19 am
Viewing 15 posts - 91 through 105 (of 207 total)