Very valid questions, but since you are planning on moving database files, (parts of ) your db will be offline for a while (to be able to actually move the...

I tested this script:

USE [msdb]

GO

/****** Object: Alert [DBA_LockingTreshold] Script Date: 04/15/2011 08:30:59 ******/

IF EXISTS (SELECT name FROM msdb.dbo.sysalerts WHERE name = N'DBA_LockingTreshold')

EXEC msdb.dbo.sp_delete_alert @name=N'DBA_LockingTreshold'

GO

EXEC msdb.dbo.sp_add_alert...

"after" is always to late.

We create windows groups for that get the needed access auth on our dev instances. A devs login will only need to be added to that...

A connection will be registered until the client disconnects ( or if connection pooling is enabled, until it is released from the connection pool (I think this timeout value defaults...

zygonr (4/14/2011)

---

Hi Pat,

I have question, I see the query which you have provided gives us the value of Target SQL server memory in cntr_value.

How do I convert it to...

I find this article very helpful:

"A Small Collection of I/O Specific DMV Queries"

http://glennberrysqlperformance.spaces.live.com/blog/cns!45041418ECCAA960!2991.entry

By Glenn Berry

There is also a WP to help understand what's going on:

WP SQL2005 Performance_Tuning_Waits_Queues.doc

And for refs I...

How long since the box has been rebooted and how big the db size to be loaded.

Are your indexes fragmented ?

In that case, your engine will need to perform...

With any 64-bit install of sqlserver you must set the max server memory configuration setting for the instance! or it will eat up all your ram.

Set it to an acceptable...

Can you elaborate on how you did configure and are using the alert ?

One thing you can do with your current setup is alter the where clause.

This way, if there is an index on your column StartOnCalldate in...

Andy also commented wonderful on his blog:http://sqlblog.com/blogs/andy_leonard/archive/2011/04/14/recruiting-sql-server-database-professionals.aspx

Another confirmation of your article being very valid !

IMHO your query points to a design flaw.

There is no way this kind of queries will be able to produce a well performing query, based on datetime data, just because...

Grant Fritchey (4/14/2011)

---

Craig Farrell (4/14/2011)

---

Alright, there's any number of things to take my article apart for, half of it's an opinion... but there's vs. there are?

I'm going to assume I'm...

Jeff Moden (4/14/2011)

---

Grreat article, Craig. If people actually study what you wrote, they'll be able to spot and separate the "dream jobs" from the "jobs for Bob" from the...

Craig Farrell (4/14/2011)

---

Alright, there's any number of things to take my article apart for, half of it's an opinion... but there's vs. there are?

I'm going to assume I'm just too...