1. Firstly it's better do not mixed up primary keys with indexes, they have different purposes.

A clustered index defines the physical order of rows in a table, while a primary...

Is the SSIS service running? Is the remote connection enabled (SAC utility)? (If you use developer edition, it's not enabled by default.) Do you have enough permissions to create maintenance...

It's possible your login cannot see them. I'm not sure which sql version you're running; for 2005 try this

use master

go

GRANT VIEW ANY DEFINITION TO login_name;

go

The system procs are under the...

Clustered index should be defined on columns that monotonically increase especially if the table is subject to many INSERTS, UPDATES, and DELETES.

If a table is subject to...

Check whether the sql server service account has "lock in memory" permission.

You can assign a cpu using affinity mask option (see BOL)

Good luck

More details would be appreciated. As much I can understand, u have a sql sp with 2 input params that needs to access an excel function. Is this the case?

Being a bulk operation, you can use VBScript in a SSIS/DTS package:

Script: Retrieves user account attributes found on the Account page of the user account object in Active Directory...

Check first if you enabled the SAC settings for database engine from the Windows 2003 R2 server (x64) and not for your local installation;

Then if the sql server runs on different...

It's actually not clear what would you like to achieve with this trigger; Probably you look for:

...

INSERT into HumanResources.JobCandidateHistory(

JobCandidateID,Resume,

ModifiedDate)

select JobCandidateID,Resume, ModifiedDate FROM deleted

Probably adjusting your database data files size would be of help:

ALTER DATABASE [dbName] ON  PRIMARY

( FILENAME = N'...location\dbName.mdf', SIZE = (...) KB)

LOG ON

( FILENAME = N'...location\dbName.ldf', SIZE = (...)...

When you start SQL Server, SQL Server memory usage may continue to steadily increase and not decrease, even when activity on the server is low. Additionally, the Task Manager and...

When designing a set of tables that would be related by usage then a permanent relation should be defined between them (Grasshopper): create tblSales.FruitID as FK for tblFruit.FruitID(PK)

Then you...

You cannot use "<" into a column name.

CREATE TABLE [dbo].[tTest](

 [tcolumn] [varchar](20)

) ON [PRIMARY]

GO

insert into dbo.tTest (tcolumn) values ('adfd18')

go

declare @sqlString as nvarchar(100)

declare @var as int

set @var=18

set @sqlString='select tcolumn as  cvrLessThan'+ltrim(cast(@var as...

Firstly, if you are using SQL 2005 then you should use "Activity Monitor" (under Management) for keeping track of the locks, waits/wait types, blockings, CPU, memory etc.

For checking any long running...

Sorry, you cannot see all top 1 balance values with the previous script.

SELECT distinct t1.cia,t1.Emple,t2.balance

into #temp

FROM dbo.tblTest t1

left outer join (select top 1 emple,balance from dbo.tblTest t3 where t3.date_dd<='20061031' and...