Jeff Moden

Forum Replies Created

Viewing 15 posts - 23,746 through 23,760 (of 59,102 total)

RE: Min and Max Number from string

yogi123 (4/30/2014)
Hello everyone
I need help to develop logic. In my query i have Alpha Numeric string with commas and hyphens.so from the string i need to populate min and max...
--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 30, 2014 at 9:17 am

#1709886
RE: Covert all characters in field into their ASCII code

LoosinMaMind (4/30/2014)
Never more than 5 characters as per 1st post.
so the ASCII string will be at most 15 charcters long i guess thus not causinga problem for the numeric...
--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 30, 2014 at 9:09 am

#1709881
RE: 166 days to create index

@scott_lotus,
I agree with Grant and I believe that you'll find that most of the heavy hitters (on this site, anyway) are very leary of taking DTA at its 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)

April 30, 2014 at 7:38 am

#1709831
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

I was really looking forward to that type of fuctionality. It IS a step in the right direction, though. Thanks, Paul.
--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 29, 2014 at 9:08 pm

#1709683
RE: Add Network Places using PoSh

schleep (4/29/2014)
I'm getting a new Windows 7 desktop. From a powershell perspective, probably a good thing.
But, I have a goodly number of Network Places mapped on my XP box, 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)

April 29, 2014 at 8:52 pm

#1709682
RE: Looking for a SQL Server DBA 2005 or 2008 internship or volunteer opportunity

@olufemi.sonuga,
I realize you might not be hanging around these forums anymore but thought I'd ask anyway... how'd you make out on this?
--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 29, 2014 at 8:50 pm

#1709681
RE: Looking for a SQL Server DBA 2005 or 2008 internship or volunteer opportunity

RonMani (4/29/2014)
where was the forum moved to?
Dave didn't move the forum... he just moved this post (more than a year ago, now). The forum is in the Dark Blue...
--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 29, 2014 at 8:48 pm

#1709680
RE: 166 days to create index

As Grant said, it looks like the system might be waiting on file growth. Make an educated guess on how big the Leaf Level of the index is going...
--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 29, 2014 at 8:41 pm

#1709679
RE: Creating alias for a database

They created the database names with the environment suffix to make sure that applications under test don't accidently point to production. It's a real PITA for DB folks, especially...
--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 29, 2014 at 8:18 pm

#1709678
RE: Covert all characters in field into their ASCII code

LoosinMaMind (4/29/2014)
How can I convert each character into its ASCII equivalent?
Expected Results
485012167
49507156
578011249
556411776
Does the result need to be reversable and/or totally unique if totally unique orginal values are provided?
For example, 1212121212,...
--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 29, 2014 at 6:15 pm

#1709672
RE: Covert all characters in field into their ASCII code

Reversal isn't the point I was trying to make. Your code did silent truncation on that last value (has 6 characters) which represents what can happen over time with...
--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 29, 2014 at 6:08 pm

#1709670
RE: trigger to call a program to write a text file onto a folder in the server

xp_CmdShell uses a differnent session than the session the trigger is involved with. I also don't see where you're identifying a record to the .exe (of course, I don't...
--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 29, 2014 at 4:54 pm

#1709665
RE: Covert all characters in field into their ASCII code

ScottPletcher (4/29/2014)
For only 5 chars, I wouldn't bother will all the CTEs and related folderol.
Why not just:
SELECT
ISNULL(CAST(ASCII(SUBSTRING(data, 1, 1)) AS varchar(3)), '') +
...
--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 29, 2014 at 4:50 pm

#1709664
RE: Insert triggers updating an audit table

ArtoisBB (4/29/2014)
I don't think I have been very clear.
I have an audit table that I want to use in order to monitor when data was last inserted into certain tables....
--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 29, 2014 at 4:36 pm

#1709660
RE: Anyone Using or Planning to Use Memory-Optimized Tables?

Grant Fritchey (4/29/2014)
The thing is, I think the technology is amazing, but, it's really all about the ability to collect data and feed data out at high speed in an...
--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 29, 2014 at 7:44 am

#1709450

Viewing 15 posts - 23,746 through 23,760 (of 59,102 total)