Jeff Moden

Forum Replies Created

Viewing 15 posts - 22,771 through 22,785 (of 59,099 total)

RE: Query AD - Script Out of memory

T2000 (9/11/2014)
... but the script stops after some time, "Exception of type 'System.OutOfMemoryException' was thrown".
I'm curious... what kind of system did you run this on and what happened 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)

September 16, 2014 at 8:22 am

#1745795
RE: Storing temporary data within a select statement

smw147 (9/15/2014)
Thanks all. The CTE and rbednarek's solution both worked.
The question now is, what did the changes do to performance and resource usage? The reason I ask 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)

September 16, 2014 at 8:10 am

#1745786
RE: How to etsimate the log file size

Satish Nagaraja (9/16/2014)
Hi All,
I was having interesting discussion on estimation of log file with a fellow collegue who happens to be quite knowledgable as well.
He told me if we identify...
--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)

September 16, 2014 at 8:04 am

#1745784
RE: Display all the Dates of a Week of the current date selected

Thanks. I'm sure that what I wrote could be adapted for MDX but I've never used MDX before. Sorry.
--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)

September 16, 2014 at 12:00 am

#1745665
RE: Display all the Dates of a Week of the current date selected

DECLARE @SomeDate DATETIME;
SELECT @SomeDate = '10 Sep 2014';
--===== This uses a "Goldilocks" (just the right size) Tally table to build
-- a week's worth of...
--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)

September 15, 2014 at 11:43 pm

#1745663
RE: Using COALESCE and also trying to multiply and divide

TomThomson (9/15/2014)
Jeff Moden (9/13/2014)
I do have problems making developers understand such things so I invented the much simpler "DBPC" form of normalization. I simply explain that if I have...
--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)

September 15, 2014 at 11:25 pm

#1745661
RE: Display all the Dates of a Week of the current date selected

Guitar_player (9/15/2014)
Hi,
Yes i think i am nearer but i am struck somewhere like " .Parent.Children " was used on a Member.
As in my scenario 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)

September 15, 2014 at 11:05 pm

#1745657
RE: Swallowing the Camel

To bring what the good Mr. King has observed into the real life methods of current application development, in may cases, here's a twist on his statement...
"Both the object model...
--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)

September 15, 2014 at 5:26 pm

#1745638
RE: Another Way to Look at Trees

g.britton (9/15/2014)
It is dyi version of a recvursive cte but avoids the rbar problem and potential exponential runtime
I love all articles on hierarchies. Thanks for taking the time 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)

September 15, 2014 at 5:14 pm

#1745634
RE: Another Way to Look at Trees

fregatepllada (9/14/2014)
Larry - are you aware that since SQL Server 2008 R2 there is a data type HierarchyID?
If you using anything older than that version there is a Joe Celco...
--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)

September 15, 2014 at 5:04 pm

#1745633
RE: Week Start and End by Month

Eirikur Eiriksson (9/13/2014)
Jeff Moden (9/12/2014)
The following should do it (see attached). I made sure that it's a high performance iTVF instead of an mTVF. I also got rid...
--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)

September 15, 2014 at 4:38 pm

#1745631
RE: Daily CSV import to SQL - How ?

Apologies... really got hammered by work-work.
Are you all set now?
Just as a bit of a sidebar, this is also pretty easy using only T-SQL. If you'd rather do 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)

September 15, 2014 at 9:55 am

#1745523
RE: RECEIVE TOP 1000 Not retrieving 1000 messages

venoym (9/2/2014)
By the way, XQuery is tons slower than OPEN~~QUERY~~XML when you need to shred unknown XML elements.
Heh... I knew what you meant and I find that VERY interesting...
--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)

September 13, 2014 at 11:21 am

#1745275
RE: Using COALESCE and also trying to multiply and divide

TomThomson (9/11/2014)
Luis Cazares (9/11/2014)
You should remember the third normal form: "all the attributes in a table are dependent on the primary key and only the primary key."
While I agree with...
--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)

September 13, 2014 at 11:05 am

#1745271
RE: Using COALESCE and also trying to multiply and divide

Post removed.
--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)

September 13, 2014 at 10:36 am

#1745267

Viewing 15 posts - 22,771 through 22,785 (of 59,099 total)