Viewing 15 posts - 256 through 270 (of 5,394 total)
sgrimard (11/9/2015)
It says 500KB.. what is the recommended size?
This fairly old whitepaper on index maintenance recommends skipping maintenance for indexes smaller that 1000 pages.
1000 pages * 8Kb per page =...
November 10, 2015 at 2:52 pm
This is the whois record:
Domain Name: HOWTOSQL.COM
Registry Domain ID: 1665756602_DOMAIN_COM-VRSN
Registrar WHOIS Server: whois.tucows.com
Registrar URL: http://tucowsdomains.com
Updated Date: 2015-06-07T18:52:58Z
Creation Date: 2011-07-07T18:50:49Z
Registrar Registration Expiration Date: 2016-07-07T18:50:49Z
Registrar: TUCOWS, INC.
Registrar IANA ID: 69
Registrar Abuse Contact...
November 9, 2015 at 10:28 am
Try to take more frequent log backups during the rebuild process. You could take log backups every 1 minute and put a delay of 1 minute between each table rebuild.
November 9, 2015 at 10:08 am
Reorganize could help, but I can't tell how much.
Another possibility is BCP the data to a file, drop the table and BCP the data back in. Index rebuild does almost...
November 9, 2015 at 9:30 am
Only 20 MB of log activity means that the database is close to unused. Thus, indexes don't need to be rebuilt.
Ola Hallengren has a database maintenance script that takes fragmentation...
November 9, 2015 at 9:24 am
How big is the index? If the index is very small, you have very few chances of getting low fragmentation.
November 9, 2015 at 9:21 am
Brandie Tarvin (11/5/2015)
BWFC (11/5/2015)
I've been asked to look into ad-hoc reporting solutions so users can create their own reports.
All I know is it's a...
November 5, 2015 at 6:58 am
Why do you think you need an additional disk?
What problem are you trying to solve?
November 5, 2015 at 2:19 am
I'm sorry to say that and I mean no offense, however: you're doing it wrong.
1) Set up a subscriber on your machine and subscribe to that publication.
2) Start the...
November 4, 2015 at 8:51 am
I'm sorry, there is not enough information to answer your question.
If you want sensible answers and fast turnaround on your questions, see the instructions here[/url].
November 4, 2015 at 7:39 am
I don't think that index fragmentation is your problem. MsMerge% tables are based on GUIDs and will always be fragemented.
I would rather try to trace a sync process with a...
November 4, 2015 at 4:20 am
You probably don't need to filter on the client side (powershell script). The filter on the session could be enough.
The event you have to capture is "errorlog_written" and filter for...
November 4, 2015 at 4:16 am
I don't know how to help you then.
Do you have one of those subscribers available for troubleshooting?
Can you set up a subscriber (your desktop computer would do as...
November 3, 2015 at 10:56 am
First one is that its and .exe
I don't see a problem with that. The source is trustworthy.
Second one is that iam using sqlserver 2014.
Will probably work with 2014 as...
November 3, 2015 at 10:54 am
Viewing 15 posts - 256 through 270 (of 5,394 total)