Jeff Moden

Forum Replies Created

Viewing 15 posts - 32,446 through 32,460 (of 59,099 total)

RE: Are the posted questions getting worse?

Sean Lange (9/26/2011)
/soapbox on
Boy I must be on of the few conservatives on here...the amazon article was thought provoking but I find the author's stance does not align with my...
--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)

September 26, 2011 at 6:47 pm

#1386890
RE: Select Records Issue

engrshafiq4 (9/26/2011)
Actually i am working under project manager...i do what he wants....
That's what I thought.
Just so you know, TOP in code has no sort-order implications without a "correct" 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)

September 26, 2011 at 6:34 am

#1386426
RE: Select Records Issue

Thanks... I get and got that. What I'm curious about is why you don't care with 3 companies paid and why you don't care which companies didn't. You'd...
--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)

September 26, 2011 at 6:20 am

#1386412
RE: Scalar Function returns only one char

meelan (9/25/2011)
Lowell
Thank you for the reply. I will check on this matter deeply as I have seen the same issue in few SPs earlier
Jeff Moden:
I thought a UDF will improve...
--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)

September 26, 2011 at 5:35 am

#1386391
RE: Select Records Issue

engrshafiq4 (9/25/2011)
After alot of googling i found solution like this
SELECT top 100 ID, COMPANY,
...
--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)

September 26, 2011 at 5:02 am

#1386364
RE: SQL 2008 - T-SQL query assistance

Speaking of that... Drammy, are you all set or is there something else you'd like to know on this topic?
--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)

September 26, 2011 at 4:55 am

#1386360
RE: UPDATE without listing all columns?

Heh... yeah... "Dat's da ticket". 😀
--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)

September 26, 2011 at 4:44 am

#1386357
RE: using sp_send_dbmail

I hate giving users any privs. We've got it pretty much locked down at work so that users have no privs other than PUBLIC and "execute". All of...
--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)

September 25, 2011 at 9:53 pm

#1386272
RE: Try catch in a transaction block or transaction in try catch block???

BWAA-HAAA!!!! I found the ultimate solution to error handling years ago... don't write code that can make any mistakes. :-):-D:-P;-)
--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)

September 25, 2011 at 9:47 pm

#1386270
RE: pass table name as a parameter in stored procedure

Seggerman-675349 (4/17/2008)
I am not sure of the feasibility of this but I would recommend writing your program to use a synonym for the table name - then use dynamic sql...
--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)

September 25, 2011 at 9:39 pm

#1386269
RE: Database Diagram printing problems

It's certainly not a fix but there IS a work around...
The "problem" is that the printed version treats all 6 pages as if it were a "single page" and tries...
--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)

September 25, 2011 at 8:21 pm

#1386266
RE: SQLServer becoming unresponsive

Shelley Allen (9/23/2011)
Twice a day, SQLSERVER becomes unresponsive and I will have to stop TCP, SQLSERVER, and SQLSERVER Agent, then restart to connect to my sqlserver.
OS=2008 R2 Server SP1
SQL=2008 Enterprise...
--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)

September 25, 2011 at 8:09 pm

#1386265
RE: Needed help to convert column as row values

veenavidyakaran (9/25/2011)
It's a businees requirement.
Nah... not what we meant. What's the reason behind the business requirement? Is this going into a spreadsheet, another program that requires the format,...
--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)

September 25, 2011 at 8:00 pm

#1386264
RE: cant find indexes when doing a remote query?/

You can't necessarily believe the cost basis of the things in the Execution Plan, anyway. The "cost" is one of those things known to lie especially if any "Hidden...
--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)

September 25, 2011 at 7:38 pm

#1386262
RE: Select Records Issue

engrshafiq4 (9/25/2011)
hi,
i have multiple records having FLAG field on the basis of which i will decide that this is paid or not....i want to show top 3 paid records only...
--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)

September 25, 2011 at 7:27 pm

#1386261

Viewing 15 posts - 32,446 through 32,460 (of 59,099 total)