Jeff Moden

Forum Replies Created

Viewing 15 posts - 25,066 through 25,080 (of 59,099 total)

RE: Get Groupby hierchy Records

Thank you for posting your solution.
--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)

December 21, 2013 at 8:54 pm

#1675421
RE: will shrink log file or database file cause log file\backup chain to break??

Ratheesh.K.Nair (12/21/2013)
Hi Experts,
Can anyone please let me know whether shrinking log file or database file cause log file\backup chain to break??
Thanks in Advance.
What will break the log chain is setting...
--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)

December 21, 2013 at 7:57 pm

#1675419
RE: Drop & Truncate

ramana3327 (12/21/2013)
Some people say Truncate & Drop are also fullly logging operations but some people are saying these are minimally logged operations. Which is right?
What people refer to as "Fully...
--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)

December 21, 2013 at 7:39 pm

#1675418
RE: display values mutliping with 1 instead of 0 if 0 is present

Try this.
cast( case when b.quantity =0 then 1 else b.Quantity end * a.quantity as numeric(18,0)) as quantity
Not being one that believes in the myth of portability, the following is a...
--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)

December 21, 2013 at 6:00 pm

#1675415
RE: SQL Query (View) vs 2008 R2

I know no one came to your rescue but I sure do appreciate the "log" of the problem. It'll help other folks, I'm sure.
--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)

December 21, 2013 at 5:50 pm

#1675414
RE: Removing the Linked Server 2 hop Limitation

rstone (12/18/2013)
If it is used to connect back to SQL Server using a trusted connection (e.g., SQLCMD -E), it would be running T-SQL as sysadmin.
Shifting gears a bit, I wonder...
--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)

December 21, 2013 at 3:26 pm

#1675411
RE: Return Parent Record value from child records

sturner (12/18/2013)
Jeff Moden (12/18/2013)
If there's only one level of children, such as you might find in an Invoice/InvoiceDetail problem, then I absolutely agree. If it has more than 1...
--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)

December 21, 2013 at 3:11 pm

#1675409
RE: Pass SSIS Object to child SSIS package

Evil Kraig F (12/19/2013)
SSIS however is awesome for laying out processing methodology and calling sequential procedures with obvious and self-documenting logic pathing, however. There's plenty of other things 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)

December 21, 2013 at 2:56 pm

#1675408
RE: How to avoid KeyLookpu in Execution Plan of a Query ?

ScottPletcher (12/19/2013)
wolfkillj (12/19/2013)
ScottPletcher (12/19/2013)
Jeff Moden (12/18/2013)
ScottPletcher (12/18/2013)
If your lookups will most often be by column2, you need to cluster the table on column2, or an encoded version of it, rather...
--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)

December 21, 2013 at 12:19 pm

#1675399
RE: GETUTCDATE() return null

ali.m.habib (12/19/2013)
Jeff Moden (12/18/2013)
I take that back... that's actually an illegal form of update that will sometimes work and sometimes not. I'll explain more after I see the rest...
--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)

December 21, 2013 at 10:23 am

#1675394
RE: Database need to be replicated

river1 (12/20/2013)
I don't have SANs. The SQL Server Instances are on two different servers (each server is a standalone server)
Servers are on different physical places.
Can I create http linked server?
At...
--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)

December 21, 2013 at 10:18 am

#1675393
RE: Are the posted questions getting worse?

We have a wonderful "on call" policy. Anyone and everyone can be called at any time.
The neat thing is that, in the 2 years I've been working for this...
--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)

December 21, 2013 at 10:07 am

#1675392
RE: TD Alignment in Database Mail

freewaresucks (12/20/2013)
This is a really old post i dont expect nothing just mind blowing to me. How in the bleep did you figure that out....... Anyway thanks guys for 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)

December 20, 2013 at 9:34 pm

#1675363
RE: SYNTAX Help please...

ScottPletcher (12/20/2013)
Evil Kraig F (12/20/2013)
ScottPletcher (12/20/2013)
Admittedly the gain is much clearer when the clustering key is the ISNULLed column. So, let's just flip the clustering keys on your original...
--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)

December 20, 2013 at 8:14 pm

#1675358
RE: Sound Matching and a Phonetic Toolkit

AVB (12/20/2013)
I had the same problem of getting the dll to work with 2008. I'm in the process of converting a 2000 db to 2008 and I used that xp_NYSIIS...
--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)

December 20, 2013 at 6:42 pm

#1675356

Viewing 15 posts - 25,066 through 25,080 (of 59,099 total)