As stated by the other repliers, it doesn't seem to make much sense.

you can restrict login at ipaddress level using a server level trigger (sql2005 SP2 or higher)

but just keep...

what do you expect to be your third value in your in-list ?

Grant Fritchey (12/16/2010)

---

It's going to sound funny when I say this, but the sore throat must have something to do with how you speak. I really don't do anything in...

Chris Morris-439714 (12/16/2010)

---

That's an Abba song. Now I can't get it out of my head - darn, that's a Kylie song...we gotta get out of this...

Jeff Moden (12/15/2010)

---

...it's going to take about 4 hours (or more) of preparation time for each hour you're on the podium. If you have working code examples, it may...

SQL2008R2 CU4 doesn't fix the Windows2008R2 IO bug.

Here is a good resource to troubleshoot waits ...

http://www.sqlskills.com/BLOGS/PAUL/post/Wait-statistics-or-please-tell-me-where-it-hurts.aspx

If you can, apply the CU4 package.

-Is this on Windows 2008 R2 ?

If that is also the RTM version, you be hitting a known I/O bug:

my ref:

Hotfix Alert: Identifying...

Another thing that may be in the game is ...

What version of SQL2008 are you on:

Select @@version

Are you on SP2 yet ?

or is it SQL2008R2 without a cumulative...

Indeed, next time I'll actually plan breaks in my slides and have them taken !

I did have some twinkles in the stomach before the ppt, but IMO that's positive stress....

- did you prepare your migration using "Microsoft SQL Server 2008 Upgrade Advisor" http://www.microsoft.com/downloads/en/details.aspx?FamilyID=f5a6c5e9-4cd9-4e42-a21c-7291e7f0f852&displaylang=en

It may point you to potential issues.

- I didn't find a gap today to actually test...

Brandie Tarvin (12/15/2010)

---

Write down everything you learned from doing this presentation. All the "mistakes" you think you made. This will help you sleep, knowing that the list is saved somewhere...

Any advise on doing presentations (the thing, not the content) ?

http://www.sqlservercentral.com/Forums/Topic1034954-61-1.aspx

Thank you for the sympathy.:-D

Indeed: a good spoon or 3 of honey already did a good job, but there's still a long way to go.

There are a number of great articles on

- cursor avoidance:

-- http://www.sqlservercentral.com/articles/T-SQL/66097/

- RBAR avoidance:

--http://www.sqlservercentral.com/articles/Performance+Tuning/62278/

attached you'll find on one slide of the presentation I gave yesterday.

It was supported by the...

tsss, details ... details... :hehe: