Viewing 15 posts - 466 through 480 (of 501 total)
If you are backing up to the same drive as where your data files reside, then you are creating an IO bottleneck by forcing the disks to read and write...
June 22, 2007 at 5:07 pm
Right click on tempdb in Enterprise manager, and select properties. There you can set the minimum data file size and minimum log file size.
June 12, 2007 at 5:53 pm
Your page file is also too small. Microsoft recommends the page file be 1.5 to 2 times the size of the physical memory. With 8GB in your machine, your page file...
May 11, 2007 at 4:44 pm
SQL server writes data to the data files in a filegroup with a proportional fill algorithm. The data files with the most free space get written to before data files with...
May 11, 2007 at 4:28 pm
Colin is correct. You should be using RAID 1 for tran logs. See item 5 in the link:
http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/storage-top-10.mspx
May 8, 2007 at 12:30 pm
You can use sp_who2 to find the SPID and DBCC INPUTBUFFER ().
May 1, 2007 at 11:42 am
I would agree with Jezemine. The SQL Server Migration Assistant for Access allows the most control.
April 30, 2007 at 4:28 pm
You must use sp_repladdcolumn if you do not want to reinitialize the publication.
April 27, 2007 at 3:57 pm
I use this to reindex everything in a single db:
Declare reindex CURSOR
FOR
Select 'DBCC DBREINDEX (N''[' + u.name + '].[' + o.name + ']'', [' + i.name + '], 90)'
from sysindexes...
April 27, 2007 at 12:57 pm
To move an existing table in to a newly created file group:
Right click the table and select design. Under propeties and table designer, you can select the new filegroup.
April 18, 2007 at 3:12 pm
It is recommended to leave the "max worker threads" setting alone. However...
April 18, 2007 at 12:12 pm
Here is a start: http://download.microsoft.com/download/7/6/f/76f3db2f-6f43-4624-bfde-ff731e3c1f96/GDClusters.doc
April 13, 2007 at 4:34 pm
If you are restoring the datafile to the same drive as the backup, then you are creating a huge I/O bottleneck by forcing the disk to perform both read...
April 13, 2007 at 2:37 pm
Cut this C:\Documents and Settings\All Users\Start Menu\Programs\Microsoft SQL Server 2005
then paste it back into C:\Documents and Settings\<USERNAME>\Start Menu\Programs\Microsoft SQL Server 2005.
You will also have to change the security on C:\Program Files\Microsoft...
April 12, 2007 at 12:02 pm
SQL Server Migration Assistant for Access is better than upsizing.
http://www.microsoft.com/sql/solutions/migration/access/default.mspx
Once you have migrated to SQL you will need to setup an odbc to SQL and then link the tables...
April 10, 2007 at 3:52 pm
Viewing 15 posts - 466 through 480 (of 501 total)