If you can do with the views why are you looking out for using functions? View should be fasted option.

file growth event is the costly event and can cause performance issues. Make sure file growth is not triggered very frequently and keep the adequate growth parameter.

Features like Materialized views, partitioned tables are not matured in SQL Sever as compared to Oracle. Inbuilt/System functions are more rich as comapred to SQL Server.

For large databases this turns...

There is woman behind every successful person.

There is DBA behind every successful application. 😉

What a question :hehe:

when u create the login you can specify the default database.

For the particular login you can change the default database later on also.

Regarding compressed tables/ data-

PAGE compression gives more compression ratio than ROW compression.

Page compression uses the actual logic for compression. Row compression happens only on fixed length data types.

I have seen huge CRM application (Product) is with out FK's. These databases are in hundreds of GB's.

One advandate is definitely there - hiding the DB design.

Also i have seen...

Yes, table valued function can be given select permission and not execute.

thanks Lynn.

no, its not any implementation requirement. its just learning point of view. I always come acorss this question when talking to oracle DBA's regading migration to SQL Server.

Oracle RAC...

it will use only PK. Union all could give improved performance. Please post the results

if you are using any features of SQL 2005 which are not there in 2000 in the database code. It will cause the issue.

Refer to the new features of...

In some discussion i come across the question on how load to the SQL Server canbe balanced; so Just wanted to learn the different options and solutions from the expert...

i know 1 way of passing page number as a parameter and returning only those many number of rows particular to that page out of total rows.

But this is...

Use

SET IDENTITY_INSERT ON

and then copy the records along with identity column data.