gmamata7 (3/6/2012)

---

Hi,

We have enable FileStream feature for instance INS1 and configured RBS for Share Point Content databases using filestream

We have another database called Mydb which is NOT configured for Filestream....

mtillman-921105 (3/6/2012)

---

Lynn Pettis (3/6/2012)

---

Drove to Denver for fifteen years, not really a problem. Starting again seven years later and it was just kicking my *** physically.

Haven't really started doing...

siva 20997 (3/6/2012)

---

I am pursuing my methods and developing applications

The T SQL Logic which every one seems to want is effient code

What they dont seem to reaalise is that it...

mtillman-921105 (3/6/2012)

---

My guess is that they are trying to get a specific answer - to 5 decimal places rather than none. If you can, run the original way and...

I would not rely on those backups for recovery of any database. Most likely they will be in an inconsistent state and unusable.

You really need to use either SQL...

I'd be curious about the definitions of the tables used in each of the queries as well.

Also, what is with select the top 5 from one table into the temporary...

siva 20997 (3/6/2012)

---

Ok I get it now. You had posted the solution earlier on which I had not tested or Sree had accepted

The thread continued for another 2 pages...

Can't see what you are doing. Try posting all the code not just pieces of it.

Plus, your first select statement needs to be part of the query that follows...

What people are...

I like earning extra cash on the side as well.

One thing I would also look at changing are the UDFs. I would rewrite them as in-line table valued functions...

Not knowing your system, it really is hard to say what it is doing or why.

Just food for thought. If the procedure(s) have been working well for months (or longer) and then suddenly start having issues, it could be a result in changes in...

I completely disagree with this statement. If you are working with MS SQL Server...

I find this part the toughest. There really is no...

Not quite true. You can define a primary key index while declaring the table variable. You can't add indexes to a table variable...