Jeff Moden

Forum Replies Created

Viewing 15 posts - 27,556 through 27,570 (of 59,101 total)

RE: Preparing for a job interview...

There's some awfully good advice on this thread. I especially agree with the idea of instead of prepping as a person running FROM a job, prep as a person...
--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)

February 5, 2013 at 4:55 pm

#1584669
RE: To Find jobs related to a particular database.

JeremyE was trying to teach you something new, Sue. Take a look at the two tables he recommended and you'll see how easy it is to do. 😉
--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)

February 5, 2013 at 4:38 pm

#1584664
RE: Count Decimal Places

Markus S. Gallagher (2/5/2013)
Slight improvement that works for decimal datatype:
CASE WHEN FLOOR(LOG10(REVERSE(ABS(Wert)+1)))+1 < 0 THEN 0 ELSE FLOOR(LOG10(REVERSE(ABS(Wert)+1)))+1 END
Slight improvement how? Is it faster?
--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)

February 5, 2013 at 7:52 am

#1584392
RE: Issue with crypt_gen_random

That would be 2k8 R2, IIRC. I don't have that particular version. I've got 2k5 and 2k8 fired up because that's what I have at work. Hopefully,...
--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)

February 5, 2013 at 7:48 am

#1584387
RE: I need to read the xml which is passed as an variable in stored procedure ?how to achieve that ?

maida_rh (2/3/2013)
I used this url for insertion using XML:
msdn help for OPENXML (Transact-SQL)
Ah! I see.
There are some myths and truths about performance and memory usage concerning OPENXML...
--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)

February 4, 2013 at 8:10 pm

#1584163
RE: Create a Column That holds the SUM of values in the same field where The Invoice Number is the same

anthony.green (2/4/2013)
Jeff Moden (2/1/2013)
anthony.green (2/1/2013)
ChrisM@Work (2/1/2013)
Or this:
SELECT
T1.IDCUST,
T1.IDINVC,
T2.AMTPAYM,
TotalPayment = SUM(AMTPAYM) OVER (PARTITION BY IDCUST, IDINVC)
FROM MyTable1_ARIBH T1
INNER JOIN MyTable2_ARTCP T2
ON T2.IDCUST = T1.IDCUST
AND T2.IDINVC...
--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)

February 4, 2013 at 7:06 pm

#1584161
RE: Antipathy for Entity Attribute Value data models

David.Poole (2/4/2013)
I know a lot of good folks looked at that and, having worked with Adjacency Lists where both the child and parent IDs are numeric, might wonder why 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)

February 4, 2013 at 7:02 pm

#1584160
RE: Query to sum only few values in a same column

@park1432,
Two way street here. We're actually interested in your problem and would like a bit more info if, for nothing else, a little education on a strange request. 😉
--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)

February 4, 2013 at 6:05 pm

#1584157
RE: 10 physical disks available - best configuration for data/log/backup?

The original layout isn't bad although I'd be tempted to NOT mirror backup drives and I'm pretty sure you won't need 600GB of LDF space for a 600GB set 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)

February 3, 2013 at 3:32 pm

#1583755
RE: Create string using input values

tnk7200 (2/3/2013)
Jeff Moden (1/28/2013)
C'mon, folks! Just look at the mess of code that a While loop makes for this! No one should be writing a While Loop 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)

February 3, 2013 at 3:20 pm

#1583754
RE: 10 physical disks available - best configuration for data/log/backup?

To answer that question, my experience has been that the more spindles you can involve, the better the performance. A lot of SAN folks will argue against that but...
--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)

February 3, 2013 at 1:38 pm

#1583748
RE: Log file growing on principal server--log backups scheduled every 2 hrs.

HarryG24 (2/1/2013)
Thanks Gail. I increased the frequency of logbackups.
I tried shrinking because, my log file size is 60 GB and a log backup releasing 90% of space.
that was my...
--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)

February 3, 2013 at 11:43 am

#1583735
RE: Query to sum only few values in a same column

park1432 (2/3/2013)
Thank you very much. This will work for me now.
Since you're new, I have to ask, which one is the [font="Arial Black"]"This"[/font] you speak of and why did 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)

February 3, 2013 at 11:27 am

#1583733
RE: Full & Simple Recovery Model

msocp (2/3/2013)
I know about Full Recovery Model & Simple Recovery model.
there are Five production DB Server. two 24/7 live production server contain one database each DB contain 35 tables....
--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)

February 3, 2013 at 10:57 am

#1583731
RE: The Optimists

Jeff Moden (1/28/2013)
bryce.hill (1/25/2013)
It is painfull to make changes because you use SQL Server. It is a shite product that should never be used by a real company and 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)

February 3, 2013 at 10:51 am

#1583730

Viewing 15 posts - 27,556 through 27,570 (of 59,101 total)