what is clustring

Simple case-sensitive groupings

Hi- I'm in the U.S. so I leave all the collation settings to the default. However, now I want to gr…

Sales Snapshot

I have a rather interesting task of creating a sales snapshot of our products for our DW. There is …

JDBC 2.2.0029, SP1

We may need to upgrade the JDBC driver for SQL Server 2000 to communicate properly with ColdFusion …

Tools for users to browse Cubes?

I'm curious to know what user front-end tools you all use to browse your OLAP Cubes? When Cubes fir…

Help with indexes

Hi,   I'm in the process of trying to optomise some search queries and was looking for some he…

SqlAgentMail does not work with win2003 server

  We just upgraded our database (sql 2000 sp3) to a new machine running windows 2003 server os…

Database owner with limited permission

Hi, Here is my case :     I have created development databases for each  develo…

ISNUMERIC()

If I use the following statement: CASE WHEN ISNUMERIC(Field) = 1 THEN CAST(Field as Numeric) ELSE 0…

How are usernames checked?

Hi there, How are new usernames actually checked? It might lead to irritations when you allow Jonat…

MS T-SQL Exercises

http://sql.ipps.ru/index.php?Lang=1

Is it possible to change sql server 2000 machine’s date from QA.

Is there any other function or way to change the database’s machine date from QA ..Better Than Bef…

How to pass TABLE datatype as input parameter to a stored procedure

Hello, I am interested in passing table datatype as an input parameter to a stored procedure. …

BLOBs (binary large objects)

Does anyone have any good tips on how to use BLOBs to store image/videos within SQL Server and how …

Errorlog grows quickly

What can be the cause of error log which is growing quickly ,The errorlog show this type of entry :…