Jeff Moden

Forum Replies Created

Viewing 15 posts - 34,441 through 34,455 (of 59,099 total)

RE: Greetings from a new (future) SQL DBA.

SQLDCH (3/29/2011)
Welcome!
I learned a ton from this site regarding writing SQL:
http://www.w3schools.com/sql/default.asp
Make sure to bookmark Books Online (http://msdn.microsoft.com/en-us/library/ms130214.aspx).
And yes, as already been stated, get an instance up and running,...
--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)

March 29, 2011 at 3:40 pm

#1305178
RE: Greetings from a new (future) SQL DBA.

steven.hulse (3/29/2011)
...and move off Oracle.
You had me right there. 😀
If you can afford it, get on Amazon.com (or any of another dozen places) and buy a copy of "SQL Server...
--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)

March 29, 2011 at 3:36 pm

#1305175
RE: NEW SEQUENCE NUMBER DAILY?

Fal (3/28/2011)
Jeff Moden (3/28/2011)
As a side bar, though, I wouldn't allow this type of sequencing into any of my DBs even if it was a requirement by the business unit....
--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)

March 29, 2011 at 6:16 am

#1304797
RE: Are the posted questions getting worse?

bitbucket-25253 (3/28/2011)
Would some one here help this OP (and when following the link also note Jeff Moden's request for some one to help the OP)
http://www.sqlservercentral.com/Forums/Topic1085256-9-1.aspx#bm1085260
Thanks, Ron. I didn't think...
--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)

March 29, 2011 at 6:07 am

#1304790
RE: Are the posted questions getting worse?

ALZDBA (3/29/2011)
bitbucket-25253 (3/28/2011)
Would some one here help this OP (and when following the link also note Jeff Moden's request for some one to help the OP)
http://www.sqlservercentral.com/Forums/Topic1085256-9-1.aspx#bm1085260
Took a shot. 😉
Thanks, Johan......
--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)

March 29, 2011 at 6:06 am

#1304789
RE: Are the posted questions getting worse?

Kiara (3/29/2011)
ALZDBA (3/29/2011)
bitbucket-25253 (3/28/2011)
Would some one here help this OP (and when following the link also note Jeff Moden's request for some one to help the OP)
http://www.sqlservercentral.com/Forums/Topic1085256-9-1.aspx#bm1085260
Took a shot. 😉
Is...
--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)

March 29, 2011 at 6:05 am

#1304787
RE: Updating Records Based on Select Results

Hey folks...
NetGuyKB did a pretty good job of posting table and data creation scripts. The only thing he forgot was that we don't have either the DB name or...
--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)

March 28, 2011 at 7:59 pm

#1304649
RE: Updating Records Based on Select Results

bitbucket-25253 (3/28/2011)
Thanks for the table definitions and sample data. However:
1. You posted your question to a SQL Server 2000 forum and the insert into statements such as
INSERT...
--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)

March 28, 2011 at 7:52 pm

#1304648
RE: Select query taking time

LutzM (3/28/2011)
Did you try the good old Divide'n'Conquer approach?
[font="Arial Black"]+1[/font] 🙂
--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)

March 28, 2011 at 7:34 pm

#1304645
RE: Loading data from .csv with blank cells

What does the actual file look like for those 5 rows you gave an example 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)

March 28, 2011 at 7:31 pm

#1304643
RE: help with xp_cmdshell 'XCOPY....' command

A different country heard from... With the proper proxy in place, I embrace xp_CmdShell. 😉
--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)

March 28, 2011 at 7:29 pm

#1304642
RE: Changing Text in Multiple Stored Procedures From a Stored Procedure

@bdavey,
Although I don't necessarily agree with the methods you used, I have to agree with what has already been said... this is the general direction DBA's should think in when...
--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)

March 28, 2011 at 6:21 pm

#1304635
RE: Changing Text in Multiple Stored Procedures From a Stored Procedure

deroby (3/28/2011)
I sincerely think changing a cursor into a WHILE loop to be a bad idea. The while-loop approach (sometimes called 'a poor man's cursor') hardly ever brings benefits 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)

March 28, 2011 at 6:02 pm

#1304632
RE: Quality Over Timing

krowley (3/9/2011)
Jeff Moden (3/9/2011)
Mark W Johnson (3/9/2011)
krowley (3/9/2011)
When you don't know if a feature will really meet the needs of your users because they don't really know what they want...
--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)

March 28, 2011 at 5:12 pm

#1304623
RE: temp table vs. table variable

Sergiy,
If you're still out there somewhere, thanks again for the wonderful pearl you gave me years ago... it's saved my hiney more than once...
[font="Arial Black"]"A Developer must not guess... 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)

March 28, 2011 at 4:58 pm

#1304620

Viewing 15 posts - 34,441 through 34,455 (of 59,099 total)