Sorry AER

Actually whoteegan Please paste the topic id link you mentioned.

REgards,

AFfan

AER,

can you Please paste the link as i could not find the way to search the Topic ID.

Regards,

Affan

Hi,

I have tried to shrink the DB with DBCC shrinkfile and SHrinkdatabase as well and in both cases the log file shrunk properly but the data file didn't. although the...

I think the problem with the temp tables are recompiles and keeping fix plans is not a good idea. and down side whould be same for table variables or temp...

Thanks

I'll look into that

Kind Regards,Affan

Thanks all for the reply.

Actually i want to distribute a number amongs the first n rows whose sum is equal to the number beign distributed.

e.g. i have 1000 and i...

General hind sides of using case statements.

Here my 2 cents, i am usgin Schema Alert of lumigent and from the messages i found this

"The user alpha created a new table named "@dtTable" in the "tempdb"

database on...

But using temp tables will disable the cahing and put a heavy load on the temp DB, am i correct ???

Kind Regards,

Affan

Thanks, I have the same point of view about this.

Kind Regards,

Affan

Thanks Kay,

these are good points and will help me somewhere else.

I just wanted to avoid writing to transaction log while implementing transactions.

Kind Regards,

Affan

Thanks for the reply,

I have read the thread but my porblem is that i need to stop SQL server to stop writing log for some specific tables. From the thread...

Thanks Phill i'll look into that.

Secondly i want to give user complete independence aboiut defining the FK/PK relationships or integrity checks.

Kind Regards,

Affan

Thanks Phill,

Let me ask another question that can i use DTS to make a ETL tool with a user friendly user interface where user provides the source and destination database...

Thanks Phill,

Let me ask another question that can i use DTS to make a ETL tool with a user friendly user interface where user provides the source and destination database...