Jeff Moden

Forum Replies Created

Viewing 15 posts - 38,716 through 38,730 (of 59,098 total)

RE: How To Get Last Inserted Record Value In SQL Server

David Portas (4/27/2010)
TheSQLGuru (4/27/2010)
Tables are UNORDERED sets of data unless they have a CLUSTERED INDEX on them.
Tables are unordered sets even if they do have a clustered index. A clustered...
--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)

April 27, 2010 at 9:30 am

#1158321
RE: Which query method is best to use and when?

TheSQLGuru (4/27/2010)
Jeff, didn't they completely remove support for "SELECT 1 FROM E01 a, E01 b" in SQL 2008 or 2008R2? I thought that non-ANSI stuff was going away. ...
--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)

April 27, 2010 at 9:27 am

#1158319
RE: Passing a Table to A Stored Procedure

jose-276033 (4/27/2010)
Thanks for your explanations. I think I may use a piece of code rather than a stored procedure to do such a thing as I would more adequate 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)

April 27, 2010 at 6:59 am

#1158180
RE: Which query method is best to use and when?

aaa-322853 (4/27/2010)
I think I get it. Some people will use a loop and iterate through each number ending up with 8,000 result sets.
If you use a tally table you 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)

April 27, 2010 at 6:44 am

#1158165
RE: Which query method is best to use and when?

aaa-322853 (4/26/2010)
No, I've dumped that idea after our discussion. My approach is more to give them the pros and cons of each method allowing them to make informed decisions. If...
--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)

April 26, 2010 at 3:51 pm

#1157915
RE: transaction log full

striker-baba (4/23/2010)
My Sr.dba says we can truncate the log no backup is required.
.
.
.
what do you suggest.?
I'd suggest that you stop trying to do a DBA's job. Seriously... the DBA...
--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)

April 26, 2010 at 2:04 pm

#1157864
RE: Which query method is best to use and when?

aaa-322853 (4/26/2010)
Thanks for this Jeff, I am enjoying this interesting discussion.
Ah... no. CTE's are absolutely wonderful for building "top down", highly readable, highly effective code. I just wouldn't build 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)

April 26, 2010 at 1:51 pm

#1157852
RE: Substring Function in Where Clause

eseosaoregie (4/26/2010)
Hi Jeff,
Managed to run the amendments this afternoon and found considerable improvement in performance. Whole thing loaded in just under 2min 30sec. Network traffic is high during that period...
--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)

April 26, 2010 at 12:28 pm

#1157794
RE: Help with Function to convert row_number to alpha character

Paul Morris-1011726 (4/26/2010)
I am attempting to convert the row number to an alpha character:
EX 1 = A, 2 = B,...27 = AA, 28= BB,... 53 = AAA, 54 = BBB,...
--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)

April 26, 2010 at 11:49 am

#1157771
RE: Optimising Server-Side Paging - Part I

Another stunning example of how an article should be written as well as how to back up all claims with code. Very well done, Paul.
--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)

April 26, 2010 at 11:44 am

#1157769
RE: Group with Rollups??

You bet. 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)

April 26, 2010 at 10:57 am

#1157742
RE: Which query method is best to use and when?

aaa-322853 (4/26/2010)
Ok great. I thought that might promote some discussion!
So lets start with Table Variables. Basicially never use these, regardless of the row size or application (unless it's a UDF)....
--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)

April 26, 2010 at 10:43 am

#1157735
RE: Which query method is best to use and when?

Holy moly... Guess I needed to read the entire graphic and the underlying text, huh?
Again, IMHO, using Global Temporary Tables is a form of "Death by SQL" because if two...
--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)

April 26, 2010 at 7:18 am

#1157592
RE: Which query method is best to use and when?

Gahh.... I'd also recommend that if you need to reference data more than once from a subquery that you NOT use CTE's... Like Views, if you reference a CTE more...
--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)

April 26, 2010 at 7:14 am

#1157586
RE: Which query method is best to use and when?

It's simply not a given that Table Variables are faster than Temp Tables and Table Variables are a whole lot more difficult to troubleshoot because their content don't persist even...
--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)

April 26, 2010 at 7:11 am

#1157583

Viewing 15 posts - 38,716 through 38,730 (of 59,098 total)