DotNetKick.com is an open-source project. Please report any bugs and let us know your great suggestions. Currently running svn revision 620 (rss)

Kick Spy!, Kick Zeitgeist and Kick Widgets

Stories recently tagged with 'Database' Subscribe to this feed
29
kicks
published 18 hours, 58 minutes ago, submitted by jongalloway jongalloway 1 day, 1 hour ago

blog.wekeroad.com — Rob runs some tests with millions of records to see how SubSonic holds up with respect to speed and memory use. read more...

Add a comment 3 comments | category: | Views: 199
tags: | tag it

1
kicks
submitted by wisemx wisemx 1 day, 20 hours ago

sqlblog.com — I just installed the Allocation Information add-in for SQL Server Management Studio. It's very cool having this tool integrated into SSMS. It is a free add-in published on CodePlex. Take a look, it does worth the download in my opinion. read more...

Add a comment add a comment | category: | Views: 1
tags: | tag it

25
kicks
published 1 day, 20 hours ago, submitted by dnk2007 1 day, 23 hours ago

blogs.lessthandot.com — Only In A Database Can You Get 1000% + Improvement By Changing A Few Lines Of Code read more...

Add a comment add a comment | category: | Views: 522
tags: | tag it

15
kicks
published 2 days ago, submitted by sidarok 2 days, 8 hours ago

sidarok.com — Sidar shows a possible strategy to localize Linq to SQL entities read more...

Add a comment add a comment | category: | Views: 182
tags: , , , , | tag it

1
kicks
submitted by RipRyness 2 days, 9 hours ago

west-wind.com — 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. read more...

Add a comment add a comment | category: | Views: 4
tags: | tag it

1
kicks
submitted by kalyan 2 days, 9 hours ago

blog.kantikalyan.com — MySQL WorkBench - More on how to use it. read more...

Add a comment add a comment | category: | Views: 3
tags: | tag it

1
kicks
submitted by kalyan 2 days, 14 hours ago

blog.kantikalyan.com — A great tool for working with mysql database read more...

Add a comment add a comment | category: | Views: 1
tags: | tag it

1
kicks
submitted by wisemx wisemx 2 days, 23 hours ago

blogs.msdn.com — I innocently wrote this SQL SELECT statement to query all rows that have column value started with "[summary]": select * from MyTable where Description like '[summary]%' Then I was wondering why I could get a lot of rows returned and none of them started with "[summary]". Hmm, I think I need to look at the SQL Server reference. Well, I only remember the usage of '%' and '_' wildcards in the LIKE clause pattern. The first one will match empty string or any character(s), while the second one is to match any single character only. Apparently '[' and ']' characters are special wildcard to match any character within specific range, for example: '[a-z]' to match any character from a to z, '[xyz]' to match 'x', 'y' or 'z' character. So in my example above, it will query all rows with Description column started with either of these characters: 's', 'u', 'm', 'a', 'r' or 'y'. Therefore, I should use ESCAPE clause, and re-write the query statement to be: select * from MyTable where Description like '|[summary|]%' escape '|' This query now returns the correct result I want. read more...

Add a comment add a comment | category: | Views: 5
tags: | tag it

17
kicks
published 2 days, 1 hour ago, submitted by ormico 3 days, 2 hours ago

weblogs.asp.net — use SMO to run SQL scripts on .NET read more...

Add a comment add a comment | category: | Views: 220
tags: , | tag it

4
kicks
submitted by wisemx wisemx 4 days, 18 hours ago

blogs.msdn.com — Great video on the new Date DataTypes in in Sql read more...

Add a comment add a comment | category: | Views: 8
tags: | tag it

2
kicks
submitted by wisemx wisemx 4 days, 18 hours ago

blogs.msdn.com — Connect SQL Server 2005 SSMS to SQL Server 2008 Not sure whether you've had to connect your SQL Server 2005 Management Studio to an instance of SQL Server 2008 yet, but I needed to do this today and got bitten by the fact that it doesn't work until you install the latest cumulative update to SQL Server 2005 SP2. You can download the update here. http://support.microsoft.com/kb/943656 read more...

Add a comment add a comment | category: | Views: 2
tags: | tag it

2
kicks
submitted by gilf gilf 4 days, 21 hours ago

blogs.microsoft.co.il — The post explain how to build a .Net client for a ADO.NET data service read more...

Add a comment add a comment | category: | Views: 3
tags: , | tag it

4
kicks
submitted by pinaldave pinaldave 5 days, 18 hours ago

blog.sqlauthority.com — If you have struggled with your datetime format with your application or database. This is one script you will need. Bookmark it. read more...

Add a comment add a comment | category: | Views: 4
tags: | tag it

5
kicks
submitted by wisemx wisemx 5 days, 19 hours ago

blogs.msdn.com — The Slackers have been busy ! Check out the Open Source project on CodePlex. http://www.codeplex.com/AjaxDataControls/ Not only is there a controls library and all the source code for the controls but a RICH set of demos that illustrate utilization. I'm now using them in my own projects. Check 'em out ! Published Thursday, August 14, 2008 10:20 AM by JoeStagner read more...

Add a comment add a comment | category: | Views: 9
tags: | tag it

3
kicks
submitted by kprernn 5 days, 21 hours ago

weblogs.sqlteam.com — This blog posting demonstrates how a SQL Server process can be marked a sleeping and awaiting command, yet still maintain its locks on a table. read more...

Add a comment add a comment | category: | Views: 2
tags: | tag it

1
kicks
submitted by StatisticsIO 6 days, 8 hours ago

statisticsio.com — The past, present and future of physical database design on SQL Server. read more...

Add a comment add a comment | category: | Views: 4
tags: | tag it

 

Sponsored Link: www.carlist.ie

Search:

Ads via The Lounge