Jeff Moden

Forum Replies Created

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

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
RE: Fibonacci Sequence CTE

Mordred (10/9/2010)
Thanks for your response. I agree with that logic but then why are there so many that would say 55 is the tenth I wonder?
Mostly because they start...
--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:56 pm

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

mjswart (9/22/2010)
Hi Jeff,
Records aren't always stored physically ordered on a data page. Most of the time they are physically ordered correctly, but the actual order comes from the slot...
--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 6:38 pm

#1234654
RE: Fibonacci Sequence CTE

IIRC, by definition, the first Fibonacci number is refererred to as F₀ = 0 and F₁ = 1 soooooo the TENTH number is actually F₉ = 34.
--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 5:54 pm

#1234652

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