A little bit of feedback / progress would be welcome. :blink:

Please do keep in mind we don't want to give you a hard time by not just giving you...

You are using SQLusers that have another internal id on the sqlinstance that hosts your stand-by database.

If these accounts are only supposed to use that database, you could try to...

Brandie Tarvin (5/11/2011)

---

Shameless self-promotion moment, for which I will probably get thwacked. @=)

The Science Fiction and Fantasy Writers of America (SFWA) will be in Washington D.C. on May 20th, doing...

GilaMonster (5/10/2011)

---

ALZDBA (5/10/2011)

---

Steve Jones - SSC Editor (5/10/2011)

---

Just rated some sessions for the PASS Summit. This has to be one of the poorest implementations of a rating tool I've seen,...

GSquared (5/10/2011)

---

Gail, sent four devs to your Catch-All Queries blog entry today. Thanks again for writing that. They all got it and one even got excited about it....

Steve Jones - SSC Editor (5/10/2011)

---

Just rated some sessions for the PASS Summit. This has to be one of the poorest implementations of a rating tool I've seen, but I...

Thank you for the suggestions on the Beer1 vitamines. 😉

Added to the list.

Koen Verbeeck (5/9/2011)

---

I've got a MSDN Livemeeting going on this afternoon (European time). Two demo's of each 15 minutes, so 30 minutes of talking.

Any tips from the professionals around here...

BenWard (5/10/2011)

---

yep thats fixed it.

asp does not seem to like varchar(max) - I can only assume a colleague changed the table for some reason whilst I was on holiday!

appologies for...

can you provide:

- @@version info ?

- ddl of both objects

- did this start all of a sudden or is this a new release ?

- can you find anything in sqlserver...

How about:

SELECT ....

FROM dbo.scr_fct_exact_access scr_fct_exact_access

where seconds_since_epoch < datediff(ss, '1970-01-01', '2011-05-07')

SQLkiwi (5/9/2011)

---

Here's an interesting exception: SELECT...

another thing to keep in mind with any hints is :

As with data volume changes, you'll also have to check their working and the need for them every time...

just my 2ct to solve a design flaw...

- Since it can only hold one the the 4 key values, maybe actually design 4 columns with fk ref to their corresponding...

Adam did a great series about using whoisactive .

http://sqlblog.com/blogs/adam_machanic/archive/2011/04/30/twenty-nine-days-of-activity-monitoring-a-month-of-activity-monitoring-part-30-of-30.aspx

If you find any problems contact him directly.

He'll appreciate your feedback and he reacts fairly quick.

I use the (also free) WhoIsActiveUI...