Rohit Chitre (3/4/2008)

---

10% Growth for mdf and ldf files of tempdb database is allocated. Maxsize is unlimited

When performance is said to be down number of users are deifinately high. But...

I think you'll find that NEWID() is the exception to many rules that apply to other functions. Strange as it seems, it's the only true random number generator in...

Roy Ernest (3/3/2008)

---

I believe the person wants to do the query based on the year...

It's certainly no Panacea, but the following article has some insight as to why you can have performance problems with some UDF's in the SELECT list...

http://www.sqlservercentral.com/articles/Test+Data/61572/

Heh... it's only fitting, Jack. I stayed up too late to write it 😛

Thanks for both the feedback and the tip on the PDF stuff... I really appreciate...

Ed is correct... and I go one further... what are the growth setting for your databases... I'm interested in all of the databases but I'm particularly interested in the growth...

Not a problem... First, it can't be done in a view because of the temp table.

I'm not really using any form of recurrsion... I only stuff that meets the first...

Muhammad Furqan (3/4/2008)

---

well "overkill"

?????????????????

Whats the alternative then?

because alternative people over here are mentioning are not working for me.

"EXEC @sql;" doesnt work in a UDF and if put in a stored...

ST! Man, good to see you're still around! I thought you dropped off the face of the planet.

Oh yeah... I almost forgot... the CLUSTERED INDEX (PK in this case) is absolutely essential. Normally, I'd name the key in the FROM clause using a WITH(INDEX(indexname,TABLOCKX)) hint to...

It's actually in Books Online under UPDATE...

Syntax

UPDATE

{

table_name WITH ( ...

I have a really unique method of getting developers to follow the standards... I take them out to dinner and feed them nice juicy pork chops... with a slingshot! ...

salinasalina2001 (3/2/2008)

---

hi all

i need to quote my columns into strings like

'"'+cast(columnname as data type())+'"' so that if the column name is FristName

to be displayed in notepad as "FirstName" ie...

This is the second time I've seen this and I don't know how folks are doing it... I don't know how or why it says "Discuss Content Posted By Jeff...

The code I posted before works fine on the data you posted before 😉 This new problem description is just a wee bit different...

... this will do it... lightning...