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
SQL
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.
SQL Server Indexing Talk – Niall Flanagan
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
SQL Server Express Error 17053
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
Using Select into in Sql server
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
