Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,741 through 37,755 (of 59,098 total)

RE: Are the posted questions getting worse?

Jack Corbett (7/11/2010)
Jeff Moden (7/9/2010)
Ah.... just found another email from Elena... the Tally Table session in "Approved" and the Hierarchy session has been labeled as an "Alternate" in case someone...
--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)

July 12, 2010 at 1:55 am

#1191340
RE: "Real" copy of Codd's 12 (13) Rules for RDBMS

Jim McLeod (7/12/2010)
I asked a friend, who is a CS Ph.D student, if he could dig it up. Unfortunately, no luck. His reply:
It's referenced in the ACM digital library:
http://portal.acm.org/citation.cfm?id=655234
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)

July 12, 2010 at 1:27 am

#1191337
RE: "Real" copy of Codd's 12 (13) Rules for RDBMS

David Portas (7/12/2010)
It is included in the disc version of the ACM SIGMOD anthology, although I don't think the text is available online.
http://dblp.uni-trier.de/db/conf/icde/Codd86.html
That's the rebublished version of the Computerworld article.
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)

July 12, 2010 at 1:25 am

#1191336
RE: The Utilty

Absolutely wonderful editorial, Steve. Unfortunately, I've found that many IT shops ARE exactly the same as some water and electric companies... you can't actually get to anything with 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)

July 11, 2010 at 11:35 pm

#1191313
RE: Assigning some week numbers

lmu92 (7/11/2010)
Ok, here's the code including test data setup.
Please note that there a few people around (including myself, usually) who expect sample data in a ready to use format (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)

July 11, 2010 at 11:24 pm

#1191312
RE: Assigning some week numbers

m.dunster (7/11/2010)
Hi,
I've managed to successfully adapt this to solve my problem. Now I'll have to spend some time trying to understand exactly what is happening.
Point noted about the data provision.
Many...
--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)

July 11, 2010 at 11:23 pm

#1191310
RE: create a function

rvasanth (7/10/2010)
You have to use cursor
Use the sysobjects table to get the list of table.
Then loop through one by one and check for the condition you want
Anyone can say such...
--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)

July 11, 2010 at 3:19 pm

#1191271
RE: return calculated null as 0

lmu92 (7/11/2010)
A few more things to notice:
I'm not sure how the functions to_char and to_date are written, but I guess both can be replaced by the built-in function CONVERT(). 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)

July 11, 2010 at 3:16 pm

#1191270
RE: Today as a Serial Date

lmu92 (9/6/2009)
Would the following give the expected result?
SELECT DATEDIFF(dd,0,GETDATE())
However, it's interesting that EXCEL returns 40062 for today (2009-09-06), but SQL Server returns 40060...
The "0" date for for the default date...
--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)

July 11, 2010 at 3:07 pm

#1191269
RE: Assigning some week numbers

m.dunster (7/11/2010)
Hi,
I've managed to successfully adapt this to solve my problem. Now I'll have to spend some time trying to understand exactly what is happening.
Point noted about the data provision.
Many...
--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)

July 11, 2010 at 2:58 pm

#1191268
RE: HI SQL DBA'S

I agree with Lutz. The subject is much to large to put into a simple post. The only way for you to become wise and expert on 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)

July 11, 2010 at 2:54 pm

#1191267
RE: Performance on Views that span databases on multiple servers

SQL Marathoner (7/11/2010)
You can try indexed view, which may solve the performance issue.
Ummm... Good idea but probably won't work here. See the following URL and look for "View...
--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)

July 11, 2010 at 2:51 pm

#1191266
RE: Performance on Views that span databases on multiple servers

Eric Anderson (7/9/2010)
We have many databases at our company. There are two in particular both of which are on two different virtual servers but both virtual servers are on 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)

July 11, 2010 at 2:37 pm

#1191263
RE: Are the posted questions getting worse?

Wow... Someone please tell me how this person got the job.
http://www.sqlservercentral.com/Forums/Topic950419-145-1.aspx
This is one of the reasons I'm so adamant about not posting answers to interview and homework questions. Saying...
--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)

July 11, 2010 at 2:33 pm

#1191262
RE: Are the posted questions getting worse?

Grant Fritchey (7/11/2010)
Jeff Moden (7/9/2010)
Interesting... PASS accepted my abstract on the Tally Table session. I'm actually a bit surprised at that. I had also submitted an abstract...
--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)

July 11, 2010 at 2:26 pm

#1191261

Viewing 15 posts - 37,741 through 37,755 (of 59,098 total)