Jeff Moden

Forum Replies Created

Viewing 15 posts - 36,346 through 36,360 (of 59,099 total)

RE: Are the posted questions getting worse?

Paul White NZ (9/21/2010)
Gianluca Sartori (9/21/2010)
I agree that some of the new features have been implemented poorly, but I really would like to see those window functions in the next...
--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)

October 19, 2010 at 4:27 pm

#1239408
RE: Are the posted questions getting worse?

Gianluca Sartori (9/21/2010)
Paul White NZ (9/20/2010)
Steve Jones - Editor (9/20/2010)
BTW, I got an appeal from Itzik that Window functions might not make SQL 11 and he's appealing people to upvote...
--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)

October 19, 2010 at 4:25 pm

#1239407
RE: How to return last 10 rows of a table?

mm.sailaja (10/18/2010)
Hi guys!!
I know that a table is an unordered. Order by clause gives us the result in a sorted manner. I don't want the result in a sorted order....
--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)

October 18, 2010 at 5:48 am

#1238340
RE: Convert Date (dd-MM-YYYY) to (dd/MM/YYYY)

gunapriyan (10/17/2010)
Dear Sir,
Thanks for your reply.
Actually I am developing a software with the help of VB 6.0 and SQL Server 2005.
In Date Part, Initially i have put DateTime Picker...
--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)

October 18, 2010 at 5:43 am

#1238338
RE: Date Gap Problem

Paul White NZ (10/18/2010)
The original question doesn't give expected output or the number of rows to be processed, so this is a valid alternative:
SELECT *
FROM #membership...
--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)

October 18, 2010 at 5:10 am

#1238322
RE: Date Gap Problem

Dave Ballantyne (10/18/2010)
I would be interested in comparative performance over a larger dataset. 😉
No problem. Here's some test data...
--===== Expand the test data using "lasagne" copies of the original...
--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)

October 18, 2010 at 5:06 am

#1238319
RE: UDF Vs Subquery performance

SQL* (10/17/2010)
How to make use of UDF or subquery?
Which is better one with performance considerations?
thanks
"It Depends". You have to test each way based on the situation you're trying...
--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)

October 17, 2010 at 11:07 pm

#1238227
RE: Convert Date (dd-MM-YYYY) to (dd/MM/YYYY)

My recommendation is to lookup the word REPLACE in Books Online. It'll show you how to easily do such a thing. I'd show you the actual code but...
--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)

October 17, 2010 at 11:02 pm

#1238226
RE: Are There That Many GUIDs?

Although having two systems come up with the same GUID is a bit like having two comets appear in the same mile across 14 quadrillion Milky Way galaxies, it can...
--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)

October 17, 2010 at 10:57 pm

#1238224
RE: Are There That Many GUIDs?

Eric Russell 13013 (10/12/2010)
As for global uniqueness, I don't see why the column combination (center_id + cashregister_id + transaction_date) or database id + transaction identity id would not be as...
--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)

October 17, 2010 at 10:51 pm

#1238222
RE: Are There That Many GUIDs?

Grant Fritchey (10/12/2010)
They should be used where appropriate...
I apologize for puting you on the spot but what do you consider an appropriate use for them is especially since even MS...
--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)

October 17, 2010 at 10:49 pm

#1238221
RE: When Times are Tough, Do You Rise to the Occasion?

The answer is the same answer as to anything else... "It Depends".
--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)

October 17, 2010 at 10:44 pm

#1238219
RE: How to make tempdb use > 1 datafile

Ah... sorry... didn't see the age of the thread or the recent jump in. Still, what I wrote is true. 😀
--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)

October 17, 2010 at 10:37 pm

#1238218
RE: How to make tempdb use > 1 datafile

JC-3113 (6/29/2009)
Hi Jerry
I am looking at your code for tempdb files
I am new to sqlserver 2005
Not up to speed on TEMPDB files yet
i understand the creation of the multiple tempdb#.mdf...
--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)

October 17, 2010 at 10:35 pm

#1238217
RE: How to return last 10 rows of a table?

CELKO (10/17/2010)
Please any book on RDBMS. Tables have no order. Your question makes no sense.
Read Codd's Information Principle, so you will see what a stupid question this is. An...
--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)

October 17, 2010 at 10:32 pm

#1238215

Viewing 15 posts - 36,346 through 36,360 (of 59,099 total)