Jeff Moden

Forum Replies Created

Viewing 15 posts - 26,671 through 26,685 (of 59,099 total)

RE: Quickly Copy Data

David.Poole (6/10/2013)
Post-It notes for defects are good as well though for some reason I've started to have nightmares about Sesame Street.
Heh... and "Agile Scrums". 🙂 "Big Bird" attends both.
--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)

June 10, 2013 at 12:34 pm

#1622575
RE: Import Dynamic File Name with a Date/Time as the file type (YYYYMMDDHRMMSS)

opc.three (6/10/2013)
If anyone is interested in taking the detour named "xp_cmdshell" (I am not) please see these posts below where Jeff, and sometimes myself too, espouse the merits and demerits...
--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)

June 10, 2013 at 12:32 pm

#1622574
RE: Import Dynamic File Name with a Date/Time as the file type (YYYYMMDDHRMMSS)

And I'll encourage anyone and everyone to turn it on and leave it on because having it on isn't a security problem. Only those that can use it can...
--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)

June 10, 2013 at 8:11 am

#1622457
RE: help getting return of function and loop into stored proc

plivingstone (6/10/2013)
StackOverFlow: calculate 3 working days before in stored proc using Holidays lookup table
It's a funny thing that people think that recalculating the same thing over and over is 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)

June 10, 2013 at 8:05 am

#1622456
RE: Quickly Copy Data

EdVassie (6/10/2013)
There are other ways of tackling this issue, but they do not exist yet for SQL Server.
Back in the late 1990's a number DB2 shops stopped taking full backups...
--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)

June 10, 2013 at 7:43 am

#1622438
RE: Restore existing database failed due to space issue

Compassionate (6/9/2013)
I have executed shrink database option from MSMS.After this below are the stats
1) LDF - 1024KB
2) MDF - 154MB
3) Recovery modle - simple
Now I have 83GB space to restore...
--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)

June 9, 2013 at 9:09 pm

#1622299
RE: Import Dynamic File Name with a Date/Time as the file type (YYYYMMDDHRMMSS)

opc.three (6/9/2013)
Note that xp_dirtree is an undocumented stored procedure.
I absolutely agree. It would be much better to use something that's not only well documented, but tried and true, as...
--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)

June 9, 2013 at 9:02 pm

#1622297
RE: Restore existing database failed due to space issue

Compassionate (6/9/2013)
All,
I have two data servers S1 and S2. I have a database D1. D1 exists in both S1 and S2. S2 is a prod database and we have to...
--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)

June 9, 2013 at 11:05 am

#1622274
RE: Convert Column into rows depending on Date.

micheltomes (6/8/2013)
I think my friend , gave you right script. So not need to give more details. Please check the code and use it. I think will some all problem.
Spam...
--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)

June 8, 2013 at 11:26 pm

#1622267
RE: Fizz Buzz interview questions for phone screens?

Steven Willis (6/7/2013)
[off topic]
Jeff, keep it up!
I've learned more from your articles and posts here and elsewhere just in the last year or so than in the previous decade....
--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)

June 8, 2013 at 8:51 am

#1622230
RE: Performace issue while updating records and trigger on table

nil.hajare (6/7/2013)
Thanks,
I am new on sql server. Any suggestions would be helpful for me to rewrite this trigger.
Could you please help me on this?
Yes. Before you take anyone's word...
--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)

June 7, 2013 at 4:45 pm

#1622202
RE: Performace issue while updating records and trigger on table

Lowell (6/7/2013)
it's going to look a lot like this:
the only thing i could not determine was the primary key that woudl related the INSERTED to the DELETED ; your example...
--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)

June 7, 2013 at 4:44 pm

#1622201
RE: Issue while joining two tables with no unique columns

nidhi.finance1 (6/7/2013)
Thanks. Issue is resolved now 🙂
Cool. Please post the solution so we can learn from it. Thanks.
--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)

June 7, 2013 at 1:14 pm

#1622163
RE: help getting return of function and loop into stored proc

plivingstone (6/7/2013)
thanks I got some answers on StackOverflow, one even using master..sp_spt
Cool. What's the link for that?
--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)

June 7, 2013 at 12:53 pm

#1622158
RE: get lookup data

Ed Wagner (6/7/2013)
However the columns are named, you can use the query from the first structure to discern the query for your actual table structure. Also, don't discount Jeff'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)

June 7, 2013 at 12:43 pm

#1622156

Viewing 15 posts - 26,671 through 26,685 (of 59,099 total)