chetanr.jain - have tested on sql 2005 through 2008.

can you be more specific on the error?

SQL_Quest-825434 - no reason, i'm sure temp tables will do equally well.

Thank you for clarifying , will be revisiting the only CLR i've written to see if i can benefit from this tip!

cheers

r

Hiya,

Can you clarify how you declared the variables for each function (for a .NET amateur)?

Which variables did you declare scope differently for?

Can you give an example of each?

...

Sorry for resurrecting an old thread.

Is there a page that explains the SSC points system anywhere?

r

I love schemas for 2 reasons

1) Organisation

Grouping tables as belonging together in a logical group.

For example from the AdventureWorks db > HumanResources.Employee , Person.Address , Sales.CreditCard.

2) Security

Permissions assigned at schema...

See my post at the bottom of this page

http://www.sqlservercentral.com/Forums/Topic401784-562-2.aspx

The script generates index statements and incorporates table schemas, file groups, drop statements and fill factor.

I've modified mainly to add schemas to table names, other modifications in comments section at top.

Hope this helps someone 😎

IF NOT EXISTS(SELECT 1 FROM INFORMATION_SCHEMA.SCHEMATA

WHERE SCHEMA_NAME = 'utils'

AND SCHEMA_OWNER...

Worked perfectly, a big thank you 🙂

Thank you very much for that Gail.

I've managed to add a second file to my PRIMARY file group.

Not very smart, I know.

How Can I remove this file? (Management Studio reports...

Only tested on sql 2005 & 2008, so that may be an issue.

The DBID() function with no argument returns the database id for the current db.

The script should be run...

I don't understand the problem you are trying to solve.

Is it a parameterization issue?

Ditto previous comment i.e what sql version have you found this to be an issue on?

How large...

Sometimes the simplest ideas are the best.

Brilliant script.

r

big thanks chaps, given me a lot to think about.

cheers

r 🙂

thanks for your reply Stefan, the code runs super fast, though I think I need to understand HOW before I implement it!

cheers

r

just seen the other reply, yes it is performance i'm trying to achieve.

when you have a full data set, lookups using BETWEEN crawl to a halt.

thanks

r