Matthew Darwin (3/15/2012)

---

The problem looks to be the predicate for your scan is using CONVERT_IMPLICIT for your dealer_id and account_no.

I'm guessing this is being caused by the difference in collation...

Admingod (3/6/2012)

---

Actually server is 2005 32 bit enterprise and Windows server is 2003 SP2 enterprise(my understanding is 32 bit enterprise will take max memory of OS without need to enable...

Admingod (3/6/2012)

---

Actually server is 2005 32 bit enterprise and Windows server is 2003 SP2 enterprise(my understanding is 32 bit enterprise will take max memory of OS without need to enable...

atchristian (3/6/2012)

---

We have 48GBs of RAM and 38 of that is dedicated to SQL (nothing else runs but I wanted to leave some breathing room).

The processors are Xeon E5645...

atchristian (3/6/2012)

---

Hello,

We recently built a new machine to host our SQL database. This new machine contains dual processors (our old machine was a single processor). Since we have made the...

GilaMonster (2/27/2012)

---

Create a new nonclustered index (AllocatedByID, JobStateID) INCLUDE (JobID)

Should completely prevent the deadlocks.

This is what's can be called a key-lookup deadlock. The select takes a lock on the nonclustered...

GilaMonster (2/27/2012)

---

Switch traceflag 1222 on. That will result in a deadlock graph been written to the error log every time a deadlock occurs. Post the result of that graph here.

DBCC...

We use psftp or curl .. they are free and does the job well.

Just use the script task in SSIS .. and get the job done 😀

anthony.green (2/23/2012)

---

you would want to bring the DB's online so you will have to issue a command to each DB with the WITH RECOVERY statement and then resolve any issues...

anthony.green (2/23/2012)

---

you would want to bring the DB's online so you will have to issue a command to each DB with the WITH RECOVERY statement and then resolve any issues...

20 per instance and 3 instance per server.

It will sound like a lot .. but the hardware is Dell R710 with plenty of memory and we have tested before implementing...

NOLOCK will result in...

NOLOCK will result in...

Lowell (12/16/2011)

---

if the integer was something like 40891, we could infer that it was 40891 days since the beginning of SQL time, which would, by coincidence, be today (12/16/2011.

without a...

Thanks Lowel !

But my problem is that the data is integer and I get it as 465, 356, etc .. I need to convert it into meaning full data.

I guess...