Jeff Moden

Forum Replies Created

Viewing 15 posts - 26,116 through 26,130 (of 59,102 total)

RE: query

shirish_padekar (8/24/2013)
Thanks, it worked! I am not sure about query performance, will check with actual database or may be will try other alternative as per your suggestion.
Thanks for the feedback....
--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)

August 24, 2013 at 5:43 pm

#1644690
RE: Slow performance on a very small SP that updates a very small table

One other thing that will help a bit. There's no need for the explicit transaction in the SP_GetNextValue sproc. It's just a waste of clock cycles because 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)

August 24, 2013 at 5:17 pm

#1644689
RE: using Sqlpsx functions on a production sql box

Where are you trying to "save off the SQL Error logs" to? A table or a file?
--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)

August 24, 2013 at 5:03 pm

#1644687
RE: Capacity Planning

In that case, my answer would be to examine a similar system and make a determination from that. That is, of course, if that similar system has some form...
--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)

August 24, 2013 at 4:49 pm

#1644685
RE: backing up msdb after changes

PearlJammer1 (8/22/2013)
I have found some of my databases that have high vlf counts.
It looks like the ones that had the high count have had either small increment growth settings or...
--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)

August 24, 2013 at 4:28 pm

#1644682
RE: Cool Projects

CGSJohnson (8/23/2013)
Is the dearth of responses an indication that we are all just working on mundane projects?! Or is it too early?!
Nope... I can't speak for others but it's...
--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)

August 24, 2013 at 4:20 pm

#1644679
RE: Cool Projects

I actually can't talk about some of the projects that I've worked on recently or am working on because of NDAs and personal ethics concerning perceived company secrets whether 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)

August 24, 2013 at 4:08 pm

#1644676
RE: query

Shifting gears a bit, no matter which way you solve this problem, the server and the I/O system are going to suffer quite a bit. Even the "pipe" 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)

August 24, 2013 at 2:50 pm

#1644670
RE: query

Both tables are going to be scanned at least once. I haven't tried it for efficiency but I thought I'd let some of the inbuilt tools in SQL Server...
--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)

August 24, 2013 at 2:35 pm

#1644669
RE: Capacity Planning

Hold the phone... you have a [font="Arial Black"]1TB[/font] database for a [font="Arial Black"]NEW [/font]application?
--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)

August 24, 2013 at 1:45 pm

#1644666
RE: Logic to break period of time by month

To summarize a CROSS APPLY, it's a correlated subquery much like you might find in a subquery within a SELECT list except that it's capable of returning more than one...
--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)

August 24, 2013 at 1:42 pm

#1644665
RE: Performance difference between using a transaction and not using a transaction

Someone could explain this better than I but, at a 100,000ft view, when you put all of these queries in a single transaction, the data isn't actually written as 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)

August 24, 2013 at 1:36 pm

#1644664
RE: How to put $ symbol in the query or result set

Smash125 (8/24/2013)
i have this query
SELECT ContactID,
AVG(TotalDue) AS [Avergare Total Due]
FROM Sales.SalesOrderHeader
GROUP BY ContactID
ORDER BY 1 ASC
what i want to i want prefix dollar symbol in the [Avergare...
--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)

August 24, 2013 at 1:26 pm

#1644663
RE: Slow performance on a very small SP that updates a very small table

Open the Explorer window in SSMS by pressing the {f8} key. Then right click on the server/instance and select "Properties". In the properties window, select "Connection" and see...
--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)

August 24, 2013 at 1:03 pm

#1644662
RE: Hierarchies on Steroids #1: Convert an Adjacency List to Nested Sets

L' Eomot Inversé (8/24/2013)
Hi Jeff, great article.
I have one quibble: terminology; even an old relic like me knows that "best bower" and "small bower" have been superseded by "starboard bower"...
--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)

August 24, 2013 at 12:00 pm

#1644659

Viewing 15 posts - 26,116 through 26,130 (of 59,102 total)