Viewing 15 posts - 2,596 through 2,610 (of 3,061 total)
usman.tanveer (5/6/2009)I found it through Activity Monitor.
Good!... now show us the locks.
May 6, 2009 at 12:31 pm
usman.tanveer (5/6/2009)Here is the scenario. Query 1 is blocking Query 2 and Query 3
Lets go for the basics... Please show us what makes you think query #1 is blocking queries...
May 6, 2009 at 12:21 pm
Alvin Ramard (5/6/2009)Keep in mind that a DR plan for development can be completely different from a production DR plan. A development DR plan could be as simple as,...
May 6, 2009 at 8:06 am
Front end application code should handle field length at the GUI level.
In regards to the back end datatypes you may want to take a look at this: http://www.databasejournal.com/features/mssql/article.phpr/2212141/Choosing-SQL-Server-2000-Data-Types.htm
May 6, 2009 at 7:05 am
homebrew you have my vote.
DR must be part of the project's blueprint from day one otherwise how are you planning to get it funded?
May 6, 2009 at 6:50 am
Is this a reporting database?
Does it gets fully refresh overnight?
Is your backup strategy setup on full recovery model?
If YES, YES, YES... set your backup strategy to simple mode and...
May 5, 2009 at 4:18 pm
Do you really have blank rows in a table or a report is showing blank lines on it?
May 5, 2009 at 2:39 pm
atoth (5/5/2009)
Yes sorry, I should have used the word Shrink instead of truncate in my post - the log file wont shrink below 90GB.
What was the original size of the...
May 5, 2009 at 9:36 am
TRUNCATE and SHRINK are two different things.
TRUNCATE would truncate unused log segments but wouldn't affect TLog size.
SHRINK would reduce the size of TLog to a size not smaller than it...
May 5, 2009 at 7:25 am
It all will depend on some metrics...
How big are your affected tables?
What's the percentaje of rows affected by each archive & purge process?
May 4, 2009 at 4:09 pm
Since an Oracle package is nothing but a collection of storedprocs example next applies, please check this http://blogs.objectsharp.com/cs/blogs/matt/archive/2005/06/13/2221.aspx
May 4, 2009 at 4:05 pm
Gift Peddie (3/17/2009)
May 4, 2009 at 2:00 pm
abhi4u86 (5/1/2009)
Everything is fine in server,All databases are backedUp,Jobs are running fine, but in the morning report i got an error
"Failed to acquire connection "Local server connection". Connection...
May 1, 2009 at 11:20 am
Vijaya Kadiyala (4/10/2009)
There is no way to convert the SQL Loader control files to BCP format files.Why dont you try out SSIS..
"No way" sounds to me like an unfortunate wording...
May 1, 2009 at 7:41 am
Nilesh (4/29/2009)
April 29, 2009 at 10:46 am
Viewing 15 posts - 2,596 through 2,610 (of 3,061 total)