About Jeremiah

I'm a senior database administrator with Cass Information Systems, a SQL Server MVP, director-at-large with PASS, and I also help out with my local chapter and the Application Development virtual chapter.

You can learn more about me or contact me directly.


Google Reader
Google Profile
delicious

LINQ to SQL may cause performance problems

Marco Russo posted about a possible LINQ to SQL performance problem.
Using AdventureWorks for our sample, we might have a stored procedure to select from the Production.Product table:
[viewcode] src=”http://facility9.com/files/2008/08/create_getproductbyname.sql” showsyntax=”no” link=”yes” [/viewcode]
Calling this procedure will always use the same cached execution plan and will only be re-compiled if/when the procedure is consciously changed by a DBA [...]

August 28th, 2008 | Tags: | Category: Code, SQL, SQL Server, syndication | Leave a comment

More about jQuery cookies

When working with jQuery’s cookie plug in, it’s important to keep in mind the path that is going to be used.
On a web site’s default.html page, the path will be set to /, but one or two directories down, the cookie’s path will be /dir/subdir.
I’ve gotten around this by encapsulating the information that I need [...]

August 22nd, 2008 | Category: Code, syndication | Leave a comment