|
|
Stories recently tagged with 'Database'
|
|
published 18 hours, 58 minutes ago, submitted by
 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...
3 comments
|
category:  Database | Views: 199
| 
|
tags:
Database | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
submitted by
 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
|
category: Database | Views: 1
| 
|
tags:
Database | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
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
|
category: Database | Views: 522
| 
|
tags:
Database | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
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
|
category: Database | Views: 4
| 
|
tags:
Database | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
submitted by
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
|
category: Database | Views: 5
| 
|
tags:
Database | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
submitted by
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
|
category: Database | Views: 2
| 
|
tags:
Database | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
submitted by
 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
|
category: Database | Views: 4
| 
|
tags:
Database | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
submitted by
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
|
category: Database | Views: 9
| 
|
tags:
Database | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
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
|
category: Database | Views: 2
| 
|
tags:
Database | tag it
Everyones tags: | Your tags: | |
|
|
|
|
Sponsored Link: www.carlist.ie
Ads via The Lounge
|