Jeff Moden

Forum Replies Created

Viewing 15 posts - 27,376 through 27,390 (of 59,101 total)

RE: UDF Help

TheSQLGuru (2/28/2013)
I would honestly expect (but not certain here) that a scalar UDF that just puts it's output into a variable would be more efficient than iTVF that returns 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)

March 1, 2013 at 12:16 am

#1592263
RE: does index also change the output?

Actually, the change of an index CAN very much change the result especially where UPDATEs are concerned.
--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)

March 1, 2013 at 12:07 am

#1592262
RE: Why SQL Server?

Heh... my goodness. Why would anyone consider being "stuck" in SQL Server being "stuck"? I actually gave up the front-end world (11 years ago) to work almost exclusively...
--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)

March 1, 2013 at 12:04 am

#1592260
RE: Low Performance - High CPU Problem and others...

SpringTownDBA (2/27/2013)
Jeff Moden (2/27/2013)
SQL Pizza (2/27/2013)
Got a lot of SOS_SCHEDULER_YIELDS-waits and a very high signal time. Could it also be possible, that we just need more CPUs?
As Gail has already...
--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)

February 28, 2013 at 11:55 pm

#1592258
RE: 15 Quick Short Interview Questions Useful When Hiring SQL Developers

I think the most important part of the article has been overlooked by those rightfully aghast at yet another seemingly “interview question” article. Here’s the quote. The emphasis...
--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)

February 28, 2013 at 10:50 pm

#1592245
RE: How to concatenate group of rows

And now we know why I asked. 🙂 There's always more behind these types of requests. Thanks you very much for taking the time to post the business...
--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)

February 28, 2013 at 9:18 am

#1592029
RE: Remove Leading Zero(s) only if needed

mickyT (2/27/2013)
Why? Please don't say "for performance reasons" until you've actually tested it. I tested all of the solutions offered so far and there's virtually no difference. ...
--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)

February 27, 2013 at 11:10 pm

#1591876
RE: Which one is best certification

"It Depends". What is your passion?
--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)

February 27, 2013 at 11:08 pm

#1591874
RE: effective way to break a string into rows basing on lenght of string

knakka 14475 (2/27/2013)
I have no clue how this works.. :blink:
Pls could u break it down as to how can i use it
The article at the following link explains how 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)

February 27, 2013 at 10:23 pm

#1591863
RE: how to ignore null columns

josetur12 (2/27/2013)
I need to get the last value regardless of the actual date.
I tried both solutions and both work.
Thank you.
You might also want to consider changing the structure of 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)

February 27, 2013 at 10:19 pm

#1591862
RE: SET ROWCOUNT

daglugub 60457 (2/27/2013)
thanks, that worked. I dismissed trying that because I want more than zero rows. I need to stop listening to my gut instincts, when it comes...
--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)

February 27, 2013 at 10:13 pm

#1591861
RE: Is my Create Index Online finished?

Jon.Morisi (2/27/2013)
If I create an INDEX like the following
CREATE NONCLUSTERED INDEX [IX_table_col1_col2] ON [dbo].
(
[col1] ASC,
[col2] ASC
)
WITH (SORT_IN_TEMPDB...
--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)

February 27, 2013 at 10:06 pm

#1591859
RE: Does the adrenaline rush ever subside when rebooting a DB server.

CapnHector (2/27/2013)
I work in a small shop as the accidental DBA and for the first time rebooted our production DB server after applying CU 9 to fix some issues we...
--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)

February 27, 2013 at 10:04 pm

#1591858
RE: Getting minimum of top n rows without using subquery

winmansoft (2/27/2013)
You mean "select min([date]) from entries WHERE [date] BETWEEN '01-Jan-2012' and '20-Jan-2013'"? But we want to select minimum from to 100 rows
Then add the TOP and the ORDER BY...
--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)

February 27, 2013 at 9:58 pm

#1591857
RE: How to concatenate group of rows

RZ52 (2/27/2013)
Hi,
I have a data structure as followed : [Name], [Task] and the data is :
John, task1
John, task2
Joe, task1
Joe, task3
Joe, task4
Jane, task1
Jane, task4
..........
I wonder how to use the 'SELECT' 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)

February 27, 2013 at 9:54 pm

#1591855

Viewing 15 posts - 27,376 through 27,390 (of 59,101 total)