You are currently browsing the monthly archive for August, 2008.
This is an interesting article on an issue with LINQ to SQL and what SQL Server does with procedure caching coming from LINQ.
http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/linq-to-sql-queries-involving-strings-ca
In summary, each where condition depending on the size of the value will cause a different plan to be created – e.g if the value passed into a WHERE clause was ‘This Value’ and another was ‘Another Value’ – two entries will be kept in the procedure cache… one a NVARCHAR (10) and another NVARCHAR (13)..
I have no checked SP1 to see if this is resolved. If anyone knows, please let me know.
Missing the report builder, can’t wait for the RTM?
Report Builder 2.0 RC1 is now available on Microsoft Download Center. Use this link for download.
RC1 delivers improvements in the following areas compared to RC0:
- Easy to use wizards for creating table, matrix and chart data regions.
- Support for directly opening and editing reports stored on the report server.
- Support for using server resources such as shared data sources.
- A query designer for Microsoft SQL Server data sources.
- Enhancements to the Report Builder 2.0 ribbon.
So.. enjoy!
SQL Server 2008 Express tools are now available…
- SQL Server database engine – create, store, update and retrieve your data
- SQL Server database engine – create, store, update and retrieve your data
- SQL Server Management Studio Basic – visual database management tool for creating, editing and managing databases
- SQL Server database engine – create, store, update and retrieve your data
- SQL Server Management Studio Basic – visual database management tool for creating, editing and managing databases
- Full-text Search – powerful, high-speed engine for searching text-intensive data
- Reporting Services – integrated report creation and design environment to create reports
The company I work for is recruiting!, if you have some of the following please get in touch.
SQL Server 2005 experience
- Service Broker
- SSIS
- Profiling/Performance
- Transactional Replication
- Custom Replication
Any knowledge of SQL 2008 would be an advantage as would experience of high volume transactional databases (web focused).
I am attending the community led event this evening in Victoria, London which is focused on LINQtoSQL and the new entity framework. I have blogged before about my reserverations on LINQ from a pure SQL point of view but I am always open to new technology and I do realise LINQtoSQL has it’s place.
At some point at the weekend I will blog about this evening’s event , assuming I gain any knowledge worth sharing of course.
