Viewing 13 posts - 256 through 269 (of 269 total)
Never used this but tried host_name()
both with the braces and without and all erred out in both versions 7& 8 of sql server
Am I missing something?
Thanks
Mike
October 27, 2003 at 5:44 am
http://vyaskn.tripod.com/analyzing_profiler_output.htm
and
Sql Server 2000 Performance Tuning Technical reference by Whalen Garcia Deluca Thompson
Were pretty helpful to me
Mike
October 23, 2003 at 12:40 pm
Use Data transformation services.
It will virtually walk you through and you
should have an option of scheduling
Mike
October 22, 2003 at 12:58 pm
The indexes are clustered for the most part.
Would that make a lot of a difference?
October 22, 2003 at 12:49 pm
Cannot see the thread you are responding to
Mike
October 22, 2003 at 12:39 pm
The default databases except exceptionally used may not benefit from transaction log backups.
Tempdb cleared every time sql server is stopped and started.I do not back it up
Pubs and Northwind -I...
October 22, 2003 at 12:36 pm
I did rebuild the indexes with a fill factor of 0 from 90 after accidentally writing 100 in place of Zero.
Right now the origfillfactor shows as 100 I have...
October 22, 2003 at 12:22 pm
Right clicking on SQL server agent and job system does give you the maximum job history log size (rows) and the maximum number of rows per...
October 21, 2003 at 1:31 pm
I meant during an index rebuild
October 21, 2003 at 3:20 am
What Authentication method are you using?
Did you have any errors ?
Mike
October 20, 2003 at 9:59 am
Is this sql you wrote?
If it is, could you send mail at each point you need notified (If you do not have many loops in your program)
Mike
October 20, 2003 at 9:18 am
Use a Database maintenance plan to schedule a backup /
Alternatively
Right click on database in question select all tasks
and select backup database (at an appropriate time)
As said...
October 20, 2003 at 9:05 am
Viewing 13 posts - 256 through 269 (of 269 total)