Jeff Moden

Forum Replies Created

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

RE: Consider yourself a SQL Server Guru? - Solve this!

a1011 (4/29/2010)
I have a unique situation and I am having trouble writing a query to deal with it. This is what I have:
RowIDDatecreated Event
112010-04-01 06:16:16.6230
212010-04-01 12:25:18.9400
312010-04-01 20:03:07.1101
412010-04-01 20:40:27.2170
522010-04-01 09:48:42.4500
622010-04-01 09:51:24.8900
722010-04-01...
--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 29, 2010 at 3:21 pm

#1160073
RE: How to swap rows to columns

To learn how to do this in the future, please see the following article...
http://www.sqlservercentral.com/articles/Crosstab/65048/
--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 28, 2010 at 8:42 am

#1158995
RE: APPLY vs. Correlated Scalar Subquery in SELECT clause

I'd say "It Depends". In theory, they should have about the same execution plan. In reality, you need to turn on SQL Profiler and check out things like...
--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 28, 2010 at 8:39 am

#1158991
RE: Are the posted questions getting worse?

Steve Jones - Editor (4/26/2010)
On plagiarism, my alma mater has some free software:http://digg.com/u1UU6a. I could host something using this if someone wants to help code.
Sorry Steve... I'm missing it... "help...
--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:42 am

#1158331
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

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