There are none of checking for disabled jobs out...

Did that blog post upset people? It shouldn't. Ah...

I would flat out not recommend using SQL Server to store files. It does a lousy job of it, as you're finding. I'd store the files on the file system...

If you really want to be able to do anything with the data, I'd suggest performing that work on the client side, in code or the reporting tool or what...

balasach82 (7/1/2010)

---

Ok, will start as a new thread.

am insering the trace records into a table. The problem is there is nothing in the TextData field other than those run from...

Lamprey13 (6/30/2010)

---

HowardW (6/30/2010)

---

It would be interesting to see if this could be converted to an Inline Table Valued Function that avoided using table variables - that's the way to really...

Kit G (6/30/2010)

---

HowardW (6/30/2010)

---

Do you want to share the code for the function with some sample data?

It would be interesting to see if this could be converted to an Inline...

GabyYYZ (6/30/2010)

---

Lucky...still shell-shocked...

You could get a much wider audience if...

Oh right, Mr. Umpty-gazillion points, you "finally" beat me to the punch. :hehe:

Is that a single statement table valued function or a multi-statement table valued function? If multi-statement, you were just lucky that it ran well in 2000. These types of functions...

I have heard that some functions, usually ones that are problematic in nature anyway, do perform slower on 2008 than on 2000. I have not seen or heard of any...

There's nothing wrong with a few of these types of queries in almost any system. They do come up, and it's pretty normal. Using sp_executesql and parameters can improve the...

Nagesh S-432384 (6/29/2010)

---

I think it is because, i was trying to restore the backup file on the new server where we don't have lite speed installed, now we have installed...

It sounds like you might have an issue with the Litespeed install. Instead of trying to run the standard backup & restore commands, try using Litespeed's extended stored procedures. You...