Browse by Tags

• Linq

• Restore Sql 2008 backup to Sql 2005

  hmm. I recently did a clean install of Windows 7, and that was a nice opportunity to get of rid of all redundant software. So I only installed Sql 2008 because it must be backwards compatible.  I thought: I can open a Sql 2005 database in... Posted sep 25 2009, 11:55 by Jo-wen with | with no comments Filed under: SQL

• Generate INSERT INTO script for existing data in Sql Server 2008

  It always amazes me how little features are built into Sql Server Management Studio. One of these (trivial) things is to generate a script which inserts existing data. Fortunately, it has become a feature in Sql Server 2008. short story: right click the... Posted aug 15 2009, 06:31 by Jo-wen with | with no comments Filed under: SQL

• Sql Server 2008: Can't save changes that require Recreation of Database

  There's a silly new default in SQL Server's Management Tools: When you design a table in a database and then try to make a change to a table structure that requires the table to be recreated, the management tools will not allow you to save the... Posted aug 10 2009, 03:22 by Jo-wen with | with no comments Filed under: SQL

• Installation of Sql Server Express 2008

  Ok, the installation of Sql Server (Express) 2008 is not of the type "next-next-finish". I first installed the Sql Server Express 2008 instance, and then I wanted to have the Management Studio. (not a very exotic scenario is it?!) I ran the... Posted jun 24 2009, 10:47 by Jo-wen with | with no comments Filed under: SQL

• LinqPad

  Ok, als je zoals ik een gruwelijk hekel hebt aan het schrijven van t-sql queries is hier een mooie tool. Je kan hiermee linq queries schrijven, en die automagisch vertalen naar t-sql- en labda queries. Cool! Posted mei 24 2008, 01:39 by Jo-wen with | with no comments Filed under: SQL, Linq

• 50 meest cpu-vretende queries in SQL

  Ik heb hier een query die een lijst toont met de meest cpu intensieve queries die in sql zijn uitgevoerd. Handig als je performance verbeteringen wilt doorvoeren. Vraag me overigens niet om de details, gezien ik geen sql guru ben ;) select top 50 (a.total_worker_time... Posted apr 15 2008, 01:24 by Jo-wen with | with no comments Filed under: SQL