No problems Steve. I apologize...i think may i post in the wrong place.

But Steve..The principal doubt is

"Whenever an index is created, rebuilt, or dropped, disk space for both the old...

HI, i try to delete this post and change to performance and tuning...does not work so i change this post to Performance and tuning

http://qa.sqlservercentral.com/Forums/Topic694079-360-1.aspx

Please reply in this link

waiting......

I as the same question in a few months ago. ..When i start to use and understand a litte i see it´s a powerfull command shell.

My automated and monitoring...

I did something in powershell to do this

$ServerName = "Server1"

$DatabaseName = "Testes"

foreach ($path in Get-item "c:\projetos\teste\*.sql")

{

Invoke-Sqlcmd -ServerInstance $ServerName -Database $DatabaseName -InputFile $path

}

This script...

I dont know very well sqlcmd utility, i think its not possible (i really dnt know..we have to read the documentation and do some test).

But if not,

You can put...

Click Start, click Run, type gpedit.msc, and then click OK. The Group Policy dialog box appears.

Expand Computer Configuration, and then expand Windows Settings.

Expand Security Settings, and then expand Local...

You can save your script in .sql and the production team use sqlcmd to execute.

Lets say you have an update to do

use foodatabase

go

update table1 set foo = 'another foo'

then you...

Hi..

I start use powershell too to do this because i have some servers to monitor. But there is a "problem"...this script have to run every n minutes. So the OS...

A heap table is a table without clustered index.

This statment shows all heap tables in database

USE YourDB

GO

SELECT DISTINCT

= OBJECT_NAME(OBJECT_ID)

FROM SYS.INDEXES

WHERE INDEX_ID = 0

AND OBJECTPROPERTY(OBJECT_ID,‘IsUserTable’) = 1

ORDER BY

This tables have a clustered index or is heap tables ?..

Fragmentation in a clustered table is easy to resolve, just reorganize or rebuild you clustered index but in a heap...

If we see

Buffer Counts Buffers

------------------------------ --------------------

Committed ...

If you have some counter (identity..etc) in the table you can do this. Lets say the table

create table test (nID int, name varchar(100))

insert into test (nid,nome) values (1,'Row1')

insert into...

I have 19 servers and various databases. One of my monitoring is that and a little more. I use powershell and SMO to do this, they return to me this...

Thanks a lot. that is what i ´m looking for