By tag: 2000
0
kicks
How to Query Active Directory using LDAP in SQL Server 2000 / 2005 ?
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.
0
kicks
Back to Basics: Count, Count, Count, Sum or how to Count
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.
0
kicks
Free SQL Server tools that might make your life a little easier
Free MS and non MS tools for easoer work with SQL Server 2005 and 2000
0
kicks
SQL Server: The one and only locale insensitive date format
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!
0
kicks
SQL Server: Filtering Numeric data from a character based column
Explanation how IsNumeric doesn't really return what you expect it to return and how to overcome the problem in data filtering.
0
kicks
SSMS Tools Pack - an add-in for SQL Management Studio 2005 is out (bet
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.
0
kicks
SQL Server: The proper and fastest way to check if rows exist
Simple yet very underused way to check
if rows matching a condition exist.
0
kicks
Retrieving Nth Salary in SQL Server 2000 and 2005
Queries to retrive Nth highest or lowest value from a table in SQL Server 2000 and 2005
0
kicks
SQL Server 2000 Does What?
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.