Jeff Moden

Forum Replies Created

Viewing 15 posts - 26,941 through 26,955 (of 59,101 total)

RE: Function To Add [n] Days to A Date and Adjust to the Nearest Business Date

I really like how easy CROSS APPLY made it to calculate some of the more complex holidays. Well done, Chris.
--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)

April 24, 2013 at 5:28 am

#1609415
RE: Why powershell?

opc.three (4/23/2013)
The point is, using xp_cmdshell limits your options. It paints you into a corner. PowerShell has 100% functionality coverage, and infinitely more, over CmdShell. And when run separate from...
--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)

April 24, 2013 at 4:57 am

#1609404
RE: Why powershell?

opc.three (4/23/2013)
Jeff Moden (4/23/2013)
opc.three (4/23/2013)
If you ever find yourself needing to implement functionality that crosses the OS/SQL Server gap then PowerShell can fill that need quite nicely for you. PowerShell...
--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)

April 23, 2013 at 5:46 pm

#1609311
RE: Are the posted questions getting worse?

Steve Thompson-454462 (4/23/2013)
Brandie Tarvin (4/22/2013)
Hey guys, I need your help please. On Wednesday we're having a "bring the kids to work day" and I'm helping out. I've been asked 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)

April 23, 2013 at 5:32 pm

#1609309
RE: Are the posted questions getting worse?

jasona.work (4/23/2013)
Frickin fracking g***amn locked down idiot nitwit domains!!!
Fracking place implemented / started enforcing a policy that prevents ANY accounts from having the "replace a process level token" privilege, thereby...
--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)

April 23, 2013 at 5:30 pm

#1609308
RE: The Cascading (CROSS) APPLY

Divya Agrawal (4/22/2013)
Chris,
i think its better to use xml instead of DelimetedSplit8K function. Here, is my post on it, http://www.sqlservercentral.com/articles/XML/66932/
let me know your views.
Divya,
First, that's a nice clear article...
--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)

April 23, 2013 at 5:14 pm

#1609305
RE: Transaction Log Growing due to Pending Transaction (Replication)

MannySingh (4/9/2013)
Jeff Moden (4/8/2013)
MannySingh (4/8/2013)
Anyone..
Are you doing transaction log backups?
if you check my question.. i have already mentioned the DB is in simple recovery mode, so Log backups are out...
--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)

April 23, 2013 at 5:06 pm

#1609304
RE: Why powershell?

opc.three (4/23/2013)
If you ever find yourself needing to implement functionality that crosses the OS/SQL Server gap then PowerShell can fill that need quite nicely for you. PowerShell is also very...
--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)

April 23, 2013 at 4:52 pm

#1609301
RE: ssis data flow task taking an extremely long time .

Are both databases on the same server?
--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)

April 22, 2013 at 8:03 pm

#1608910
RE: Are the posted questions getting worse?

Evil Kraig F (4/22/2013)
Jan Van der Eecken (4/22/2013)
...Don't mind the goldfish...
Now we eventually know what that avatar of yours represents 🙂
LOL, actually it was the closest I could get 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)

April 22, 2013 at 5:26 pm

#1608903
RE: T-SQL HELP NEEDED

fadewumi (4/22/2013)
is there any website to learn this sql database very well
Heh... you're on it now. 😉
--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)

April 22, 2013 at 2:30 pm

#1608853
RE: T-SQL HELP NEEDED

Remember the warning about using statistics to measure performance of functions. Although iTVFs fair better in this area than scalar functions, they're still affected. The best way 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)

April 22, 2013 at 10:00 am

#1608745
RE: Urgent help!

S_Kumar_S (4/22/2013)
But the transaction that xp_cmdshell did was quite small: just creating a test file. it should have taken less than a second to roll it back.
Will killing the explorer.exe...
--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)

April 22, 2013 at 9:54 am

#1608742
RE: Is it possible to create tables Dynamically using Cursors from another table with csv values

ChrisM@Work (4/19/2013)
This is an unusual transport file with metadata (partial, column names only) and data as string on the same row.
BWAAAA-HAAA!!!!! I say the same thing everytime I have...
--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)

April 22, 2013 at 6:24 am

#1608656
RE: tsql query - Count the number of spaces in a string

You good folks are too kind. :blush: I'm just trying to help because I didn't have any help when I started and know what that's like. Thank all...
--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)

April 21, 2013 at 9:03 pm

#1608573

Viewing 15 posts - 26,941 through 26,955 (of 59,101 total)