Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,751 through 21,765 (of 59,098 total)

RE: Multiple Join Query for a PowerPivot Table

What do you get for the following query?
SELECT *
FROM v_dim_wotask_ES
WHERE v_dim_wotask_ES.budget_analyst_text = N'ES-EPM-Peurrung, Pam'
--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)

January 23, 2015 at 1:44 pm

#1772822
RE: ABS value

sharonsql2013 (1/23/2015)
I am passing a -ve value as a paremeter to show data for past 30/60/90 days.
The issue is I want the header to show as
= "Data 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)

January 23, 2015 at 1:40 pm

#1772821
RE: DAte Function

Ed Wagner (1/23/2015)
Sean Lange (1/23/2015)
Ed Wagner (1/23/2015)
Sean Lange (1/23/2015)
Ed Wagner (1/23/2015)
sharonsql2013 (1/23/2015)
I have a column in the table with datatype DATE
Gives data in the format
YYYY_MM_DD
How can I go back to...
--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)

January 23, 2015 at 1:38 pm

#1772820
RE: DAte Function

sharonsql2013 (1/23/2015)
I have a column in the table with datatype DATE
Gives data in the format
YYYY_MM_DD
How can I go back to past 12 months in my where clause
So , Select *...
--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)

January 23, 2015 at 1:36 pm

#1772818
RE: What are First Steps for a dba in new Office?

Grant Fritchey (1/23/2015)
sm_iransoftware (1/23/2015)
No :blush:
I think I should Know more about these tools and performance Basics.
Thank you
If you really want to get into all that, I'd suggest picking up 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)

January 23, 2015 at 12:40 pm

#1772802
RE: Just an idea ...

Gazareth (1/23/2015)
Yeah, I'd be using sys.objects etc for that, or the INFORMATION_SCHEMA views.
Could be nice to have sorting/filtering on the Object Explorer though.
For quickly finding objects, there already 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)

January 23, 2015 at 12:37 pm

#1772801
RE: Which is Quicker ? - updating 90 million records

Luis Cazares (1/23/2015)
I'll say that this would be slower because you're still using a single transaction and you're using several queries. This is a guess and I might be wrong.
I...
--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)

January 23, 2015 at 11:14 am

#1772765
RE: Just an idea ...

Ah. Understood. In that case, I just use sp_help 'schemaname.tablename' and then search the results.
--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)

January 23, 2015 at 9:18 am

#1772702
RE: Removing Duplicates

Shankar Walvekar (1/23/2015)
http://deleteduplicaterecords.blogspot.in/
You get all answers here
Why? Sioban's article has all the answers along with reasons 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)

January 23, 2015 at 9:12 am

#1772698
RE: Audit strategy on a separate database.

Understood but, done properly, audit tables are never a performance problem nor a maintenance problem. Putting the audit tables on a separate server brings all sorts of problems to...
--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)

January 23, 2015 at 9:05 am

#1772696
RE: What is the best practice about maintain and using Big Log Database

Can you post the CREATE TABLE code for the largest table (the "clicks" table, apparently) along with any indexes and constraints, please?
--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)

January 23, 2015 at 8:00 am

#1772646
RE: How to repeat the same row combination?

srinivas.akyana (1/23/2015)
Hello ChrisM@Work,
Since I wanted to repeat the original combination 4 times prior for MonthIDs of 307 & 309, I would need to first start with latest month which 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)

January 23, 2015 at 7:54 am

#1772642
RE: How to calcualte date Difference In Months?

kiran.rajenimbalkar (1/23/2015)
Thanks All for your help it worked for me 🙂
I'm thinking that since you're doing aggregations, the DURATION in months is important to someone and just using DATEDIFF 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)

January 23, 2015 at 7:50 am

#1772638
RE: Comparability mode

There are always some issues with upgrades. May or may not affect your 3rd party stuff but it sounds like you have a good plan.
I'd do it on 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)

January 23, 2015 at 7:37 am

#1772625
RE: I am probably just missing it, but ...

Tobar (1/23/2015)
Thanks. My eyes just finally rested upon it a couple of seconds before I saw your post. Unfortunately, what I am really looking for is the messages I have...
--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)

January 23, 2015 at 7:32 am

#1772618

Viewing 15 posts - 21,751 through 21,765 (of 59,098 total)