Jeff Moden

Forum Replies Created

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

RE: Shrink File by using empty file option

glugingboulder - Monday, May 10, 2010 5:57 PM
...some index fragmentation we can live.
While I'll be the first to agree with the fact...
--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 22, 2018 at 6:05 am

#1976707
RE: Shrink File by using empty file option

glugingboulder - Monday, May 10, 2010 7:55 PM
not sure what you mean by system objects left in the *.mdfI can create 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)

January 22, 2018 at 5:59 am

#1976706
RE: Changing Extensions

ildjarn.is.dead - Monday, January 22, 2018 3:47 AM
The question isn't "What is the easiest way" but "what should I do". And adding...
--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 22, 2018 at 5:44 am

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

Charles_P - Sunday, January 21, 2018 8:18 PM
Thank Jeff!
Using the text mode for
PRINT @ColumnsForCREATE;
PRINT @ColumnsForSELECT;
It clearly showed me that I was...
--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 22, 2018 at 5:19 am

#1976702
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

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