gail,

I was trying to say

update statistics provide query optimizer with the best possible information for generating query plans. statistics are updated when their are created or modified. and also be...

Gail,

Can you tell me, what you wants to say in above post??

Cheers!

Sandy.

lallen (7/21/2008)

--------------------------------------------------------------------------------

I've created a temporary table using select into statement, and called the table #Table1 (for example). But I can't get the syntax right to pull the information out...

It's ok.

Let me try using CLR...

Cheers!

Sandy.

to update database object...in system tables....in simple..

Cheers!

Sandy.

Michael,

Yup, I do agree what you said, but my question is bit different here.

just assume this case you will come to know more..

I have query like this:

Begin

Query 1

...

it looks like syntax error. check it.

Cheers!

Sandy.

hemu,

what's your issue in sp....?

Cheers!

Sandy.

yup,

I think, delta is asking for security on database object. there is so many ways you can maintain the security in database level.

but as u said to "Hide", I...

rinnuuuuu,

you can see "MSDN" for more details...

and update yourself also "Full text indexing and Xml Indexing"

both indexing are hot topic now in sql....

I personally feel the advantage of fulltext indexing...

rinu,

good idea..:)

Cheers!

Sandy.

rinu,

go through below links.

http://msdn.microsoft.com/en-us/library/ms188783.aspx

http://www.sql-server-performance.com/articles/per/index_data_structures_p1.aspx

http://www.odetocode.com/Articles/70.aspx

Cheers!

Sandy.

I think you may have gone through this concepts in the beginning of your career, then why are you asking again,...

try it, and let me know if any concern..

Cheers!

Sandy.

seenay, which datatype are you using for this starttime and endtime columns?

Cheers!

Sandy.