|
|
Stories recently tagged with '2005'
|
|
submitted by
 atifaziz
1 month, 4 days ago scottonwriting.net — Scott Mitchell discusses a little gem he discovered, which is the use of OUTPUT clause in INSERT, UPDATE, DELETE and MERGE (2008) DML statement to get the effect of in-place triggers and more. read more...
add a comment
|
category:  Database | Views: 9
| 
|
tags:
2008, 2005, SQLServer, Database, SQL | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
submitted by
spirit1
1 month, 7 days ago weblogs.sqlteam.com — SQL Server Profiler is a well known tool for tracing different activity that happens between your server and the clients connected to it.
But very few people know that you can have custom events and trace them in the SQL Server Profiler.
read more...
add a comment
|
category: Database | Views: 3
| 
|
tags:
2008, SqlProfiler, 2005, Database, SQLServer | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
published 1 month, 10 days ago, submitted by
spirit1
1 month, 17 days ago weblogs.sqlteam.com — With this new version you can use it for SQL Server Management Studio 2008 and SQL Server Management Studio 2008 Express.
Plus some extra features. read more...
add a comment
|
category: Database | Views: 198
| 
|
tags:
2005, 2008, Database, SQLServer | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
published 3 months, 18 days ago, submitted by
 pinaldave
3 months, 19 days ago blog.sqlauthority.com — INTERSECT operator in SQL Server 2005 is used to retrieve the common records from both the left and the right query of the Intersect Operator. INTERSECT operator returns almost same results as INNER JOIN clause many times.
When using INTERSECT operator the number and the order of the columns must be the same in all queries as well data type must be compatible.
Let us see understand how INTERSECT and INNER JOIN are related.We will be using AdventureWorks database to demonstrate our example. read more...
3 comments
|
category: Database | Views: 250
| 
|
tags:
SQL, SQLServer, SQLAuthority, Database, 2005 | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
submitted by
spirit1
4 months, 5 days 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: 9
| 
|
tags:
2005, 2008, Database, SQLServer | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
submitted by
spirit1
4 months, 9 days 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: 13
| 
|
tags:
2005, SQLServer, Database | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
submitted by
Marlonr
4 months, 13 days 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: 37
| 
|
tags:
2005, TSQL, SQLServer, Database, SQL | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
submitted by
spirit1
6 months, 2 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: 20
| 
|
tags:
2008, Locks, 2005, Database, SQLServer | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
submitted by
 gchandra
8 months, 25 days ago gchandra.com — This article is about configuring SQL Server to query Active Directory using LDAP.
It also lists the possible columns that can be used with LDAP query. read more...
| 
|
tags:
LDAP, SQL, SQLServer, 2000, 2005 | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
submitted by
 rimsystems
8 months, 27 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: 24
| 
|
tags:
2008, 2005, Snippet, VisualStudio, Code | tag it
Everyones tags: | Your tags: | |
|
|
|
|
Sponsored Link: www.carlist.ie
Ads via The Lounge
|