Jeff Moden

Forum Replies Created

Viewing 15 posts - 19,621 through 19,635 (of 59,098 total)

RE: "send me some of your code"

pietlinden (9/10/2015)
John,
It's a recruiter, which makes me wonder, because the number of recruiters in this town that understand and can evaluate the "goodness" of T-SQL code is less than 5....
--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)

September 10, 2015 at 10:36 am

#1825747
RE: Query is taking very long to execute

akash_singh (9/10/2015)
i am using group by to get distinct data.
That would also be a part of the problem. It would seem that you might have an accidental many-to-many join 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)

September 10, 2015 at 9:01 am

#1825705
RE: Query is taking very long to execute

Grant is spot on. Column names encapsulated in formulas and OR in the WHERE clause is likely the larger problem.
A part of the problem may be due to the...
--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)

September 10, 2015 at 8:58 am

#1825703
RE: Query is taking very long to execute

Please post your new code that uses the DelimitedSplit8K function and attach the actual execution plan, as Gail asked.
--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)

September 10, 2015 at 8:24 am

#1825687
RE: Big Data Problems

I think the biggest problem that people have with the analysis of any size data is that they have some preconceived notion of what they want to see rather than...
--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)

September 10, 2015 at 8:17 am

#1825682
RE: Cross Apply with parameterized function

jghali (9/9/2015)
anything else I should look at?
Yes... despite your misgivings, you can't fix a car that you can't touch never mind see. Ask for a copy of the actual...
--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)

September 10, 2015 at 7:57 am

#1825670
RE: "send me some of your code"

pietlinden (9/9/2015)
Just wondering what other people think about questions like:
"Can you send me samples of your code?"
Without a job description (even a title would suffice!), I'm not sure what they're...
--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)

September 10, 2015 at 7:49 am

#1825665
RE: Creating 15000 partitions

What's up? Did you quit or did you get the answer that you think you want from somewhere 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)

September 9, 2015 at 11:14 pm

#1825584
RE: Need help with Retrieving Data

Sweetbee870 (9/9/2015)
Okay this is what I'm running:
Select FirstName, LastName, Title
from Employees
See attached the Results. I need know how to only retrieve records for "Sales Representatives"
Hope this is...
--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)

September 9, 2015 at 11:08 pm

#1825583
RE: Introduction

Welcome.
--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)

September 9, 2015 at 11:05 pm

#1825582
RE: Delete large number of records

ScottPletcher (9/9/2015)
Jeff Moden (9/9/2015)
It looks like someone may have followed the old idea of adding one index to each column that could ever be used in a WHERE clause 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)

September 9, 2015 at 5:31 pm

#1825570
RE: matainence jobs are failing

Thanks for the feedback... I hate problems like that because you never know when they'll occur again.
--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)

September 9, 2015 at 5:05 pm

#1825565
RE: JSON

Manic Star (9/9/2015)
JSON is evil incarnate. XML's bastard sibling at best.
😀
I LOVE IT! A kindred spirit!!!! 🙂
--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)

September 9, 2015 at 5:04 pm

#1825564
RE: Delete large number of records

I have to agree with Scott on this one. This table is actually fairly small and, because of the monthly rolloff, isn't going to get much bigger quickly. ...
--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)

September 9, 2015 at 5:00 pm

#1825563
RE: Trigger fire on each inserted row to insert same record into remote Table

It's a REALLY bad idea to make INSERTs dependent on the availability of a remote server. Your trigger should write to a "local" table and you should have 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)

September 9, 2015 at 3:48 pm

#1825557

Viewing 15 posts - 19,621 through 19,635 (of 59,098 total)