|
|
Stories recently tagged with '2005'
|
|
submitted by
spirit1
1 day, 8 hours ago weblogs.sqlteam.com — In my previous post about immediate deadlock notifications in SQL Server 2005 I've shown a way to use a try catch block to get the deadlock error.
The con of this method, although it uses best practice for error handling in SQL Server 2005, is that you have to change existing code and
it doesn't work for non stored procedure code. And that IS a pretty BIG con! So here's a solution to this con.
read more...
add a comment
|
category:  Database | Views: 3
| 
|
tags:
2005, 2008, Database, SQLServer | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
submitted by
spirit1
5 days, 8 hours ago weblogs.sqlteam.com — Here's a demo of a nice little bug in SQL Server 2005 when using LIKE comparisons for searching.
What is so "nice" about it is that it only manifests itself if your search ends in number 9 followed by a wildcard when
selecting only columns covered by a nonclustered index.
read more...
add a comment
|
category: Database | Views: 9
| 
|
tags:
2005, SQLServer, Database | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
submitted by
Marlonr
9 days, 9 hours ago dbalink.wordpress.com — For some reasons, DBA’s need to rename their Databases. One of the reasons might be to comply to Best Practices Policy changes.
Here we are going to rename our Database named “Bad_Ass_DB” into “Best_Practice_DB”. This is how Database renaming with TSQL is done in SQL Server 2005....
read more...
add a comment
|
category: Database | Views: 4
| 
|
tags:
2005, TSQL, SQLServer, Database, SQL | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
submitted by
spirit1
1 month, 28 days ago weblogs.sqlteam.com — Deadlocks can be a pain to debug since they're so rare and unpredictable. The problem lies in repeating them in your dev environment. That's why it's crucial to have as much information about them from the production environment as possible. This is one way of getting it immediatly when it happens, read more...
add a comment
|
category: Database | Views: 13
| 
|
tags:
2008, Locks, 2005, Database, SQLServer | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
submitted by
 rimsystems
4 months, 22 days ago john-sheehan.com — Automatic properties are nice, but sometimes they just won't do. Visual C# 2005 included a 'prop' code snippet for a full property with backing filed but 2008 changed the snippet to generate an automatic property. Here's how to restore the 2005 snippet. read more...
2 comments
|
category:  Visual Studio | Views: 5
| 
|
tags:
2008, 2005, Snippet, VisualStudio, Code | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
submitted by
joycsc
5 months, 3 days ago geekswithblogs.net — Some basic differences among SQL Server 2005 unique columns (primary key, unique key, unique identifiers etc). read more...
add a comment
|
category: Database | Views: 2
| 
|
tags:
2005, Database | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
submitted by
spirit1
5 months, 15 days ago weblogs.sqlteam.com — There are at least 4 ways you can COUNT in SQL Server: COUNT(*), COUNT(ColumnName), COUNT(DISTINCT ColumnName) AND SUM()
All 4 combined can be used to speed up queries especially for reporting. read more...
add a comment
|
category: Database | Views: 4
| 
|
tags:
2000, 2005, Database, SQLServer | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
published 5 months, 27 days ago, submitted by
 rstrahl
5 months, 27 days ago west-wind.com — If you move Web Application Projects between Visual Studio 2008 and Visual Studio 2005 and a machine that doesn't have Visual Studio 2005 installed you will find that the project doesn't load due to a build target difference. read more...
add a comment
|
category:  ASP.NET | Views: 10
| 
|
tags:
2005, 2008, ASP.NET, VisualStudio | tag it
Everyones tags: | Your tags: | |
|
|
|
|
Sponsored Link: www.carlist.ie
Ads via The Lounge
|