The sys.index_columns view is utilized because it gives me the ability to join to the key_constraints view to see if the identity column is a primary key or not. ...

Do you still need something for this? I am working on a script that can be ran continuously (sql agent job) that will monitor executing queries and analyze their...

This article may be helpful for your problem.

http://sqlprosperity.com/post/SQL-Server-quasi-real-time-performance-monitoring

It has helped me a lot to identify what processes are causing blocks without having to be on the server querying...

I found the solution at:

http://stackoverflow.com/questions/4408336/system-runtime-interopservices-comexception-0x800a03ec

From site:

"The solution is to plug the difference between the way Windows 2003 and 2008 maintains its folder structure, because Office Interop depends on...

replication solutions wont work because developers will be making changes to the dev environment, so once they change something then the databases are no longer in sync. Nightly backup...

Hope this helps

/*Example table to be updated (e.g. your 10GB table) **************/

--DROP TABLE table1

CREATE TABLE table1(tableID INT IDENTITY(1,1) Primary Key, field1 varchar(50),UpdateField varchar(50))

GO

INSERT INTO table1(field1)

SELECT newid()

GO 50

SELECT * FROM table1

/****************************************************/

/******explanation...

I typed logic wrong, but it demonstrates how to do it.

(DT_STR,50,1252)(band == "C1" ? "Developer" : band == "C2" ? "Tech Lead" : "Something Else")

I added the string conversion "(DT_STR,50,1252)" incase you are inserting into a varchar field. If...

Check for blocking in sys.dm_exec_requests. I have ran into situations where fast DML operations slowed down dramatically and not always, but frequently it was blocking. Since...

A few places to start with troubleshooting.

- Check for blocking in sys.sysprocesses or sys.dm_exec_requests

- launch perfmon and look at Avg. Disk Queue Length.

Dont pay attention to size of number...

If the primary key is an identity and its the clustered index, you could loop through and update records 1 at a time. Each update the where clause would...

DECLARE @RoomBookings TABLE(

RoomType varchar(6),

ArrDate DateTime,

DepDate DateTime

)

INSERT...

Always try to use LEFT JOIN (or RIGHT) instead of NOT IN or NOT EXIST. LEFT JOIN is going to have faster performance.

insert into tblClientList (clientNumber)

SELECT a.clientNumber

from tblOrder ...

rather then executing straight from the file, you could import the file into a table then execute the statements dynamically from the table. Using SSIS the 5GB file would...

IF all you want is the top error...

SELECT TOP 1 errid, errorCode, severity, description, occurred

FROM mfRepositoryErrors

ORDER BY errid desc

I am assuming there is a clustered index on errid, otherwise...