Jeff Moden

Forum Replies Created

Viewing 15 posts - 13,081 through 13,095 (of 59,095 total)

RE: Debit Close and Aging

ozelll - Sunday, January 21, 2018 12:42 PM
Yes Jeff Moden 🙂
I'm sorry I do not know english. I use dialing.
Understood and 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)

January 21, 2018 at 2:21 pm

#1976667
RE: Shrink all user database files

RandomStream - Tuesday, January 2, 2018 5:23 PM
Jeff's right but don't be discouraged.
If you're talking about not being discouraged from writing articles, I...
--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)

January 21, 2018 at 2:18 pm

#1976666
RE: Debit Close and Aging

ozelll - Thursday, January 18, 2018 2:16 PM
Hi,
I want to aging.
drop table #TempStk
CREATE TABLE #TempStk(
[ID] [int] IDENTITY(1,1) NOT NULL,
[Ig] [int]...
--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)

January 21, 2018 at 12:22 pm

#1976661
RE: In-Memory tables candidate

89netanel - Sunday, January 21, 2018 3:24 AM
Hello All,
how can i decided which table is candidate from disk table to in-memory table?
and...
--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)

January 21, 2018 at 12:18 pm

#1976660
RE: Stored Procedure Dynamic SQL using sp_executesql Not working

Charles_P - Saturday, January 20, 2018 6:25 PM
I can successfully run a Stored Procedure (SP) that uses dynamic SQL and Exec sp_executesql...
--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)

January 21, 2018 at 8:46 am

#1976653
RE: T-SQL Equivalent to Oracle TRANSLATE

arr.nagaraj - Saturday, January 20, 2018 12:45 AM
Opening a old thread for the benifit of someone landing here via a google...
--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)

January 20, 2018 at 2:41 pm

#1976632
RE: Changing Extensions

The most correct answer is actually missing a step.
--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)

January 20, 2018 at 2:06 pm

#1976630
RE: Trying to delete old log files

HappyGeek - Saturday, January 20, 2018 8:10 AM
Post is 9 years old, surprised it has resurfaced, Jeff you are right. Not 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)

January 20, 2018 at 1:38 pm

#1976626
RE: Question Regarding Date logic

KGJ-Dev - Friday, January 19, 2018 11:23 AM
Hi Chris and Jeff thank you for the replies. i will hold these values in...
--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)

January 19, 2018 at 4:49 pm

#1976606
RE: Trying to delete old log files

larry Hennig - Friday, February 6, 2009 12:33 PM
CmdShell is a huge security hole. Does anyone have an SSIS package or...
--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)

January 19, 2018 at 4:37 pm

#1976604
RE: Question Regarding Date logic

KGJ-Dev - Friday, January 19, 2018 9:16 AM
Hi,
I need to get Year, monthname in three letters, startdate and enddate of 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)

January 19, 2018 at 10:30 am

#1976542
RE: Need to convert lowercase characters to 'a' and uppercase to 'A'

srikanthrv - Friday, January 19, 2018 6:24 AM
Hi,
I have a requirement to anonymise the data in table by replacing all the lowercase...
--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)

January 19, 2018 at 9:59 am

#1976537
RE: Running out of space on Server OS drive, where SQL Server app located, what to clear out?

Perry Whittle - Friday, January 19, 2018 4:51 AM
Jeff Moden - Tuesday, January 16, 2018 11:23 AM
--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)

January 19, 2018 at 7:22 am

#1976505
RE: identify missing index for query

ChrisM@Work - Friday, January 19, 2018 5:18 AM
Grant Fritchey - Friday, January 19, 2018 5:10 AM
--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)

January 19, 2018 at 7:19 am

#1976503
RE: Are the posted questions getting worse?

ChrisM@Work - Friday, January 19, 2018 6:26 AM
You guys have caused quite a stir here.
Heh... I have to "blame" it all on Brent. ...
--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)

January 19, 2018 at 7:13 am

#1976500

Viewing 15 posts - 13,081 through 13,095 (of 59,095 total)