Rankings in T-SQL

 Here is a code snippet from The Guru's Guide to Transact-SQL (p. 126): SELECT s.State,  …

Optimizing querries to avoid timeouts

I read somewhere recently on the web that you could optimize a querry. I was wondering if any out …

sp_cursorfetch

Hi All, Any one know what sp_cursorfetch does and what RPC have to do with them? I try to look it u…

BOL Update

Hi there, thought I'd drop this right in http://www.microsoft.com/downloads/details.aspx?familyid…

Date String wont store correctly

Hello, My name is Don. I am new to this board, if this post is in wrong section I apologize. I ne…

How to change EnterpriseMgrs default font

I like to make my stored procedures easy to read with good indentation and alignment. Two other pr…

Global Sequencer

I want to be able to have a Unique sequence number accross multiple tables and databases (like havi…

FOREIGN KEY on Temporary Table?

Question: Is is not possible to add a FOREIGN KEY constraint on a local or global Temporary table? …

Question About DEFAULT

If I have the need to create a new field for a table where records already exist, and that new fiel…

Cannot Re-Publicate Tables

Hello all, Having an Issue setting up Merge replication on an NT 4.0 build 1381 SP 6 using Sql 7.0…

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…