Viewing 15 posts - 24,016 through 24,030 (of 39,818 total)
I haven't used it in 2005, and it might work much better. Never know how much work was done there between versions.
I'd still recommend you script the jobs, deploy them...
May 6, 2009 at 9:01 am
What didn't work for you? I'd like to see you do some work here rather than just give you the answer.
A few hints: script the backup job (meaning the creation...
May 6, 2009 at 8:57 am
You'd have to get more details from someone. There might be whitespace in fields if you have char instead of varchar fields.
If they mean you have more space in your...
May 6, 2009 at 8:55 am
We want to see you do some work, so make an attempt.
As a hint, group by the clients, count the currencies.
And you'll need a HAVING clause.
May 6, 2009 at 8:54 am
You can use sp_spaceused to see the space inside a database.
alternatively, track the backup file size and compare that to what size of the data file and you'll have a...
May 6, 2009 at 8:53 am
If you don't have a degree, you don't know what you're missing. The fact that poorly built databases are developed by those with degrees doesn't mean a degree didn't help...
May 6, 2009 at 8:46 am
http://www.mssqlcity.com/FAQ/Devel/xp_regwrite.htm
No real reason that this is better than scripting this in VBScript. I guess it might be easier if you have connectivity to each SQL Server instance.
I have had MSX/TSX...
May 6, 2009 at 8:40 am
Why did you write it this way? I'm curious because you might have a good reason, or you might be thinking about this wrong.
If you reversed the statements, and looked...
May 6, 2009 at 8:37 am
Nothing wrong with emailing to Hotmail if it isn't sensitive information.
We used to zip up each day, copy to a remote disk, separate folder for each day. Gave us easy...
May 6, 2009 at 8:35 am
Just as a short note, backup and restore should be your first DR thought. You might supplement that with mirroring, replication, etc., but be sure you can restore a db...
May 6, 2009 at 7:56 am
you need to stop shrinking it.
Obviously you need more log space, so make the log bigger (or leave it big) and the tickets will stop.
May 5, 2009 at 4:48 pm
If you have the db at 65GB, what percentage is used, and what is the growth rate?
For the re-indexing, you need space, but that depends on your clustered indexes, which...
May 5, 2009 at 4:37 pm
Viewing 15 posts - 24,016 through 24,030 (of 39,818 total)