Hi,

I assume that the drive fails.

If you have to install all the environment (install sql server, restore the master, msdb eventually distribution), then you have at the end, restore the...

Hi,

Check the following link http://www.sql-server-performance.com/articles/per/event_logs_dumpevt_p1.aspx

Regards

Ahmed

hi,

I know three kinds of DBA:

- DBA for who all things are going well, so he spend all his time learning, preparing himself for certifications.

- DBA who is doing...

Hi,

May be this could help http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=252730&SiteID=1

Regards,

Ahmed

Hi,

See the following:

http://www.sqlservercentral.com/articles/Administering/movingsystemdatabasesachecklist/1608/

http://www.webpronews.com/topnews/2004/12/10/sql-server-hardware-performance-checklist

http://www.code-magazine.com/Article.aspx?quickid=070133

Regards,

Ahmed

Hi,

It sounds like you are backing up to a networked drive/location, check to see if the mapped drive is still available if not re-map.

And see the following post

Hi,

Just as a hint when you execute select isnull(submitdate,0) as submitdate from Borrowers008 and submitdate is null

the result will be 1900-01-01 00:00:00.000 instead of 0.

So I suggest to put...

Hi,

U can use the following:

Create Proc getAllFN

AS

Set Nocount On

Declare @dbName as sysname

Declare @Query as varchar(200)

Create Table #sys_all_objects

(dbName sysname null

,name sysname

,object_id int

,schema_id int

,principal_id int

,parent_object_id int

,type ...

Hi,

I think you will find the receipe in this link http://blogs.msdn.com/sqlserverstorageengine/archive/2006/06/06/619304.aspx

Regards

Ahmed

It's ok, when Sql Server is restarted.

So if we find a value of BytesWritten/BytesRead inferior from the one of yesterday, it means that sql Server has been reset.

Ahmed.

Hi,

Generally the primary key is the clustered index (just one clustered index per table).

Take a look at http://www.sql-server-performance.com/articles/per/index_data_structures_p1.aspx

Ahmed

Hi Ten,

Thanks for your reply

I have just a couple of sp_executesql (just select statments), I don't use an update or an other cursor.

Ahmed.

Thanks to all,

Like vidhya sagar said There are some more system databases Reportserver and distribution (which also can be renamed).

so using db.name in ('master','model','msdb','tempdb') is not the efficient...

Hi TheSQLGuru,

It sure, you're rigth 🙂 after converting the Ins to equals, it will be recommend to use the index tuning wizard. After you can you the profiler, yo want...

Hi,

In a test environment, take the query in the query analyzer then run (Index Tuning Wizard), it will recommend you creating/droping indexes.

Ahmed