Viewing 15 posts - 4,666 through 4,680 (of 14,953 total)
Kit G (3/9/2011)
CirquedeSQLeil (3/9/2011)
GSquared (3/9/2011)
CirquedeSQLeil (3/9/2011)
GilaMonster (3/9/2011)
*sigh* I know I'm a little short tempered due to lingering jetlag ...
I know the feeling (done the jetlag thing several times).
It was also...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 9, 2011 at 1:30 pm
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 9, 2011 at 1:23 pm
Ironic that in a post about removing duplicates ....
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 9, 2011 at 12:51 pm
SKYBVI (3/9/2011)
Now I got the mail body as :-ITEMNMBR ------------------------------- No items Inserted
Regards,
Sushant
Is that what you want? It seems to be, from the prior post, but I'm not...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 9, 2011 at 12:50 pm
CirquedeSQLeil (3/9/2011)
GilaMonster (3/9/2011)
*sigh* I know I'm a little short tempered due to lingering jetlag ...
I know the feeling (done the jetlag thing several times).
It was also difficult for me transitioning...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 9, 2011 at 12:46 pm
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 9, 2011 at 12:44 pm
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.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 9, 2011 at 12:30 pm
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,...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 9, 2011 at 12:28 pm
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 9, 2011 at 12:23 pm
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;
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 9, 2011 at 12:17 pm
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.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 9, 2011 at 12:15 pm
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 9, 2011 at 12:13 pm
You'll need to restore a backup from before the truncation, and pull the data out of that.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 9, 2011 at 12:08 pm
Use the Windows Update tool. That'll work in most cases.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 9, 2011 at 11:22 am
Phil Parkin (3/9/2011)
Code-1029433 (3/9/2011)
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 9, 2011 at 11:20 am
Viewing 15 posts - 4,666 through 4,680 (of 14,953 total)