Is there a "My posts" link where I can look through the posts I replied to see if there are any newer replies?

Also, the headers and the buttons are quite...

You can generate a row number as shown here: http://www.sqlteam.com/article/returning-a-row-number-in-a-query

If you are still in 2000, check if this helps : http://dotnetjunkies.com/WebLog/dinakar/articles/136661.aspx

kind of late reply but coming from the other part of the world its hard to outsouce DBA. Most (almost 95%) of the data centers are here in US. India...

declare @i decimal(10,2)

Set @i = 1078.734

select (left(@i, Charindex('.', @i, 1) - 1 ))

Sure, Thanks Rachel.

Ys if you try to create index on the same columns via diff jobs or diff transactions there is a high chance od deadlock. create index creates a table level...

Dropping and recreating the proc helps to remove any previous query plans from the proc. Generally its a good practice to drop/recreate as

IF Exists (SELECT * FROM Sys.objects Where Name...

Hi Rachel

I would be interested in the "Friends" program..What would I need to do? I didnt find any link to sign up. Also I dont see any list of the...

You can actually disable the splash screen by right clicking on the Management Studio under your programs -> SQL Server 2005 -> Mgmt Studio and add ".... -nosplash" at the...

Check out HP Super dome = 32 processors (each 64 bit) up to 128 GB RAM.

They also have mini domes = half the config above (aproxly).

And..(1) You are using functions on column names

(2) You are using DISTINCT , ORDER BY which use tempdb. So if you have multiple calls to the proc your tempdb...

You need to write a function that takes in the ID and returns a concatenated string of Values. create a function with something like this:

declare @res varchar(100)

select @res = isnull(@res,''...

you need to use sp_Repladdcolumn, sp_Repldropcolumn to add/drop columns for tables that are being replicated.

Well, perhaps that has got something to do with your UserId

Its like the Cox commercial thats being aired these days..