Carl Federl (10/19/2010)

---

Windows:

Insure that "Maximize data throughput for network applications" is set instead of the default of "Maximize data throughput for file sharing"

Grant the SQL Server service account the following...

Is it worthwhile creating a new column that removes the repeated portion of data?

Is it even worthwhile storing the repeated data if its the same for every row?

Try this

The general recommendation for using FileStream is average file size larger than 1MB.

I do that a fair bit as well :hehe:

Double clicking a script file to open in SSMS and just running it... normally against the wrong server :pinch:

sadly it is......

at my previous place, I was on good terms with my management, so would...

I dont know anything about the EMC hardware, but if they use battery pack on the array, check if the battery has failed. If the battery fails, the array controller...

Sadly, I had a junior DBA do the same thing... after that, needed to come with a way of stopping it. So had 2 options:

- Windows authentication for SQL...

SPNs and Kerberos... the HOST SPN might be wrong...

Is it a new install of SQL?

Are you using delegated security?

What does the LAG function in Oracle do? There might be an equivalent SQL function, with a different name.

GilaMonster (10/10/2010)

---

Log files plural? Multiple DBs I assume.

P - PageFile - I think this is quite a biggie and one that is normally forgotten...

PaulB-TheOneAndOnly (10/8/2010)

---

grahamc (10/8/2010)

---

PaulB-TheOneAndOnly

since you have it running... does that mean if you have a RAC environment running, that if you are hitting performance problems that a shiny new server...

One of the links I read - found in my history...

and what does the data look like? sample?