If, like me, you are having reliability issue with some of your Entity Framework queries performing consistently this post is going to help you immensely. To start with, make sure you understand the LINQ queries and how they translate to SQL and make sure you’ve done what you can to get the end SQL query… Continue reading Making Entity Framework Queries Perform Reliably
Category: MS SQL
How to: Clear the cache for a stored procedure in SQL Server
OPTION 1 – Simple Approach Option 2 – The Configurable and Automated Approach
Useful SQL Server Index Fragmentation Query
Recently I had to brush up my skills on index fragmentation and as a result pulled this query together from a number of useful resources on the net. Just replace ‘DATABASE_NAME’ and run it against the specified database to receive a list of indexes that need attention. Internal Fragmentation is represented by the ‘avg_page_space_used_in_percent’ column… Continue reading Useful SQL Server Index Fragmentation Query
Monitoring and maintaining an int IDENTITY column
When using an int as an identity column in Microsoft SQL Server you’re bound to an upper limit of 2,147,483,647. Ordinarily, that limit would be extremely difficult to exceed e.g. if you had a ShoppingCarts table and it had an int IDENTITY field as the primary key and there were 10,000 carts created a day… Continue reading Monitoring and maintaining an int IDENTITY column
SQL 2008 R2 – The report server has encountered a configuration error. (rsServerConfigurationError)
After installing SQL server 2008 or SQL server 2008 R2 and using reporting services for the first time you may encounter this error: The report server has encountered a configuration error. (rsServerConfigurationError) Exactly as the error message says – you have not configured reporting services correctly. In my case it was because I had not… Continue reading SQL 2008 R2 – The report server has encountered a configuration error. (rsServerConfigurationError)
Rebuild MS SQL full text catalogs for commerce server 2007 search
If you are getting unexpected search results from you commerce server web application it could be caused by your SQL Server full text catalog indexs not been rebuilt. We experienced this issue while using the CS2007 agent APIs to created/modify virtual catalogs. The last step in the process triggers the rebuild of all the indexes using this SQL: … Continue reading Rebuild MS SQL full text catalogs for commerce server 2007 search
Visual Studio Data Comparison (MS SQL) of table with no primary key, unique key, or index
If you have stumbled across this post you are looking to compare two Microsoft SQL Server tables using Visual Studio 2005 or 2010. You have run into issues with the table you need to compare not appearing in the comparison wizard. If you have a read of this link http://msdn.microsoft.com/en-us/library/aa833428.aspx it explains tables and views must meet two… Continue reading Visual Studio Data Comparison (MS SQL) of table with no primary key, unique key, or index
Kaz on Commerce! 