Power of CLR SQL server 2005, + Reqular Expressions(isolutionteam.co.uk)

submitted by naveedkamboh(254) 3 years, 6 months ago

Power CLR(Common Language Runtime), Using Reqular Expression in your queries read more...

add a comment |category: CLR |Views: 13

tags: 2000 Managed Functions SQL CLR another

XML into SQL Server 2000(52coding.com)

submitted by 52coding(255) 3 years, 7 months ago

XML into SQL Server a number of ways, here one of three kinds: read more...

add a comment |category: Database |Views: 13

tags: XML 2000 Database SQLServer another

How to Query Active Directory using LDAP in SQL Server 2000 / 2005 ?(gchandra.com)

submitted by gchandra(330) 3 years, 11 months ago

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...

add a comment |category: DirectoryServices |Views: 1905

tags: LDAP 2000 DirectoryServices SQL 2005 another

Back to Basics: Count, Count, Count, Sum or how to Count (weblogs.sqlteam.com)

submitted by spirit1(3160) 4 years ago

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: 13

tags: SQLServer 2000 Database 2005 another

Free SQL Server tools that might make your life a little easier (weblogs.sqlteam.com)

submitted by spirit1(3160) 4 years, 2 months ago

Free MS and non MS tools for easoer work with SQL Server 2005 and 2000 read more...

1 comment |category: Database |Views: 62

tags: SQLServer SqlServer2005 2000 2005 Database another

SQL Server: The one and only locale insensitive date format(weblogs.sqlteam.com)

submitted by spirit1(3160) 4 years, 3 months ago

Until recently i've been sure that there are 2 date formats that are completly locale insensitive. Those 2 i are yyyy-mm-dd HH:mm:ss.fff and yyyymmdd HH:mm:ss.fff. And i was proven wrong a few days ago! read more...

2 comments |category: Database |Views: 17

tags: DateTime 2000 SQLServer Database 2005 another

SQL Server: Filtering Numeric data from a character based column(weblogs.sqlteam.com)

submitted by spirit1(3160) 4 years, 3 months ago

Explanation how IsNumeric doesn't really return what you expect it to return and how to overcome the problem in data filtering. read more...

add a comment |category: Database |Views: 6

tags: Filter 2000 IsNumeric Database 2005 another

SSMS Tools Pack - an add-in for SQL Management Studio 2005 is out (bet(weblogs.sqlteam.com)

submitted by spirit1(3160) 4 years, 4 months ago

SSMS Tools Pack is an Add-In (Add-On) for Microsoft SQL Server Management Studio 2005 and Microsoft SQL Server Management Studio Express 2005. It contains a few upgrades to the IDE that I thought were missing from Management Studio. read more...

2 comments |category: Database |Views: 81

tags: 2000 SSMS Add-on add-in Database another

SQL Server: The proper and fastest way to check if rows exist(weblogs.sqlteam.com)

submitted by spirit1(3160) 4 years, 4 months ago

Simple yet very underused way to check if rows matching a condition exist. read more...

add a comment |category: Database |Views: 60

tags: SQLServer EXISTS 2000 Database Tips another

Retrieving Nth Salary in SQL Server 2000 and 2005(hemantg.blogspot.com)

submitted by hemantg(145) 4 years, 7 months ago

Queries to retrive Nth highest or lowest value from a table in SQL Server 2000 and 2005 read more...

add a comment |category: Database |Views: 23

tags: SQLServer 2000 2005 Database SQL another

SQL Server 2000 Does What?(choosing-a-blog-url-sucks.blogspot.com)

submitted by j.monty(1868) 4 years, 10 months ago

After hardening a Production SQL Server Cluster, and reviewing the Secuirty Logs to make sure all was well, among many other strange things I saw SQL Server trying to do, I ran across this gem. read more...

add a comment |category: Database |Views: 2

tags: funny wtf 2000 Security SQL another