Hi Steve,

Thanks alot for the reply.

As for the guest logins, they both appear to be identical on server 1 and 2. When I try it drop the login on...

Hi,

As mentioned in the previous comments you can use DBCC SHRINKFILE to shrink the files.

http://msdn.microsoft.com/en-us/library/ms189493.aspx

Also as mentioned this may effect performance whilst running.

Hope this helps,

Jackal

Hi Jeff,

Thanks for posting back about the case sensitivity of procedure executions, makes for good reading.

Oh, and on the point of the dba getting over-ridden by 'business needs'. Trust...

Hi J,

I'm not saying that a dba's views would be ignored and I dont want to wonder off track. It's just in situations I have worked in, business requirements...

J (10/2/2008)

---

"This way I can just tell the developer to run stored procedure 'dbo.selectthisandthat' and not have to worry about them calling 'dbo.SelectThisAndThat' and getting potential cache misses."

Would it be...

Hi Jeff,

No problem, let me your views when you've had a look.

Just on another point, ANSI 89 vs ANSI 92, do you know where I can find a quick summary...

Hi Jeff,

The following article contains a sample test.

http://www.sqlservercentral.com/articles/Performance+Tuning+and+Scaling/hitsandmisses/1776/

When I replicated the test (in SS2K), it did appear to be as the article listed. However, re-doing the test...

I guess it's best practise then to always define a case for objects to be in, i.e always lower case. As execution plans for procedures are case sensitive.

This way...

Hi,

I've attached a screen shot of my profiler results.

No matter how many times I call it I get a miss and a hit, the miss is on the adhoc and...

Hi all,

Jane, thanks for posting your article, one things I did notice was;

"Stored procedures should be named by function and the object they work on. Standard prefix like ‘p’, ‘usp’...

Hi Jeff,

Thanks for the reply, I am in complete agreeance with you. I've just been tasked with investigating it's usage potential.

Jackal

The comma seperated join, is an ANSI 89 standard join, whilst the other is the newer ANSI 92 standard join.

I dont know about the performance benefits of 92 over 89,...

Hi guys,

Thanks for the feedback.

With regards to the transaction logs, my mistake, missed them off the post, it was only an example scenario.

Thanks again for the feedback.

Thanks GSquared.

I've been looking all morning, with no joy.

These should do me.

Thanks again.

Edward (9/10/2008)

---

Its a huge huge old system written for sql7. Databases over 200Gb, managment says it does not have the resources to spare to upgrade fully. You would laugh if...