WRACK (2/19/2012)

---

* Sets some database to Simple Recovery Model

* Sets AUTO UPDATE STATISTICS on some...

per BOL page on sys.all_columns:

2 bytes = 1 NCHAR

200 bytes = 100 NCHAR's

I'm not sure of your issue, do *some* client connections timeout or do *all* client connections timeout when on the troublesome node?

What does

select @@version

return on each node?...

Soren Nielsen (1/4/2012)

---

Hi all

I'm looking for some feed back in regards to the below mentioned challenges. In our organisation we have over the last 5 years mainly done scale up,...

I believe you're looking for a "Table Valued Function"

Select

i.item,

i.warehouse,

f.openOrders,

f.openPurchases

from...

task manager lies (maybe resource monitor does as well)

check the sql server perfmon counters for memory allocation or use process explorer from the sysinternals suite (procexp.exe) to gain a better...

Trial and error.

The lower the fill factor, the slower the index will fragment but larger the index will be.

what percentage of new data is added on a weekly...

Are you doing individual insert statements, or a bulk copy?

itsamarnath (12/13/2011)

---

I am seeing a lot of these messages in sql server error logs

2011-12-11 03:27:34.15 Server All schedulers on Node 0 appear deadlocked due to...

So, every other day you alternate between adding to the same backup file and creating a new one? i.e. 200GB, 400GB, (delete), 200GB, 400GB?

Am I missing something?

Just to clarify what you're asking:

You have a database that you wish to have copies of on multiple other servers. These copies need to always be available for querying (select...

This is the least flexible way to do it:

case month when 1 then 'January'

when 2 then 'February'

when 3 then 'March' --etc

end MonthName

You'll need strong SQL querying skills if you want to get into a Database postion (analyst, devloper, dba, etc). The stronger the better. You can find...

Greg Edwards-268690 (12/9/2011)

---

bruce.l.pettus (12/9/2011)

---

I'm in the process of implementing a solution so I'm not entirely confident I'm correct; however, I wanted to point out an issue with the SPN comment.

To...

Hey Kenneth,

Thanks for your reply. I apologize if my original post seemed harsh, I've fought some extremely frustrating battles with kerberos in the past and want others to avoid...