Your code works, provided the date is...

The following links have functions that will find the start of Century, Decade, Year, Quarter, Month, Week, Day, Hour, 30 Minutes, 20 Minutes, 15 Minutes, 10 Minutes, 5 Minutes, x...

Did you change the database where you are still seeing the deadlocks to Read Committed Snapshot?

This doesn't sound like a very good plan if you are just going to update the partition column, since it would force the data to move physically form one disk...

Revenant (12/5/2011)

---

Michael Valentine Jones (12/5/2011)

---

Michael Valentine Jones (12/3/2011)

---

The worst abuse is when they set short project deadlines without any attempt to match the workload to the available staff, and then...

Refer to the Litespeed help for other options:

-- Sample Litespeed Database Restore Command

exec master.dbo.xp_restore_database

@database = 'MyDBName'

, @filename = '\\MyServer\MyShare\MyDirectory\MyDBName_db_201111060700.BAK'

, @with = 'stats = 5'

, @with = 'NORECOVERY'

, @with = 'move...

Michael Valentine Jones (12/3/2011)

---

The worst abuse is when they set short project deadlines without any attempt to match the workload to the available staff, and then expect people to work...

The worst abuse is when they set short project deadlines without any attempt to match the workload to the available staff, and then expect people to work extremely long hours...

That code is sensitive to the setting of DATEFORMAT. In the...

You might find the function on the link below useful for what you are doing.

Finding the midpoint between two datetimes

The function in this script finds the midpoint in time...

There is a very good chance that you can eliminate the deadlocks without making any code changes by setting the database to read_committed_snapshot.

ALTER DATABASE [MyDatabase] SET READ_COMMITTED_SNAPSHOT ON;

You should read...

There is a good chance that you will not see any performance improvement from physically defragging the database files.

If you still want to, you can use Diskeeper to defrag the...

This is probably the fastest and shortest method for finding the last day of the month, given the year and month as integers, since it uses only a single DATEADD...

No, you would need access to the source code repository that was used to build the assembly.

Just to make sure you understand a couple of points:

1. Dynamic SQL (including sp_executesql) is not allowed in a TSQL function. If you need to use it, code it...