Viewing 15 posts - 76 through 90 (of 99 total)
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...
April 9, 2009 at 9:22 am
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://www.sqlservercentral.com/Forums/Topic694079-360-1.aspx
Please reply in this link
April 9, 2009 at 8:55 am
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...
April 8, 2009 at 11:43 am
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...
April 8, 2009 at 11:26 am
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...
April 8, 2009 at 9:07 am
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...
April 8, 2009 at 4:36 am
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...
April 8, 2009 at 4:28 am
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...
April 7, 2009 at 5:56 pm
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
April 7, 2009 at 8:21 am
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...
April 7, 2009 at 3:38 am
If we see
Buffer Counts Buffers
------------------------------ --------------------
Committed ...
April 7, 2009 at 3:10 am
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...
April 7, 2009 at 2:07 am
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...
April 7, 2009 at 1:39 am
Thanks a lot. that is what i ´m looking for
December 29, 2008 at 3:46 am
Viewing 15 posts - 76 through 90 (of 99 total)