Jeff Moden

Forum Replies Created

Viewing 15 posts - 19,156 through 19,170 (of 59,072 total)

RE: Unable to print the charindex of a special character of its 4th occurrence.

SQL-DBA-01 (11/17/2015)
Hello,
I am unable to get the 3rd and 4th occurrence of the "_" using charindex. Can anyone please suggest?
Can bring 1st and 2nd occurence position.
example string:
AB_CD_EF_GH_IJ
SELECT CHARINDEX('_', name) a_First_occurence,
CHARINDEX('_',...
--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)

November 17, 2015 at 12:20 pm

#1840466
RE: upload and store TIF (Image) files into a SQL Server Database

After some recent experiences, I have to strongly agree with what Donald wrote above.
I have a phone system where the original programmers stored the recorded calls (similar to storing...
--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)

November 17, 2015 at 8:28 am

#1840362
RE: Referencing function from another database in CREATE TABLE stmt

SoHelpMeCodd (11/17/2015)
It may be worthwhile to think about a disaster scenario: If the utilities database goes offline, how many databases will be impacted?
Eggsactly (pun intended inferring "all eggs in one...
--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)

November 17, 2015 at 8:10 am

#1840345
RE: Are the posted questions getting worse?

WayneS (11/17/2015)
Ed Wagner (11/16/2015)
WayneS (11/16/2015)
Lynn Pettis (11/13/2015)
(think government contracted software development).
My scary story when working with the gov't.
Software contract awarded, specified that all data access has to go through stored...
--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)

November 17, 2015 at 7:54 am

#1840337
RE: Are the posted questions getting worse?

jasona.work (11/17/2015)
I love it when I'm poking through topics that sound interesting, and come across something I've not done / seen before. Which then leads me down a rabbit...
--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)

November 17, 2015 at 7:51 am

#1840335
RE: making t-sql 2012 execute faster

Any feedback, Wendy?
--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)

November 16, 2015 at 8:42 pm

#1840194
RE: Good Basic T-SQL Exercises

hoseam (11/13/2015)
Hi
I want to return two character from a column. But now the column itself returns 0 -9, then double digits. before I concatenated "0", then the problem I had...
--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)

November 16, 2015 at 7:40 pm

#1840193
RE: Good Basic T-SQL Exercises

Steve Jones - SSC Editor (11/12/2015)
I'm looking for a number of problems that I can ask people to solve in T-SQL to try and drive some learning. I'm wondering what...
--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)

November 16, 2015 at 7:36 pm

#1840192
RE: Data Sprawl

I think it only appropriate that "data sprawl" accompany the "Tower of Babel" that a lot of people end up using.
We had a similar problem way back in 1996 were...
--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)

November 16, 2015 at 7:15 pm

#1840190
RE: Query Performance Problem

Jeff Moden (11/13/2015)
lraju10 (11/13/2015)
Problem : currently working on purchase sproc where it is taking 2 sec for the Purchase transaction to complete, i identified the problem statement, where i generate...
--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)

November 16, 2015 at 3:30 pm

#1840172
RE: Help with query that group consecutive records based on a field value

laorozco1 (11/16/2015)
Thanks a lot, it works
Since you're the one that will need to explain it and support it, do you know how and why it works?
--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)

November 16, 2015 at 9:33 am

#1840009
RE: 150 GB Backup (compressed) taking over 1 day

jbrandenburg (11/16/2015)
We have 75 databases being backed up using simple recovery model on a nightly basis. We have no custom applications, but we have the following 3rd party apps...
--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)

November 16, 2015 at 9:32 am

#1840008
RE: How to do a Pivot

Sean Lange (11/16/2015)
Jeff Moden (11/13/2015)
Sean Lange (11/13/2015)
Ed Wagner (11/13/2015)
Sean Lange (11/13/2015)
Instead of a PIVOT I would recommend using a crosstab. The syntax is far less obtuse to me and it...
--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)

November 16, 2015 at 9:24 am

#1840005
RE: Referencing function from another database in CREATE TABLE stmt

chuck.forbes (11/16/2015)
Registered server trick?
Yes. You register the servers in SSMS into a common group and then run the promotion script against the group. All of the underlying servers...
--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)

November 16, 2015 at 8:54 am

#1839989
RE: Are the posted questions getting worse?

GilaMonster (11/14/2015)
I am getting seriously tired of the lack of thought and understanding evidenced by recent questions from certain individuals. Is a little bit of independent work and research really...
--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)

November 14, 2015 at 4:02 pm

#1839833

Viewing 15 posts - 19,156 through 19,170 (of 59,072 total)