Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,356 through 20,370 (of 59,098 total)

RE: Executing SQL Job from SProc

john.clyma 97764 (6/15/2015)
The .exe is on the same box that is running SQL
Perfect. The other questions would be...
1. Does the exe require any user input after it starts?
2....
--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 15, 2015 at 9:12 am

#1805483
RE: Keepinga running total?

jbalbo (6/15/2015)
Yes it would...:)
Sorry, Rainy Monday morning...
Thanks
Heh... not a problem and right there with you. I thought I might be missing something because I answered prior to my...
--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 15, 2015 at 9:09 am

#1805482
RE: Executing SQL Job from SProc

Which box is the .exe actually on? The SQL Server box or something else?
--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 15, 2015 at 8:59 am

#1805476
RE: Keepinga running total?

Wouldn't a simple COUNT with a GROUP do the trick for you?
--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 15, 2015 at 8:58 am

#1805474
RE: How do I do a search on a string ( But I need it to be case sensitive )

mw112009 (6/15/2015)
Thank you that works!
I owe you a beer.
Beer? BEER? [font="Arial Black"]BEER![/font] Heh... ok... where are you at in the world? I might just try 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 15, 2015 at 8:39 am

#1805467
RE: Five Minute Refactoring

I don't argue with people about things in code. I let the code do the talking. If they come up with better code (performs better, more scalable, easier...
--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 15, 2015 at 8:26 am

#1805459
RE: How do I do a search on a string ( But I need it to be case sensitive )

mw112009 (6/15/2015)
Select * FROM TAB1 wher AI_TEXT_VALUE like '%PE%'
The unfortunate thing is i get entries like <Perennial allergic rhinitis>
I am looking specifically for the term PE ( 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)

June 15, 2015 at 8:16 am

#1805457
RE: Moving large databases from SQL Server 2005 to 2008

Jacob Wilkins (6/15/2015)
You can mirror from an older version to a newer version (like 2005->2008), but it's a one way trip. You can fail over to the 2008 instance, but...
--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 15, 2015 at 7:28 am

#1805444
RE: Are the posted questions getting worse?

Ed Wagner (6/15/2015)
BrainDonor (6/15/2015)
For those that have an interest in martial arts - specifically the Katana.
An intersting video of Machii Isao, assisting in the configuration of an industrial robot, so...
--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 15, 2015 at 6:48 am

#1805432
RE: Are the posted questions getting worse?

BWFC (6/15/2015)
Something similar to this Jeff?
Heh... That's the very scene I think of in all such conversations. It's one of my favorites. 😀
--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 15, 2015 at 6:39 am

#1805430
RE: Are the posted questions getting worse?

BrainDonor (6/15/2015)
For those that have an interest in martial arts - specifically the Katana.
An intersting video of Machii Isao, assisting in the configuration of an industrial robot, so 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 15, 2015 at 6:17 am

#1805426
RE: Dynamic Conversion of PIVOT COLUMNS

ramrajan (6/15/2015)
I have attached SQL File which Gives me the below resultset Excel.xlsx
But the problem is i am not able to round off the dynamic columns in side my PIVOT...
--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 15, 2015 at 6:13 am

#1805425
RE: SQL Database Administration

Ed Wagner (6/15/2015)
I would start with this:
1. When are the backups taken?
2. Where are the backups stored?
3. Are the backups viable? Can they be used to restore? 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)

June 15, 2015 at 6:09 am

#1805424
RE: Moving large databases from SQL Server 2005 to 2008

Does anyone have any info on whether or not it's possible to mirror a 2005 server to a 2008 server? I was pretty sure that they had to be...
--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 14, 2015 at 9:20 pm

#1805385
RE: log file does not match primary file

The safest thing to do for the future would be nightly full backups and log file backups every 15 minutes. That way, you'd never lose more than 15 minutes...
--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 14, 2015 at 9:12 pm

#1805384

Viewing 15 posts - 20,356 through 20,370 (of 59,098 total)