You should run a complete suite of SQLIO tests on the current and new servers and compare the results. Sequential read, sequential write, random read, and random write at...

Yes, but you should still set a strong SA password, and make sure...

I doubt that having a clustered index on the identity column is the cause of the deadlocks.

You need to analyze the deadlock information in detail to determine exactly what resource...

Copying an 80 GB compressed backup to the cloud using an 8 Mbit/Sec upload speed would take at least 28 hours, so I don't see that being practical at least...

Sean Lange (9/6/2013)

---

Michael Valentine Jones (9/6/2013)

---

It might be more valuable if you explained the implications of changing the default database, and especially the disadvantages of having a default database that...

It might be more valuable if you explained the implications of changing the default database, and especially the disadvantages of having a default database that is not master for an...

It is only meant to be used for very short term storage of the data, maybe 2-3 days.

I believe the default retention is 3 days.

Eastern Daylight Time (EDT) is UTC (GMT) -4 hours

Eastern Standard Time (EST) is UTC (GMT) -5 hours

You should be able to find all the information you need here:

Daylight Saving...

Sanz (8/21/2013)

---

Sure 🙂 But can you explain this as we are having problem with some developers arguing that physical reads are the one to be looked for and we can...

Scott Milburn (2/27/2013)

---

I have four tables that have a varchar data type which gets imports or daily user updates and this field is an account number field which always has...

ScottPletcher (8/20/2013)

---

Michael Valentine Jones (8/20/2013)

---

taigovinda (8/20/2013)

---

Hi,

My database has a bunch of tables on it that have no indexes at all on them. I want to add indexes to these...

taigovinda (8/20/2013)

---

Hi,

My database has a bunch of tables on it that have no indexes at all on them. I want to add indexes to these tables but I am...

This also works:

select

Curr_Datetime= getdate(),

[Curr_Datetime Plus 05:25] =getdate()+'05:25:00.000'

Results:

Curr_Datetime Curr_Datetime Plus 05:25

----------------------- ------------------------

2013-08-09 14:52:58.457 2013-08-09 20:17:58.457

Jeff Moden (8/8/2013)

---

Koen Verbeeck (8/8/2013)

---

Sean Lange (8/8/2013)

---

Koen Verbeeck (8/8/2013)

---

Hmmm,...

Works as expected for me.

BEGIN TRAN

BEGIN TRY

create table #temptable

( n1 int not null, n2 int not null,...