Adam Bean (3/21/2008)

---

Really? Do you a link...

TheSQLGuru (3/21/2008)

---

+1 to the group that has never heard about capitolization mattering for cache hits for stored procedure calls. ad hoc I did know about. Very surprised about...

I got it to work through scripting!

EXEC sp_addlinkedserver 'targetServer\targetInstance, N'SQL Server';

GO

Is there a bug in the GUI in SSMS for linked-server creation??

I see this issue reported before on this site: http://www.sqlservercentral.com/Forums/Topic353977-146-1.aspx

Does Kerberos auth. need to be enabled for this to work?

I don't want to use SQL Auth. in the linked server.

I googled "trace flag 1118" and this was at the top of the list:

PRB: Concurrency enhancements for the tempdb database

support.microsoft.com/kb/328551

Look for nasty queries, ones with lots of IO. Your high tempdb utilization is likely due to inefficient execution plans.

In SQL 2005 there are powerful tools to allow you great...

chris (3/20/2008)

---

A great tip, thanks!

However, I find it interesting, now that I am aware of this property, that it doesn't seem to work if you explicitly set the height value....

No worries, it wasn't meant like that... 🙂

I was concerned that maybe I had missed something all this time.

This flag is good to know, something new I learned this morning.

Thanks!

Buxton69 (3/20/2008)

---

If you are doing this in SQL 2000 you need to set the trace flag 1118 so the different tempdb files are used evenly but in SQL 2005 you...

net (3/19/2008)

---

Hello,

thank to reply,

It was asked for me to create a database following some "best practice",

one of these was to set the number of files to match the number of...

A couple of other things to consider when concerned about low cache-hit ratio:

Interleaving DML and DDL statements in code. Put all your DDL statements (such as temp-table creation etc) at...

Also:

Case matters. Refer to your objects in the exact case in which they were created. Not doing so will result in recompilations.

The procedure cache does not benefit from AWE memory extensions. The only benefit of AWE memory is on the data cache.

And, yes, do always qualify your database objects (tables, sprocs...

GSquared (3/19/2008)

---

If you're using transactions to reduce the...

Agreed.

Precisely who...