Another topic about stored procedures:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=209619#bm210035

Dynamic sql is also compiled at first use and the execution plan is stored in cache. There is no diverence.

To my knowlegde (mayby other people have more info) SQL Server does not take into consideration where the data is coming from (disk or memory). The execution plan is always...

I only wanted to say: if you want to make an in-memory-database of SQL Server you have to rebuild the engine. The optimizer has to be changed. A good optimizer...

Hoodi,

Mayby you can look at http://www.oracle.com/technology/products/timesten/index.html

You can never make SQL Server a real in-memory-database. When SQL Server makes an execution plan it takes into account that most data will be...

I found out the answer. Although you place a varchar in the middle of a row. The physical placements of varchar's are a the end of a row. So SQL...

Sorry randy,

we have a server (8GB internal, glassfiber SAN) with SQL Server (getting 5,5GB of it) , IIS, Reporting services and a .Net web services running on it. There are...

@Yelena: I didn't want to offend you. I'm in a company with 1000+ it-people. Off course only a small part of them are actually using sql server. But most of...

@Yelena: procs are compiled at first use and put in the cache. A dynamic SQL-statement is compiled at first use and put in the cache.

I'm hesitating to answer the question, bacause i'm only a MS-SQL Guru wannabe.

SQL Server 2000 should use the ANSI SQL-92 standard. As of 9i oracle should use also the ANSI...

It's recommended to delete pubs in a production environment. So if a login has the default database set to pubs and it's deleted, he gets an error.

Mayby tempdb is a...

If you backup manually, you have not the same permissions as when you backup using a job. When you are doing a backup using a job, the user of sql...

We had some similar problems. It was a long time ago, but i know it had to do with the owner of the backup jobs. Has the owner permissions on...

I'm currently looking at Microsoft Health and History tool. So far it's looking great. I also have the performance collector and the standard reports in reporting services. Underneath it also...

Thank you all,

These logins of mine are also from a third-party application. I think, it's a thing to keep in mind when you have to move database files. When you...

Good article about sql server and hyperthreading: http://support.microsoft.com/kb/322385