Error!
Success!

By tag: 2000

showing:  of
0
kicks

XML into SQL Server 2000  (Unpublished)

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


Kicked By:
Drop Kicked By:
0
kicks

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

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.


Kicked By:
Drop Kicked By:
0
kicks

Back to Basics: Count, Count, Count, Sum or how to Count  (Unpublished)

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.


Kicked By:
Drop Kicked By:
0
kicks

Free SQL Server tools that might make your life a little easier  (Unpublished)

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


Kicked By:
Drop Kicked By:
0
kicks

SQL Server: The one and only locale insensitive date format  (Unpublished)

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!


Kicked By:
Drop Kicked By:
0
kicks

SQL Server: Filtering Numeric data from a character based column  (Unpublished)

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


Kicked By:
Drop Kicked By:
0
kicks

SSMS Tools Pack - an add-in for SQL Management Studio 2005 is out (bet  (Unpublished)

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.


Kicked By:
Drop Kicked By:
0
kicks

SQL Server: The proper and fastest way to check if rows exist  (Unpublished)

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


Kicked By:
Drop Kicked By:
0
kicks

Retrieving Nth Salary in SQL Server 2000 and 2005  (Unpublished)

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


Kicked By:
Drop Kicked By:
0
kicks

SQL Server 2000 Does What?  (Unpublished)

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.


Kicked By:
Drop Kicked By: