Sign in
|
Join
|
Help
in
Current Tags
(Entire Site)
Dé specialist in .NET trainingen en consultancy
Home
Blogs
Downloads
All Tags
»
SQL
(
RSS
)
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 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)