Viewing 15 posts - 1 through 15 (of 38 total)
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.
March 30, 2006 at 4:55 am
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...
January 18, 2006 at 6:04 am
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...
January 17, 2006 at 3:03 am
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...
January 17, 2006 at 2:47 am
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...
December 13, 2005 at 7:21 am
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...
December 7, 2005 at 2:27 am
@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...
December 5, 2005 at 3:48 am
@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.
December 2, 2005 at 8:29 am
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...
November 7, 2005 at 6:32 am
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...
October 4, 2005 at 2:28 am
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...
September 26, 2005 at 4:15 am
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...
September 23, 2005 at 2:46 am
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...
September 23, 2005 at 2:29 am
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...
September 20, 2005 at 6:45 am
Good article about sql server and hyperthreading: http://support.microsoft.com/kb/322385
September 6, 2005 at 5:49 am
Viewing 15 posts - 1 through 15 (of 38 total)