Kit G (3/9/2011)

---

CirquedeSQLeil (3/9/2011)

---

GSquared (3/9/2011)

---

CirquedeSQLeil (3/9/2011)

---

I know the feeling (done the jetlag thing several times).

It was also...

Something like this will do a full dedupe. It won't leave deliberate dupes intact. The only way I can think of to do that would be a full...

Ironic that in a post about removing duplicates ....

Is that what you want? It seems to be, from the prior post, but I'm not...

CirquedeSQLeil (3/9/2011)

---

I know the feeling (done the jetlag thing several times).

It was also difficult for me transitioning...

Sounds like homework, but it was interesting enough to get my attention anyway.

Maybe something like this:

-- Test Data

CREATE TABLE #T

(Prod CHAR(3),

Ref...

At the beginning of the proc, after "AS", add "SET NOCOUNT ON".

create procedure [dbo].[insert_kit_components]

as

SET NOCOUNT ON;

INSERT INTO dbname.dbo.IV00104

That should get rid of that part.

And what do you want to do if the word has a legitimate repeat in it? Aardvark, apple, peer, assimilate, better, coordinate, dunnage, tonne, etc., all have repeating letters,...

The DBCC command is really meant to be an option if you're not auto-updating stats, or if the automatic updates fail to work as expected.

On large, high-traffic tables, with lots...

Here's an example of how to do it:

CREATE TABLE My_Table (ID INT IDENTITY PRIMARY KEY);

GO

ALTER TABLE My_Table ADD [rowguid] [uniqueidentifier] ROWGUIDCOL NOT NULL DEFAULT (NEWID());

GO

DROP TABLE My_Table;

You can limit the maximum number of concurrent connections, but it's more usual to use connection pooling or whatever in your data access layer, instead of at the database server.

The "print" command is really only useful if you're calling the procedure from Management Studio. It doesn't really do much if you call the procedure from an application or...

You'll need to restore a backup from before the truncation, and pull the data out of that.

Use the Windows Update tool. That'll work in most cases.

Phil Parkin (3/9/2011)

---

Code-1029433 (3/9/2011)

---

Hi Guys,

I've been searching the forums trying to find the answer to my question but I'm not having much luck. The majority of our clients...