Viewing 15 posts - 1,081 through 1,095 (of 2,897 total)
Where would the trigger be placed ? How would it work ?
My suggestion requires a scheduled job to run every 'x' minutes.
The right solution depends on your specific...
January 26, 2011 at 9:48 am
There have been a several threads about performance problems after migrating to 2005. Not sure if they would apply to you, but worth a look.
January 26, 2011 at 9:35 am
Run your query to get a count, and if @@rowcount >= 28, then sp_send_dbmail
January 26, 2011 at 9:28 am
Our application stores voice recordings in IMAGE type columns. This was migrated from SQL 2000, and I'm sure there are better methods ... but it works. They are not...
January 26, 2011 at 8:23 am
I would think in this part. You could use GETDATE() and some date functions to return data within the last X days (or weeks etc...)
/*Show data*/
SELECT
Database_Name
,Database_Size_MB
,Unallocated_Space_MB
,Reserved_MB
,Data_MB
,Index_Size_MB
,Unused_MB
,DateTimeStamp
FROM DBSTATS.[dbo].[DatabaseGrowth]
WHERE DateTimeStamp >...
January 26, 2011 at 7:46 am
The script was probably written with the intention of not writing over the data, but keeping it all for historical purposes. You can delete or truncate the data if you...
January 26, 2011 at 5:23 am
I don't have 2008, sorry.
From Microsoft:
To start the Maintenance Plan Wizard
Expand the server.
Expand the Management folder.
Right-click Maintenance Plans and select Maintenance Plan Wizard. This launches the wizard and you can...
January 25, 2011 at 8:18 pm
Little Nick (1/25/2011)
My final decision is
1. I choose Recovery Model is FULL
Based on article quote "Full recovery can be difficult to manage as the...
January 25, 2011 at 7:48 pm
Much good advice given.
Also, Do you have good backups of database & t-log ?
January 25, 2011 at 12:04 pm
Little Nick (1/25/2011)
Can you give me a steps to address the size as mentioned?
Set up Transaction Log backups to run every 20 minutes. (more or less based on need)
Read &...
January 25, 2011 at 11:19 am
KMPSSS (1/24/2011)
I have small doubt in this,here i can only view one month data in that report. Is there any constraints in...
January 24, 2011 at 10:14 am
Perhaps the OP meant why an alias is required ?
January 24, 2011 at 9:35 am
What transfer rate are your differentials ?
January 24, 2011 at 9:21 am
If you look at the path where the backups should be, they are not there ?
If you query the backup history files, does it say they were backed up at...
January 24, 2011 at 8:09 am
Viewing 15 posts - 1,081 through 1,095 (of 2,897 total)