Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,721 through 21,735 (of 59,072 total)

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

sm_iransoftware (1/23/2015)
No :blush:
I think I should Know more about these tools and performance Basics.
Thank you
Take a look at my previous post. It talks about a simple built-in tool 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 3:45 pm

#1772849
RE: ABS value

sharonsql2013 (1/23/2015)
Well the Error was #Error.
Yowch. Not fun. I hate such "informative" error messages.
I'm sure there's an SSRS-language function to do the same thing but the multiplication will...
--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 3:41 pm

#1772848
RE: Logiacl Sql server SSIS question

stevenb 63624 (1/23/2015)
sqlmaverick (1/23/2015)
Hi, please help me to get below logic in Derived transformation, SSIS.
Logic:ensure the Docket number is 5 digits and populate with leading zeros if not.
I have 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 2:00 pm

#1772829
RE: Where can I find the definistion of this table value function

MMartin1 (1/23/2015)
EXEC SP_HELPTEXT 'schema.viewName';
This formats the output across multiple lines rather than just one. I find it way handier when copying long definitions to the SSMS window.
Unless you're in 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)

January 23, 2015 at 1:51 pm

#1772825
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

Viewing 15 posts - 21,721 through 21,735 (of 59,072 total)