there is no catch block in your trigger. Is that how you intend it ? If so, don't use the try.

just my 2ct, to add to previous responders replies:

In your sproc, chances are filter arguments aren't sniffed to your advantage at query plan generation time.

Reason for that is you are...

check your sqlserver errorlog file to see what it is reporting about that database.

Keep in mind, you may have to process more than one errorlog file to get to the...

3ms is the tollerance for a datetime data type.

why are you using implict transactions.

as in most cases, taking control yourself, using explicit transactions ( begin tran .... commit/rollback )...

build up a solid view !

It's the combination that counts ... if it fits your needs and goals !

http://technet.microsoft.com/en-us/library/hh393576.aspx

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

http://sqlblog.com/blogs/kevin_kline/archive/2012/07/26/high-availability-white-papers-and-resources-for-sql-server.aspx

Gianluca Sartori (1/23/2013)

---

Great article, Erin.

Also, lots of useful code in there.

Thanks for sharing.

ALZDBA (1/23/2013)

---

Nice article, Erin.

In my test, [vs].[logical_volume_name] is blanc !

Win2008R2 / SQL2012DE (64-bit) SP1 (11.0.3000.0) with fixed...

Nice article, Erin.

In my test, [vs].[logical_volume_name] is blanc !

Win2008R2 / SQL2012DE (64-bit) SP1 (11.0.3000.0) with fixed drives.

So I suggest altering the last query to :

SELECT DISTINCT

...

This may be one of the cases where BOL is just wrong. :angry:

This does the trick you aim for:

Create default [MinusOne] as (-1);

go

/* Syntax error near Default --> CREATE TYPE...

as you will know Tempdb is a special db, available and used by everyone in the instance.

General usage of tempdb: http://msdn.microsoft.com/en-us/library/ms190768.aspx

Great post by Gail Shaw which highlights indexing and how...

if you copy/pated the statement in your previous reply ...

you typed dfault in stead of dEfault.

Chances are you overlooked the typing error.

it will write tempdb stuff to disk all right, it's just not at checkpoint time, like with regular db.

Why: tempdb is re-created every time SQLServer is started, so there is...

did you check with books online ?

Create type:

http://msdn.microsoft.com/en-us/library/ms175007(v=sql.105).aspx

My advice: Avoid like hell because they cannot be altered when they are in use. It's not all gold that shines

IMO it should return no row at all because of the where clause condition 1 = 0

With such findings, it is best to always mention the actual engine version on which you performed the test.

Select Serverproperty('ProductVersion') as ProductVersion

, Serverproperty('ProductLevel')...

Here's a good article to help you to get to your answer: SAN Replication vs. Clustering vs. Mirroring Which should be used when? by Denny Cherry.

It also contains an interesting...