TheSQLGuru (5/8/2013)

---

Here is an interesting solution that could be more efficient (didn't test that):

select

DT,

CAST(dt AS decimal(29,15))*86400 AS decdtsec2,

SecondsSince_19000101 =

-- seconds for whole days

(datediff(dd,0,a.DT)*000000000086400)+

-- seconds since start of...

I think that you will find that dynamic SQL with sp_executesql almost always gives you the best performance.

The more optional parameters you have, the more likely it is that there...

Jeffrey Williams 3188 (5/8/2013)

---

Michael Valentine Jones (5/8/2013)

---

select

DT,

SecondsSince_19000101 =

-- seconds for whole days as bigint

(datediff(dd,0,a.DT)*000000000086000)+

-- seconds since start of day

datediff(ss,dateadd(dd,datediff(dd,0,a.DT),0),a.DT)

from

( -- test data

select DT = getdate()union all

select DT = '99991231 23:59:59.997'union...

select

DT,

SecondsSince_19000101 =

-- seconds for whole days

(datediff(dd,0,a.DT)*000000000086400)+

-- seconds since start of day

datediff(ss,dateadd(dd,datediff(dd,0,a.DT),0),a.DT)

from

( -- test data

select DT = getdate()union all

select DT = '99991231 23:59:59.997'union all

select DT = '18991231 12:01:01.997'union all

select DT =...

You were asking if it is supported, so Microsoft is the only one that could really make that call.

My guess is that they will tell you it is not supported,...

Here is a solution using the ROUND function:

with test_data_cte as

(

select datavalue

from

(

values

(5.0000016), -- should be 5.01

(6.1000138), -- should be 6.11

(7.1200073), -- should be 7.13

(5.0000000), -- should be 5.00

(6.1000000), -- should be...

It would be best to do a shrink to the target size that you want to get the database file to, and then run a reindex or reorganize on all...

You should really ask Microsoft Support about that.

Scott Costello-401147 (5/6/2013)

---

Lynn,

Thanks so much for the reply. If I try and restore the FULL and then the DIFF for April 18th (skipping all the differentials between) I get...

If you are on a domain, a normal way to handle this is to have the Web server service account connect to the database server.

1. Create a role in the...

mah_j (4/28/2013)

---

Hi

I have a table with a clustered index and 6 non clustered indexes.The size of the table is 400G and logical fragmentation of the indexes are above 90%.

We...

You need to have a basic repertoire of networking jokes.

1. I know a great joke about UDP, but I'm not sure you'll get it.

2. I've got one about TCP packet...

If that is the actual table structure, there seems to be no reason for the foreign key reference, since it is the primary key referencing itself.

At least you won't get...

bugg (4/19/2013)

---

Michael Valentine Jones (4/19/2013)

---

Since you are getting deadlocks between a select and an update, you can probably eliminate the problem by setting the database to use row version isolation...

Since you are getting deadlocks between a select and an update, you can probably eliminate the problem by setting the database to use row version isolation (Read Committed Snapshot)

use master;

alter...