Dutch should be no problem for me. It's my mother tongue :hehe:

Any ways, as a dba I'm used to mystic names :w00t: , not telling me what's the actual...

If it uses the index you intended to, and it is returning those columns at that point in the plan, it will have them from the index.

btw With SQL2005 you...

Henk Schreij (11/14/2008)

---

I need an index on a heavily used table with 10,000 + rows for using in a where clause.

Is, in addition to a distinctive column, including a...

Frequency ? That's entirely up to you :w00t:

Most of the time, system databases are small, so what's the space impact of an extra backup.

Backup frequency of the model db ?

Do...

I think you'll get the best grip about it when reading Dr. Codd rules for normalization.

here's an overview: http://www.sqlservercentral.com/articles/Advanced/coddsrules/1208/

If you include the system databases, be sure to put msdb at the end, because it contains all backup info.

We are using a single job for all our databases (daily)...

As always ... if you want order, you must use ORDER BY in the final select clause.

However, at insert time, an order by can have some influence, as stated in...

with SSMS, you can script the restore statement it will use. (use the script button after you've filled out everything you need.)

Can you script it to a new query window...

- what kind of error are you getting ??

- can you post the script ?

We always take backups to local disk, the xcopy the bak files to a UNC-resource (safezone).

If you've run out of disk slots to add more disks, you may even consider...

the scripts just checks if these startup parameters exist for your sqlserver instance,

and adds them if needed.

This way, the deadlock notifications in the sqlserver errorlog are always logged, even if...

am (11/6/2008)

---

can you please...

GilaMonster (11/6/2008)

---

Can you ask the users what exactly they mean by 'locking'?

3605 isn't required for deadlock graphs. Personally I find 1204 to be unnecessary if 1222...

Is this a migrated database from sql2000 ?

if so:

- rebuild all indexes

- sp_updatestatistics

- dbcc updateusage(0) with count_rows

and if you can ... dblevel to 90 !

add the following startup parameters to your sql instance.

This way you'll see in the sqlserver errorlog what statements are suffering

the conflict(s).

--dynamic activaton

dbcc traceon(1204, 1222, 3605, -1)

declare @MaxSQLArg varchar(50)

declare @NewSQLArg...