The lack of support for CSS style sheets in reporting services can make life difficult when you want to have common formatting across reports. There are also occasions where you may want to share common conditional formatting logic across reports. This example shows how common code can be used to help in these scenarios. Whilst a .NET assembly would probably be more efficient … [Read more...] about Conditional Formatting in Reporting Services using Common Code
SQL stands for Structured Query Language and allows you to access and manipulate databases. SQL has many advantages which makes it a popular and efficient language for communicating with the databases such as faster query processing and easy to learn. Check the latest posts from tutorials to troubleshooting from Joe Gill.
PJ Naughter, a Microsoft MVP, is coming to Cork on April 27 to do a talk on using .NET Common Language Runtime (CLR) inside SQL Server.Register on the mtug web site register … [Read more...] about Cork talk on using CLR inside SQL Server
Niall Flanagan did a great talk to MTUG Cork on indexing and fragmentation in sql server last night. It was a good session and it went on for over two hours with lots of interaction.Well done NiallThe materials from the talk can be found on the materials tab on the event Event … [Read more...] about SQL Server Indexing Talk – Niall Flanagan
Have not used express for a while and when I when to start the service I got an 17053 error saying could not open master.mdf, etc even though the files existSolution: Change the service to logon on as system account … [Read more...] about SQL Server Express Error 17053
It's a No NoDon’t use select into as it locks the tempdb for the duration of the select. You have to create the temp table fist and then do a insert … select … from. Need to look at it this in SQL 2005. … [Read more...] about Using Select into in Sql server