Jeff Moden

Forum Replies Created

Viewing 15 posts - 36,421 through 36,435 (of 59,102 total)

RE: csv string

Heh... there's another couple of enhancements to make that came up recently... some for performance (2 to be precise) and some for those bloody "space" delimiters. I'm just not...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

October 10, 2010 at 6:55 pm

#1234740
RE: project

kanika.bhagat (10/10/2010)
hi,
I have one table student and three fields mtt1,mtt2 and sum.I want to update sum field whenever there is a new value inserted in mtt1 and mtt2.I want to...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

October 10, 2010 at 5:51 pm

#1234735
RE: Extended Store Procedures in Functions workaround suggestions?

Gosh... the function doesn't even use the ProductID for anything except an error message. Are you sure that's right?
I'd also be tempted to make one pass per column instead...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

October 10, 2010 at 5:43 pm

#1234734
RE: script on all databases

You collect a bunch of data and never use it. I'm just curious as to why not.
Also, it's a form of "Death by SQL" to hardcode a user name...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

October 10, 2010 at 5:38 pm

#1234733
RE: csv string

WayneS (10/10/2010)
Using the DelimitedSplit8K function, you would end up with:
DECLARE @String1 varchar(8000),
@String2 varchar(8000);
SET @String1 = 'a,b,c,d';
SET @String2 = 'apple,boy,college,dog';
SELECT a.Item, b.Item
...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

October 10, 2010 at 5:32 pm

#1234731
RE: Solving the "Running Total" & "Ordinal Rank" Problems (Rewritten)

I believe that the MAXDOP 1 option and TABLOCKX hint are still required.
Unless parallel processing jumped in at just the right spot, the serial processing of a single CPU is...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

October 10, 2010 at 5:11 pm

#1234729
RE: Differences

erwin.oosterhoorn (10/8/2010)
I am getting intrigued now, Jeff removed his comment twice...
Actually, just once. I hit {QUOTE} instead of edit during the first edit and it spawned another post instead...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

October 10, 2010 at 10:56 am

#1234707
RE: similar like Oracle RAC

PaulB-TheOneAndOnly (10/8/2010)
grahamc (10/8/2010)
So if its a memory, CPU issue, it will scale.... Cool!!! Thank you makes a little more sense now
The focus of Oracle RAC is high availability 🙂
You...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

October 10, 2010 at 10:47 am

#1234706
RE: Are the posted questions getting worse?

Gianluca Sartori (10/8/2010)
At last, Mr. Celko gives a polite and useful answer to a poor-worded question.
It's nice to see everyone can learn.
Heh... the lion sleeps. That wasn't being polite...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

October 10, 2010 at 10:43 am

#1234705
RE: Finding Sequences (Need help ASAP)

Heh... I'm paranoid but I'm not sure that I'm paranoid enough. 😛 It turns out that I changed the test data and had done some formatting for the...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

October 10, 2010 at 10:22 am

#1234703
RE: Finding Sequences (Need help ASAP)

WayneS (10/10/2010)
As usual, Jeff has an excellent solution.
I did notice one, well, issue with it. It is assuming that the control numbers will have a prefix, followed by 9 zero-padded...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

October 10, 2010 at 9:21 am

#1234697
RE: Witch query is more efficient??

ahmed.net (10/9/2010)
Witch query is more efficient??
Table Structure:
CREATE TABLE [dbo].[tbl_test](
[ID] [int] NOT NULL,
[Title] [varchar](500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
CONSTRAINT [PK_tbl_test] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF)...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

October 9, 2010 at 11:35 pm

#1234665
RE: How to insert 1 to count rows in temp table based on value in another table

jeffrey.davis (10/9/2010)
Hoping someone can help me.
I am trying to create a function that will return a table result that will have ID and COUNT. I am trying to create...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

October 9, 2010 at 8:26 pm

#1234662
RE: Upgrading from 2000 to 2008 performance issue

reggie burns-317942 (10/7/2010)
I am planning and testing an upgrade infrastructure of a OLTP database that is running on 2000 and moving to 2008. The problem that I'm having is that...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

October 9, 2010 at 8:15 pm

#1234660
RE: Data Portability

bitbucket-25253 (10/9/2010)
Steve thanks for a great idea ... My mother-in-law has a medical bracelet which appears to be nothing more than be a thumb nail with a form and program...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

October 9, 2010 at 7:59 pm

#1234658

Viewing 15 posts - 36,421 through 36,435 (of 59,102 total)