make sure that you have clustered index on almost each tables .

Rebuilding clustered indexes can free up unused space from your db ..

that still depends upon DB size,as you can...

its always good idea to write drop statement in your sp.

However temp tables gets automatically dropped when you close your Query window .

Me too !!

you should have clustered index on every table .

that is what they called as best practice.

data is not organized properly in heap tables (tables without clustered index)

http://msdn.microsoft.com/en-us/library/hh213609.aspx

you can schedule Differential backup according to your environment ,

it can reduces your restore steps.

2. No ,you can not ..not sure if any third party tool available for it.

for...

you should post it in iphone forum.

no problem with your sql serevr

May be it will boost your performance,

you can create index on varchar which is not possible on ntext.

but still it depend upon the length of you data.

For BIDS ,you have to run Enterprise,Standard or Developer edition of sql server and then you can select the component you want to install.

http://social.msdn.microsoft.com/Forums/en-US/sqldataaccess/thread/fba94ec7-ed6f-4a8b-b028-1f5d62baa5ed/

i dont think so...

he is asking about tempdb log file not data file.

by restricting log file it will get reuse if there any inactive portion at the start of the...

the scriptprovided by BriPan works perfect for me .

do not provide any dbid in script. just add one step

use 'YourDatabaseName'

go

select a.*,b.AverageFragmentation from

(

SELECT

tbl.name AS [Table_Name],

tbl.object_id,

i.name AS [Name],

i.index_id,

CAST(CASE i.index_id WHEN 1...

your running it on master database ...

select your database then run Query

can you please post the Query.

is it linked server related query ?

use union

SELECT name as DBName,[crdate] AS [LastStartupDate]

FROM [Server2].[master].[dbo].[sysdatabases]

where name='tempdb'

union

SELECT name as DBName,[crdate] AS [LastStartupDate]

FROM [Server3].[master].[dbo].[sysdatabases]

where name='tempdb'

you have scheduled transactional log backup then why there is job for truncate log file :blink: