Jeff Moden

Forum Replies Created

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

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
RE: Which tables required to make payroll in this case

The title of this post is different but it's a duplicate post. No replies here, please. Please see the other post already in progress at the following URL.
http://www.sqlservercentral.com/Forums/Topic1565517-373-1.aspx
--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 28, 2014 at 2:53 pm

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

Michael Valentine Jones (4/28/2014)
I was just wondering if this feature will be used in the real world.
Not being able to have identity columns and foreign key constraints looks like 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)

April 28, 2014 at 2:50 pm

#1709277
RE: Insert triggers updating an audit table

Actually, since this is for INSERTs, consider putting a default on the Last_Updated column along with a NOT NULL constraint and you won't even need a trigger.
--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 28, 2014 at 8:44 am

#1709196

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