-- Convert time in milliseconds since 1970-01-01 to datetime

declare @MSTime bigint

set @MSTime = 1276548319093

select DT = dateadd(ms,@MSTime%86400000,(@MSTime/86400000)+25567)

-- Convert datetime to time in milliseconds since 1970-01-01

declare...

The model database is usually so small that you should just back it up at the same time as the other system databases. My preference is to ceate a...

You can use the DATEDIFF function to convert the time to integer seconds and then sum that up.

select

Duration_Seconds = sum( datediff(ss,0,x.call_duration) )

from

MyTable

yb751 (6/21/2012)

---

Michael Valentine Jones (6/21/2012)

---

In conjunction with this, they could have the web application query the table using the snapshot isolation level (or set the database to read committed snapshot)...

Lynn Pettis (6/21/2012)

---

Assuming that you are doing this update in a stored procedure, I would do something more along the lines of this psudo code:

... prep work

set transaction isolation level...

Perry Whittle (6/21/2012)

---

Michael Valentine Jones (6/20/2012)

---

You could just make things simple and execute this in your database every night:

execute sp_updatestats

sp_updatestats (Transact-SQL)

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

"...sp_updatestats updates only the statistics that require updating based on...

Thomas Stringer (6/20/2012)

---

Michael Valentine Jones (6/20/2012)

---

You could just make things simple and execute this in your database every night:

execute sp_updatestats

sp_updatestats (Transact-SQL)

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

"...sp_updatestats updates only the statistics that require updating based on...

You could just make things simple and execute this in your database every night:

execute sp_updatestats

sp_updatestats (Transact-SQL)

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

"...sp_updatestats updates only the statistics that require updating based on the rowmodctr information in the...

They...

Cadavre (6/11/2012)

---

My apologies, it was never my intention to kick off this little storm :blush:

--edit--

Having read through it all, I think it all started due to my laziness in quoting...

IDENTITY is not meant to maintain an unbroken sequence. It is only meant to quickly produce a new unique value that is higher than the last one that was...

When you run SQLIO tests it is important to make the test file size large enough that you get a true test, especially for random read and random write, to...

GilaMonster (6/9/2012)

---

That would be a huge amount of work. You would need to:

Drop all indexes

Drop all foreign keys

Drop all primary keys

Convert all columns in all tables, one at a time...

What is the actual format of the strings that you are trying to convert to datetime?

Let SQL Server do the work for you.

Just automate the whole thing using a Maintenance Plan to make a full backup at night using a SQL Agent job and automatically...