RAID (redundant array of independent disks) is a disk system that contains multiple disk drives, called an array, to provide greater performance, reliability, storage capacity, and lower cost. Fault-tolerant arrays are categorized in six RAID levels: 0 ...

I agree with Mr. Gorey , It were two but at the end It will be one....

For more reference plz follow this link http://msdn.microsoft.com/en-us/library/ee343986%28v=sql.100%29.aspx...

Agreed with you Michael .. Thanks for that I didn't try that before......

Hello sir, If there is no changes than 1.) I will first Restart the SQL SERVER so that TEMPDB will free from temp tables bulk ---------- 2.) GO SQL-Profiler --------- 3.) Execution Plan checking...

for any query plan there is at least two copy of plan being generated one for serial and another for parallel which will go for any degree and that is used by other instance and user too... **but instead that will not retain because they are single thr...

SELECT TOP 10 d.object_id , d.database_id , OBJECT_NAME(object_id, database_id) 'proc name' , d.cached_time , d.last_execution_time FROM sys.dm_exec_procedure_stats AS d ORDER BY [total_worker_time] DESC;...

select a.object_id ,SCHEMA_NAME(schema_id) as [SCHEMA] ,a.name as [Procedure] ,type ,type_desc ,create_date as [Created Date & time] ,modify_date as [Modified Date & time] from sys.objects a Where type ...

There are few among many 1.) we can Insert to View but not in function ---------- 2.) we have to refresh view after changing in metadata but not in case of function ---------- 3.) we can do indexing in view but not in function ---------- 4...

there are few of many ones 1.) we can Insert in view but not from Inline Function ---------- 2.) View have refreshment problem when we have add columns than we have to refresh view by this query 'exec sp_refreshview '' but with function ...