Jeff Moden

Forum Replies Created

Viewing 15 posts - 24,706 through 24,720 (of 59,099 total)

RE: Check if Windows User is an SQL Admin

My feeling is that if an application has any more than (at the most) read/write privs, then the application is incorrectly written. The application should be calling on prived...
--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 20, 2014 at 4:18 pm

#1681696
RE: How to calculate CPU usage per transaction?

ananda.murugesan (1/20/2014)
Hi,
As below script output SQL Statement grouped by their cumulative CPU resource consumption. How can calculate CPU usage time per query?
SELECT TOP 5 query_stats.query_hash AS "Query Hash",
...
--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 20, 2014 at 4:14 pm

#1681695
RE: Which is the faster ?

devu (1/20/2014)
Hi all,
I want to know which is the faster group of select statement or stored procedure with same select statements ?
Thanks.
My question would be, why don't you just try...
--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 20, 2014 at 4:10 pm

#1681694
RE: get sum multiplied values from function

I found the post I was talking about. http://www.sqlservercentral.com/Forums/Topic1532465-391-1.aspx#bm1532469
@shanmuga Raj,
Did you even look at the solution I posted? It provides the exact answer you wanted. And stop double...
--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 20, 2014 at 4:01 pm

#1681693
RE: get sum multiplied values from function

Damn! I swear that I just answered this particular problem with code that could be used in an iTVF. I wonder if I forgot to hit "Post Reply"...
--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 20, 2014 at 3:57 pm

#1681692
RE: I am unable to connect the SQL instances without giving port number.

rajeshjaiswalraj (1/20/2014)
I got the result ..... i started the browser it started connecting..:laugh:
Some would say that's a bad thing. Hackers use the presence of Browser to more easily find...
--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 20, 2014 at 3:51 pm

#1681690
RE: Last 3 months data

trickg1 (1/20/2014)
You'd want to use getdate() to find the current day and date and use that in a formula with dateadd.
Welcome aboard. Do you have any code to support...
--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 20, 2014 at 3:00 pm

#1681681
RE: How to Post Performance Problems

T.Ashish (10/20/2013)
Seems like a deprecated feature !!![/quote]
Heh... seriously? You're perpetuating SPAM by quoting 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)

January 20, 2014 at 2:56 pm

#1681680
RE: How can I run the same package, at the same time with different configs

Phillip.Putzback (1/20/2014)
...since some of the procedures I was given take so long to complete
Actually, from what I saw of the process path in your SSIS graphics and unless they're playing...
--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 20, 2014 at 2:42 pm

#1681677
RE: Insert or update

Poor ol' lonely DELETE. No one ever asks questions about that. :laugh:
--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 19, 2014 at 5:21 pm

#1681419
RE: What do you use to find out what's slowing down your instance right now

Shifting gears...
If I'm on a server that I'm not allowed out {sic} sp_whoisactive on ...
I'd be fighting that tooth, nail, and pork chop. You're the DBA... why aren't you...
--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 19, 2014 at 5:13 pm

#1681418
RE: WITH OPTION RECOMPILE faster query?

Raul Undreiner (1/17/2014)
We have run into this scenario. We have a query that refers to a table with some 250K rows with 10+ joins to other tables. Indexes have been...
--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 19, 2014 at 5:03 pm

#1681417
RE: Migration of SSIS from SQL 2005 to SQL 2012

I know it doesn't help with this migration but, right after you get it done, I'd strongly recommend that you insist on source control for anything and everything that's on...
--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 19, 2014 at 4:51 pm

#1681415
RE: function to get the city details of the parent

Thank you very much for the readily consumable test data. It does make things much more clear and easier to concentrate on code instead of building test data.
Your requested...
--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 19, 2014 at 3:04 pm

#1681408
RE: SQL single column rows into multiple columns

Johnny D (1/19/2014)
Hi Jeff,
After studying your code and doing a little reading I have full understanding of your code. It's an approach i may not have applied off the top...
--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 19, 2014 at 2:36 pm

#1681407

Viewing 15 posts - 24,706 through 24,720 (of 59,099 total)