Jeff Moden

Forum Replies Created

Viewing 15 posts - 36,871 through 36,885 (of 59,072 total)

RE: Tips for writing queries needed

How ironic... Lynn is in pretty much the same postion at his job right now.
--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 10, 2010 at 7:21 pm

#1219575
RE: Poor performance when all RAM allocated, but not in use

hirro (9/10/2010)
Ran a test while tracking swap file disk usage.
SQL set to use 84 GB max memory
6 seconds for the query
SQL set to use 92 GB max memory
30 seconds for...
--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 10, 2010 at 7:14 pm

#1219572
RE: Poor performance when all RAM allocated, but not in use

hirro (9/10/2010)
Another interesting bit of information:
(Physical RAM Config) SQL Allocation - Time it took
(6x8GB) 48GB allocated to SQL - Query takes 6 seconds
(12x8GB) 84 GB allocated to SQL – Query...
--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 10, 2010 at 7:05 pm

#1219570
RE: Poor performance when all RAM allocated, but not in use

stewartc-708166 (9/10/2010)
Jeff Moden (9/10/2010)
Of course, I could be dead wrong. 😉
I recently had the "pleasure" of troubleshooting why a UAT SQL server regularly stopped working, with error "Insufficient disk space".
SQL...
--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 10, 2010 at 6:59 pm

#1219569
RE: Are the posted questions getting worse?

mtillman-921105 (9/10/2010)
The Dixie Flatline (9/10/2010)
I played a lot of Civilization. It took a while, but it finally dawned on me that the barbarians weren't my true enemies....
--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 10, 2010 at 6:48 pm

#1219565
RE: Are the posted questions getting worse?

Grant Fritchey (9/10/2010)
GilaMonster (9/10/2010)
Jeff Moden (9/10/2010)
I don't have the time to read many books but that was a good one.
Title? Author?
Here you go. First in a trilogy. Ancient stuff.
Ah... that's...
--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 10, 2010 at 9:42 am

#1219295
RE: Are the posted questions getting worse?

GilaMonster (9/10/2010)
Jeff Moden (9/10/2010)
I don't have the time to read many books but that was a good one.
Title? Author?
I only remember that the name of the book was called "Collosus"...
--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 10, 2010 at 9:40 am

#1219293
RE: Are the posted questions getting worse?

Steve Jones - Editor (9/10/2010)
Never read about Collosus. I'm assuming this is the Xmen guy?
I always find time to read. Keeps me sane with a break from this world.
Nope... it...
--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 10, 2010 at 9:37 am

#1219292
RE: Single huge view or mutiple smaller views

clementstore (9/10/2010)
Thanks ppl .
Views generated from both approaches are from same set of tables ( over 100 ) and
they are not partitioned. They are generated by some stored procedures on...
--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 10, 2010 at 6:33 am

#1219126
RE: Oracle Wrap like utility in MS-SQL

Gosh... this seems like a lot of work to keep the honest man honest and does nothing to actually prevent the viewing of the code.
--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 10, 2010 at 6:28 am

#1219123
RE: Poor performance when all RAM allocated, but not in use

Heh... P.S. 15 Seconds for a query may still be too long. 😉
--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 10, 2010 at 6:20 am

#1219117
RE: Are the posted questions getting worse?

Grant Fritchey (9/10/2010)
Alvin Ramard (9/9/2010)
Jeff Moden (9/9/2010)
Alvin Ramard (9/9/2010)
Trey Staker (9/9/2010)
Steve Jones - Editor (9/9/2010)
Twitter is a lot like The Thread, only moving at a slightly faster pace.
You can sign...
--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 10, 2010 at 5:48 am

#1219101
RE: CLR Table-Valued Function Example with Full Streaming (STVF)

Matjaz Justin (9/10/2010)
I would like to take advantage of a chance to join to the discussion with a question which is not directly related to the title but I cannot...
--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 10, 2010 at 5:45 am

#1219099
RE: Using DateDiff to calculate days before a Birthday

Sorry, Ken... I was a bit asleep at the switch and forgot this was for the compact edition (heh... "CE" actually stands for "Crippled Edition", doesn't it? :-P)
There's more than...
--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 10, 2010 at 5:42 am

#1219098
RE: Question: float display as character

Chris Morris-439714 (9/9/2010)
Jeff Moden (9/9/2010)
As a side bar, the "2" option I used in the conversion is the 16 byte option for "E" notation. If I'd used "1", it...
--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 10, 2010 at 5:29 am

#1219091

Viewing 15 posts - 36,871 through 36,885 (of 59,072 total)