Jeff Moden

Forum Replies Created

Viewing 15 posts - 26,776 through 26,790 (of 59,099 total)

RE: The Job Posting - Do I really have to be the SQL God?

Steven Willis (5/24/2013)
Chrissy321 (5/24/2013)
I need help in writing a job description for a senior administrative DBA. Can someone suggest an appropriate forum on SSC.com where I can do this?
How about...
--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)

May 27, 2013 at 6:22 pm

#1618836
RE: Help with next date in SQL query

Tyekhan (5/25/2013)
No solution found that works yet, Still need help 🙁
Jeff Moden (5/25/2013)
Dammit. I'm sorry. I lost track of this thread and it took me a while...
--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)

May 25, 2013 at 7:49 pm

#1618558
RE: Help with next date in SQL query

Dammit. I'm sorry. I lost track of this thread and it took me a while to find it again.
Have you found a solution for your problem or do...
--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)

May 25, 2013 at 2:43 pm

#1618550
RE: Timestamps

Just to be clear, it's not so much "points" that people value. It's the reported percentage of correct answers that people value because it's one of those things that...
--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)

May 25, 2013 at 2:40 pm

#1618549
RE: Making data in a column unique (that's not a PK)

RedBirdOBX (5/20/2013)
Thanks but don't have a choice in particular scenario....
As Sean stated, you actually do and it's not just a matter of you doing a CYA. You can take...
--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)

May 25, 2013 at 2:31 pm

#1618547
RE: What to do about a complete lack of jobs?

Dird (5/20/2013)
hisakimatama (3/21/2013)
The contract could lead to full employment, so I'll give everything I've got and see if I can get hired there.
Don't do that; contractors rake it in!...
--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)

May 25, 2013 at 2:16 pm

#1618546
RE: Remove non printable characters

ryan.blosser (5/18/2013)
This is what I have been looking for and forgive me if this is a simple question (I am trying to learn some of these concepts, like in-line table-valued...
--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)

May 25, 2013 at 2:14 pm

#1618545
RE: Count Words in Text Field and/or Column (frequency of use)

Tim Walker. (5/21/2013)
Apologies .. I'm off topic and I know it but I'm also in the UK :hehe:
Jeff Moden (12/6/2011)
And now you understand my affinity for beer popsicles 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)

May 25, 2013 at 1:45 pm

#1618543
RE: REPLACE Multiple Spaces with One

Thomas Abraham (5/22/2013)
Stumbled across this thread with a Google search. (Amazing how all paths lead 'home'.)
The elegance of the solution to this problem in SQL is amazing. Got a warm...
--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)

May 25, 2013 at 1:40 pm

#1618542
RE: Backup large Table

Minnu (5/24/2013)
Hi Team,
I've a table with 75+ columns and 70000 records, i want to have a backup .sql file.
am trying using SSMS > Rt click Database > Tasks > 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)

May 24, 2013 at 4:51 pm

#1618475
RE: How to allocate the Amount to other columns accordingly

I'd define the column in the table as a PERSISTed Computed column to make life easier for everyone and the formula would simply be the addition of the other columns.
As...
--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)

May 24, 2013 at 4:45 pm

#1618473
RE: Calculate average sale value for the result of the sql query

tswapnars 90250 (5/23/2013)
Can anyone please tell me how to calculate the Average Value and select it as a column?
I am trying to add AVG(TotalValue) as AgvSales on the top of...
--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)

May 24, 2013 at 4:35 pm

#1618472
RE: Calculate average sale value for the result of the sql query

Bhaskar.Shetty (5/23/2013)
Any select query with aggerate function requires a GROUP By clause with columns list to be grouped on.
Not quite true. Many of the aggregate functions can be used...
--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)

May 24, 2013 at 4:33 pm

#1618471
RE: For your amusement

lnardozi 61862 (5/21/2013)
Which is to say, what CAN'T you do in an inline tvf if you really really want to?
Effective and high performance running totals in a pre-2012 environment, for...
--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)

May 24, 2013 at 4:16 pm

#1618462
RE: How to make a solution real-time replicate from oracle and mysql to SQL server?

krit (5/23/2013)
Jo Pattyn (5/23/2013)
Have no experience with realtime replication. How realtime is it (ns, ms, minutes...). Is it realtime part oneway (oracle+msql) to ms sql server?
Triggers have a disadvantages
They need...
--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)

May 24, 2013 at 4:05 pm

#1618460

Viewing 15 posts - 26,776 through 26,790 (of 59,099 total)