Viewing 15 posts - 46 through 60 (of 119 total)
hey
first you are having sql 2005 version we can install other named instance of sql server 2008.
August 1, 2011 at 1:20 am
The fill-factor option is provided for fine-tuning index data storage and performance. When an index is created or rebuilt, the fill-factor value determines the percentage of space on each leaf-level...
May 30, 2011 at 7:57 am
If you find your database in Suspect mode, then please keep your nerve strong. Just proceed step by step what I am written below. I think you will get out...
May 30, 2011 at 7:51 am
Basically this .tuf file is the Transaction Undo File, which is created when performing log shipping to a server in Standby mode.
So if you ask why standby mode, database recovery...
May 23, 2011 at 4:40 am
Row versioning isolation levels can improve concurrency because committed data can be read from the version store instead of acquiring locks on data read. All update and delete statements...
May 23, 2011 at 4:21 am
sys.os_exec_performance_counters DMV
The "sys.os_exec_performance_counters" DMV, lets you use simple TSQL to obtain different SQL Server performance counters. This view contains both instance level and database specific counters. Some counters provided valuable...
May 18, 2011 at 6:15 am
We have been seeing and trying to resolve SQL connectivity issue all the time. I guess it would be helpful if we can put some guidance on how to resolve...
May 18, 2011 at 6:13 am
database can go in suspect mode for many reasons like improper shutdown of the database server, corruption of the database files etc.
To find out the error:
DBCC CHECKDB (‘YourDBname’) WITH NO_INFOMSGS,...
May 18, 2011 at 6:11 am
SQL Server 2005 introduces a new DMV (Dynamic Management View) to check index fragmentation levels: sys.dm_db_index_physical_stats. Although SQL Server 2005 still supports the SQL Server 2000 DBCC SHOWCONTING command, this...
May 18, 2011 at 4:57 am
i can't understood the answer properly.Can any one explain briefly ?
May 10, 2011 at 12:10 am
going back to basics...ohh good remember the concepts from basic level...
April 27, 2011 at 12:30 am
hey
thanks for the reply .I setuped the mirroring in
Synchronized: the databases are fully synchronized.
so if pathes are installed to my operting syetem.it needs to going to be restarted .so...
April 26, 2011 at 5:58 am
Good Question for Administrators...keep this like posts for the DBAS
April 22, 2011 at 1:35 am
Phil Parkin (3/16/2011)
SUPER SQL STAR (3/16/2011)
for my project purpose
That's it? You expect others to take the time to craft a technical response to a question when you are not...
March 16, 2011 at 8:33 am
Viewing 15 posts - 46 through 60 (of 119 total)