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

Your right , without a witness server the mirror would not know what actions to perform in the event of a failure. In these cases its assumed the DBA would...

this topic has been discussed previously

http://www.sqlservercentral.com/Forums/Topic1125761-1292-2.aspx#bm1134043

High safety with automatic fail over would give you DR similar (not exactly)to that of clustering so why not use it ? Whats the exact DR scenario your...

try this

set @tablename = CHAR(37)+'ticker'+char(37)

select @tablename

SELECT DISTINCT o.name, o.xtype FROM syscomments c INNER JOIN sysobjects o ON c.id = o.id WHERE c.TEXT LIKE @tableName

are you not able to use it like this

declare @Tablename varchar(10)

set @tablename = 'tablename'

SELECT DISTINCT o.name, o.xtype FROM syscomments c INNER JOIN sysobjects o ON c.id = o.id WHERE...

Thanks this is exactly what I was looking for.

This is the way of operation for High safety mode. That guarantee from the mirror that the transaction is committed is what gives the safety , if this bothers you...

You could dynamically script the grant execute command and execute it as part of a DDL trigger for the database.

Create A DDL trigger which will detect any create procedure...

My post meant that when using a 32 bit install of sql you need to enable AWE to address additional memory and in order to enable AWE you need to...

look up this article

http://msdn.microsoft.com/en-us/library/aa259622%28v=sql.80%29.aspx

I guess the key here would be are you inserting rows with older dates into the date column, if you can garuntee that all dates inserted will be sequential in...

Keeping the post alive 😀

The fact that the select is returning data faster , the chances are your facing blocking issues during the update.

I agree having data in memory is a good thing but we need to be careful of the type of system for an OLTP system this works great and usually...

Would the above recommendations hold even for partitioned tables ? Keeping in mind the unique role of the column that stores the partition key