Viewing 15 posts - 2,776 through 2,790 (of 3,232 total)
Where do the values in the INLIST come from? You can build a derived table for your join without having to use dbo.split.
July 7, 2006 at 12:23 pm
Well, first of all, a database does not have to be in single user mode for a backup to take place. Odds are, he is bringing the database into single...
July 7, 2006 at 12:06 pm
Yes, another good suggestion. I would also run a SQLDiag on the server.
July 7, 2006 at 10:13 am
"Buffer Cache Hit ratio is around 65% on average."
65% is much too small of a Buffer Cache Hit ratio. You want this number to be consistantly above 90% and idealy...
July 7, 2006 at 9:41 am
Also, given the broad task of 'checking the box', I don't think you want to only capture SQL Profiler data. I would also capture some Windows Performance Monitor metrics. SQL...
July 7, 2006 at 9:18 am
Is this in a test environment? I would set up a SQL Profiler trace. Make sure you use the following events: SP:Starting, SP:Completed, SP:StmtStarting, SP:StmtCompleted, SQL:StmtStarting, SQL:StmtCompleted. Also, in the Columns...
July 7, 2006 at 8:57 am
From BOL: "If EXPIREDATE or RETAINDAYS is not specified, expiration is determined by the media retention configuration setting of sp_configure. These options only prevent SQL Server from overwriting a file....
July 6, 2006 at 3:23 pm
Make sure you use the EXPIREDATE or RETAINDAYS options in all of your backups. WITH INIT will only overwrite the backup if it is expired or past the retention days...
July 6, 2006 at 2:32 pm
Yes, right-click on the job and select Properties. Go to the Schedules tab and click on Edit. Press the change button. Select the Monthly radio button. Under the Monthly Section,...
July 5, 2006 at 4:16 pm
You could place this one table in a filegroup so that it is in a different data file and use DBCC ShrinkFile on it. While this may not normally be...
June 30, 2006 at 9:17 am
I would say that you need to size your tempdb back to where it was. Whatever size your tempdb was before changing it, it got that way because it needed...
June 30, 2006 at 9:11 am
First off, you do not have to drop the column to drop the clustered index. Since it is a clustered index /PK, use ALTER TABLE MyTable DROP CONSTRAINT PK_MyTable. This...
June 30, 2006 at 9:03 am
We've not used SQL Server 2005 yet, but in 2000, you can move your non-clustered indexes into a filegroup and then place the physical files for that index filegroup on...
June 29, 2006 at 3:47 pm
I have a couple of questions for you. First, is there a reason why you would allow an application to drop/recreate the Primary Keys on all tables in your database? ...
June 29, 2006 at 12:58 pm
SELECT SU.Name + '.' + SO.Name
FROM SysObjects SO
INNER JOIN SysUsers SU
ON SO.uid = SU.uid
Use a WHERE clause to limit type of object on xtype.
June 29, 2006 at 12:26 pm
Viewing 15 posts - 2,776 through 2,790 (of 3,232 total)