MSSQLTips

Hi What considerations I need to follow to secure my master database in SQL Server 2005?

I have a table having 84000+ records, I am planning to consider index on this table. I am putting few details of execution plan below: - When table has no Index: - Select * from TABLE name; Table scan happens, Estimated I/O cost = 0.517278 Estimated CPU cost = 0.0930076 Estimated operator cost = 0.610285...

Hi I need to recover data from .LDF file whereas I have lost my .MDF file. My database was in Full Recovery Mode, I have full backup of a day back, but no transactional backup. Having full backup of Thursday, changes made in database on Friday. I dont have any backup of Friday, I need to recover till...

Hi, Can anyone tell me the disadvantages of Index ? How do many Indexes on a table degrade the performance ? Thanks in advance.

Hi, Can anybody tell me about B-Tree, how it works ? How it searches data, deletes data, update data ? Thanks in advance.

Hi, When to use Clustered Index and when to use Non-Clustered Index ? Please help me to understand this question with suitable examples. Thanks in advance.

I have an index on a table in sql server 2005. When I run this statement dbcc showcontig (CropSubVar) it showed me the following result:- DBCC SHOWCONTIG scanning 'CropSubVar' table... Table: 'CropSubVar' (821577965); index ID: 1, database ID: 6 TABLE level scan performed. - Pages Scanned...

Can anybody give me some example on Index scan vs Index seek ? Is there any difference between Index scan & Table scan and Index seek & Table seek? Please give me some solutions.

If Yesterday, on the Server T-SQL statement was running fine but today it’s taking too much time. What is the reason? I don't know the relevant answer for this question. Can anybody give me the answer ?

Hi I am unable to start my SQL Server 2005 as its master db has damaged. I tried to rebuild & restore master db but failed every time. Please help me out I have backup of all system's Databases. How can I rebuild & restore the master db.