steveb. (9/3/2010)

---

The trasanction log should not* affect the performance of the server.

Take regular t-log backups to manage you t-log and provide PIT restores.

for the performance issue you need to...

Forget it. I knew as soon as I asked on this forum I'd see the answer.

The second column is using the value set for the first column in it's...

I'm not that familiar with the internals of replication, yet, so I was hoping someone might know a "best practice" or "rule of thumb". Maybe it's just me but...

Thanks for your response. I would also think that having too many (whatever "too many" is) log reader agents could potentially cause problems as well. I think, like...

Nice question. You got me with the last SELECT setting the value to 1. I thought it returned 0.

I fall on the side that the content of the article is only loosely related to the title. (Is this that whole "loosely coupled" thing the SOA guys are...

I think the assumption I run into the most is data model related. The idea that you have to de-normalize your (OLTP) data model for "performance". Once upon...

dbowlin (7/9/2010)

---

One of the most common, and incorrect assumptions, I hear is that user is the enemy. Probably because so many users can be a pain in the backside.

Users...

I have a server used in performance testing and the test database is RESTORE'd before every test. Why does it appear that all of the DMV's have been reset...

Have you tried granting the user account that is running SQL Server the "lock pages in memory" right? This is a windows setting so it shouldn't matter whether you're...

Suresh Kumar-284278 (5/27/2010)

---

Hi,

Consider the below script.

declare @TblEmp table

(

EmpID int Identity,

EmpName varchar(50),

CountryId SmallINt)

Declare @TblCountry table

(

CountryID int Identity,

CountryName varchar(100)

)

insert into @Tblcountry values ('Japan')

insert into @Tblcountry...

I'll do that the next time I run a trace. We capture all of the PerfMon stats for our performance tests so I have literally months of data to...

Grant Fritchey (5/11/2010)

---

Robert Frasca (5/10/2010)

---

I applied the covered index to the Patient_Info_Fields table as a test on the client's machine and it made the problem go away. I've recommended...

I applied the covered index to the Patient_Info_Fields table as a test on the client's machine and it made the problem go away. I've recommended it as a low...

LOL! Doing three things at once and wasn't thinking.

INCLUDED Patient_Info_Field_ID and Field_Value and now it says it is using the index.

Unfortunately, it didn't really do anything performance wise as...