Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Hits and Misses Expand / Collapse
Author
Message
Posted Thursday, March 10, 2005 9:34 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, December 18, 2014 7:26 AM
Points: 2,205, Visits: 2,016
Great Article.  It is interesting to note that this article came out on the 1 year anniversary of Chris's Article - Worst Practice - Not Qualifying Objects with the Owner.



Francis
Post #166923
Posted Thursday, March 10, 2005 3:31 PM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Saturday, February 28, 2009 6:51 AM
Points: 1,489, Visits: 7
Yep, I do not normally use case-sensitive servers, but I always try to enforce naming and coding conventions that say exactly how to name objects and write code, where to use lower and upper case etc. Especially for sp_executesql this makes this much more important now.



--
Chris Hedgate http://www.hedgate.net/
Contributor to the Best of SQL Server Central volumes
Articles: http://www.sqlservercentral.com/columnists/chedgate/
Post #167036
Posted Monday, March 14, 2005 3:01 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, December 15, 2014 8:13 AM
Points: 271, Visits: 156

Very good and interesting article
Thanx.




You must unlearn what You have learnt
Post #167432
Posted Thursday, March 17, 2005 1:44 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 6:20 AM
Points: 2,923, Visits: 1,874
Let us suppose that you develop on a case sensitive server and that development includes a substantial amount of data, that is, more than you would want to insert using INSERT statements and probably some binary data.

How would you deploy this to a case insensitive server?

I have had problems where a client has supplied me with a database backup for a completely different collation sequence to mine and my server refused to restore it.


LinkedIn Profile
Newbie on www.simple-talk.com
Post #168288
Posted Friday, March 10, 2006 8:45 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, February 8, 2013 1:35 PM
Points: 25, Visits: 21

Thanks Mr. Metcalf, every bit helps in keeping your performance in line.  Yes, we have a high proportion too. 




Post #264895
Posted Friday, March 10, 2006 11:46 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, November 11, 2014 11:28 AM
Points: 41, Visits: 383

Question (with apologies in advance for my ignorance):

I use ADO in my app to execute the sproc. I create a command object with collection of parm objects standard (works with input and/or out parms).

When I set the CommandText I do not fully qualify the sproc name.

*This* is what the article is talking about, correct? I should set the CommandText to "dbo.spDoSomething" instead of just "spDoSomething".

The real question is: the issue is the same if using ADO and not just in T-SQL, correct? The names (or case) of the members of the parms collection does not matter, although the order does.

Post #264964
Posted Friday, February 27, 2009 4:45 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, December 2, 2014 10:52 AM
Points: 26, Visits: 269
Thanks for the articles.
However, when I run the same SP a couple times, I see a cache miss right after cache hit and the usecounts in syscacheobjects does increase.
Everytimes I run the sp, a cachemiss will happen before the cache hit
Could you explain?
Thanks!
T.

Here is my example copied from BOL
USE AdventureWorks;
GO
IF OBJECT_ID ( 'HumanResources.uspGetAllEmployees', 'P' ) IS NOT NULL
DROP PROCEDURE HumanResources.uspGetAllEmployees;
GO
CREATE PROCEDURE HumanResources.uspGetAllEmployees
AS
SET NOCOUNT ON;
SELECT LastName, FirstName, JobTitle, Department
FROM HumanResources.vEmployeeDepartment;
GO

EXECUTE HumanResources.uspGetAllEmployees
Post #666063
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse