in

Dé specialist in .NET trainingen en consultancy
All Tags » SQL (RSS)

Browse by Tags

  • 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 Sql 2008 Management Studio, create a backup (unedited...
    Posted to Jo-wen Mei (Weblog) by Jo-wen on 09-25-2009

  • 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 database > tasks > generate scripts >...
    Posted to Jo-wen Mei (Weblog) by Jo-wen on 08-15-2009

  • 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 changes. The fix is: Go to Tools | Options | Designers...
    Posted to Jo-wen Mei (Weblog) by Jo-wen on 08-10-2009

  • 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 setup, and I selected the option to add new features...
    Posted to Jo-wen Mei (Weblog) by Jo-wen on 06-24-2009

  • 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 to Jo-wen Mei (Weblog) by Jo-wen on 05-24-2008

  • 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/a.execution_count) as [avg_cpu_time...
    Posted to Jo-wen Mei (Weblog) by Jo-wen on 04-15-2008
Page 1 of 1 (6 items)