Viewing 15 posts - 1,891 through 1,905 (of 2,496 total)
Do not forget there are separate SP4 files for SQL Server and for AS. When you apply SP4 to SQL Server, you should also apply hotfix 2187 as there...
November 23, 2007 at 2:29 am
Task manager, etc, does not show figuers for any memory allocated as AWE memory. The figures you are seeing are the best you will get. As you are...
November 22, 2007 at 6:33 am
With 64-bit SQL Server you should always set the maximum memory SQL can use. By default, SQL will try to use the total of physical memory and pagefile space,...
November 21, 2007 at 2:54 am
The most common cause I have seen of a backup not completing but not giving errors is lack of disk space for the backup. This should give you a...
November 20, 2007 at 6:21 am
It is important to design a backup strategy to meet the recovery SLA, and I have seen very few situations where a differential backup is beneficial.
If the SLA is to...
November 20, 2007 at 6:09 am
shahgols (10/4/2005)
Question for the experts here, is dbcc shrinkfile('log_file', truncateonly) the same as the option "Compress pages and then truncate free space from the file" in EM
The answer is...
November 20, 2007 at 5:30 am
You definitely get a new version of mssqlsystemresource with SP2, and you should always assume that upgrade scripts will run on master and msdb during a SP install.
November 19, 2007 at 3:20 am
I would advise against restoring master in your scenario. It is far better to transfer the logins via scripts.
The system objects in master may be different depending on te...
November 9, 2007 at 3:30 am
Unless someone is very experienced in SQL Server, they should never delete a database log file unless advised to do so by Microsoft support.
Deleting a log file is a last-ditch...
November 9, 2007 at 3:13 am
If the objective of doing the move is to get your data on to another disk, this can be done without moving the SQL Server program libraries. Perhaps the...
November 9, 2007 at 3:04 am
I think majorbloodnock has things about right. The client definitely has the right to expect work of merchantable quality. They should not expect world-leading skills unless they have...
November 9, 2007 at 2:52 am
The standard way of dealing with splitting up date values into periods is to use a date lookup table.
You need 1 row for every date likely to be in your...
November 7, 2007 at 5:46 am
The ROWCOUNT option is ignored when you do a INSERT INTO ... SELECT statement (see BOL). It is honoured for your initial 'Select Distinct RIGHT('0000000000'...' and for your 'Select...
November 7, 2007 at 5:23 am
If you are going to use recursion a lot, then consider moving to SQL Server 2005. You can write recursive SQL using Common Table Experssions (CTEs), which is a...
November 7, 2007 at 5:11 am
This is some basic advice about how to decide the size of tempdb
tempdb needs to be sized so that it will not grow while your server is in use.
This is...
November 7, 2007 at 5:03 am
Viewing 15 posts - 1,891 through 1,905 (of 2,496 total)