Jeffrey Williams-493691 (2/11/2010)

---

Michael Valentine Jones (2/11/2010)[h]I was aware of that potential problem, and that is why I used the REPLACE to remove the - characters from the date to change...

Jeffrey Williams-493691 (2/11/2010)

---

Michael Valentine Jones (2/11/2010)

---

As other people have suggested, you would be better off using a datetime column.

This will verify the correct format and ensure that it is a...

As other people have suggested, you would be better off using a datetime column.

This will verify the correct format and ensure that it is a valid date.

ALTER TABLE dbo.MyTable

CONSTRAINT CHK_MyTable__MyDateCol

CHECK

(

case

when...

An additional thing I always look at is maintenance windows.

If you need down time to install OS patches, run diagnostics, etc., you don't want a mix of applcations on a...

We have about 50 SQL Servers on VMs, mostly production, but some are development. We do not generally put highly loaded servers on VMs, but they are great for...

You should check to make sure the location you are backing up to has space available.

I think you are ignoring the cost of what happens when you insert the data.

I think it would cause intense fragmentation of the index if you inserted a sequentially increasing...

I'm not sure you clearly explained your requirements.

Do you want to push to next Monday at 9:00 am always, or only when it is Saturday or Sunday?

The code...

You should be aware that you cannot use a file or filegroup backup to recover a table to a different point in time than the rest of the database.

Has anyone figured out the parameter sequence to restore a database that doesn’t exist from an alternate timeline where it would have existed if the development project hadn’t failed?

If you really need to do something like this, you don't need to worry about transactions if you use the OUTPUT clause of the UPDATE statement to return the new...

Prakash Heda (2/3/2010)

---

Michael Valentine Jones (2/2/2010)

---

Since the deadlock victim is the select, there is a good chance that setting the database to READ_COMMITTED_SNAPSHOT will prevent the deadlocks and it will...

If the file is fixed format (not delimited between columns) you could load the file into a table with a single column, and then create a view on the table...

Since the deadlock victim is the select, there is a good chance that setting the database to READ_COMMITTED_SNAPSHOT will prevent the deadlocks and it will not require any coding changes.

You could add this to the proc to make sure all the tables are created by the dbo user.

ALTER PROCEDURE [dbo].[pGetItemLot] @item char(5),

@lot char(20),

@desc char(50)output

with execute as 'dbo'

as

...

rest of proc

...