sqldba_icon (2/1/2011)

---

I need to check but could...

Here's a video on how to post an execution plan to SSC.

Absolutely.

I thought of another one too, you need to make sure you're using the same parameters in the test environment that you do in production. That will help to ensure...

I was also going to suggest doing a complete rebuild of all statistics, preferably with FULL SCAN.

I know there are some areas where performance degrades on upgrading servers from 2000...

Kwisatz78 (2/1/2011)

---

Hi

I am wondering about the accuracy of placing a copy of production into a test environment. If I do this will the query plans also be copied or...

sql_butterfly (2/1/2011)

---

select A.Field1, A.ImportantDate, A.FirstTime

from T1 A

INNER JOIN (select Field1, max(FirstTime) AS FirstTime from T1

group by Field1) B

on A.Field1= B.Field1

and A.FirstTime = B.FirstTime

ORDER BY B.Field1, B.ImportantDate, B.FirstTime

Basically I'm...

I didn't even notice that you were talking about UDFs. Assuming you're talking about multi-statement table valued UDFs, my best advice, avoid them like they have AIDS, because, effectively, they...

If I were running the interview I'd want to hear a lot more than just that you'd taken the tail backup. I'd want to know which backups you had to...

We've been running with Read Committed Snapshot on several systems, and while there is a bit of an impact on tempdb, the reduction in locking and blocking more than made...

SalvageDog (2/1/2011)

---

Hello,

Thanks for a great article.

I have a very intermittent problem, occurs only two or three times a month. Would there be any issues with running a server side...

rob mcnicol (1/31/2011)

---

great article, thanks.

what tweaks to this process are required to run a server-side trace on analysis services? when i export my Script Trace Definition, the 'For...

aMSDeveloper (1/31/2011)

---

Hi

We have a clustered environment and the important database is mirrored. It is a highly transactional database. We also have a RO (Read Only) environment which is also clustered...

ALZDBA (1/31/2011)

---

Oh yes ... Grant has sql plans 😉

Grant has a...

WayneS (1/31/2011)

---

So... what's your favorite data modeling tool?

Starting a new job today... I get to use whatever tools I want. I've used ERwin and PowerDesigner in the past. IMHO, ERwin...

I'm not sure, but I frankly wouldn't worry about it. Perfmon is where you should be collecting that data.