Viewing 15 posts - 736 through 750 (of 860 total)
I don't think you should enable AWE for a 64 bit environment.
and I also I would like to ask was there any memory pressure on your SQL server? Why...
February 11, 2009 at 7:11 am
GilaMonster (2/11/2009)
Krishna (2/11/2009)
Partition could be benefited if the table is queried heavily for performance reasons
If can, but the partition function must be chosen very carefully, considering how the table...
February 11, 2009 at 6:49 am
If i have a large table with 90 million records, is that a sign that i should partion it?
Partition could be benefited if the table is queried heavily...
February 11, 2009 at 5:30 am
Log Shipping---High Availability
Replication-- For distributing Data/objects across multiple servers
DTS>SSIS in SQL 2005-- Extract, Transform and Load Data from different sources to SQL server or vice versa
how to create logshiping...
February 11, 2009 at 5:24 am
You really need more information on this:
The type of data and quantity of data to be replicated
and one thing that differs from most of them is does it get updated...
February 11, 2009 at 5:15 am
GilaMonster (2/11/2009)
Krishna (2/11/2009)
Set the DB on single user mode :alter database msdb set multi_user with rollback immediate
Don't you mean set single_user with rollback immediate
oops! sorry typo mistake,
alter database msdb...
February 11, 2009 at 5:06 am
jabba (2/11/2009)
DBCC CHECKDB("msdb") with TABLOCK
The result was:
Msg 5030, Sev 16, State 12, Line 1 : The database could not be exclusively locked to perform the operation....
February 11, 2009 at 4:11 am
That being said... Does the primary server ever suffer do to the connection to the mirrored server? Will the primary servers performance degrade if the the transactions are slow going...
February 11, 2009 at 2:19 am
Alright that's cool.
No it really does not matter but I was doing a test on what is the impact on the system if autogrowth is enabled. But then I...
February 10, 2009 at 4:40 pm
If you need to get that size automatically every time you create a new DB and your model is 3MB you will have to shrink it
Yes, thats true! But...
February 10, 2009 at 3:54 pm
"Database DB_NAME' cannot be opened due to inaccessible files or insufficient memory or disk space.
See the SQL Server errorlog for details. "
Is there enough space in D:\ drive then?
Did...
February 10, 2009 at 3:06 am
Just for your info, this is a MSSQL forum I am afraid. You posted in the wrong site.
February 9, 2009 at 7:28 pm
Run sys.dm_db_index_physical_stats and look for "avg_fragment_size_in_pages" that wold be the best reading I would say
February 9, 2009 at 7:01 pm
I am not quite sure about the above stats, we need to wait for the experts but as far as I am concerned the SQL server uses the memory only...
February 8, 2009 at 7:50 pm
In your statement there is no commit statement
I don't have any "begin transaction" statement.
then "begin transaction" and "end transaction"/"commit transaction"
...and the log grows as it has to hold all...
February 7, 2009 at 4:35 pm
Viewing 15 posts - 736 through 750 (of 860 total)