Putts (5/9/2012)

---

Currently, our Data Access relies heavily on SPs - we do not call Tables or Views directly from code. If we have a reason to query the database...

The table is fairly simple. Be a bit of a pain to construct the data manually, each produced item (thousands of them) has 72 records where the CblSn is the...

Rod,

Based on the above, my understanding is that you can access the reports via the ReportServer URL but not via the Reports URL... is this still the case?

Maybe a...

Next time it happens, try running this in another window and see what comes up:

select * from sys.dm_os_waiting_tasks where session_id > 50 and session_id != @@spid

select * from sys.dm_exec_requests where...

TeraByteMe (4/27/2012)

---

That is the rosey side of it. But what do you do when their business requirements contradic themselves? When they refuse to see that they do and the next...

riya_dave (4/23/2012)

---

ok.

but i like something like this,for each row return by query the loop should run.while there is row in the table

that is the condition i need ,i dont know...

According to NetApp, they consider this to be a SQL problem. Can't say I'm thrilled with their support at this point.

They initially insisted that it was a SQLVDI problem;...

We have a database that's had a trailing space at the end of it's name since before I started with the company. So far they've resisted letting me fix...

Interesting solution, but honestly I think a far better solution is to train your developers to avoid doing things like SELECT * in production code, along with having a good...

Tried that and it didn't work, but thanks for the suggestion 🙂

I ended up "fixing" the problem by...

With all respect, the comparisons made for EXCEPT and INTERSECT in the article are kind of like driving a Ferrari 458 to your corner grocery, and from that concluding that...