Jeff Moden

Forum Replies Created

Viewing 15 posts - 35,911 through 35,925 (of 59,099 total)

RE: Database Standards Parsing

MysteryJimbo (11/26/2010)
Apex have a tool called SQL Enforce which you can completely customise using a .net language.
I've used it in the past but couldnt get the backing of the development...
--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)

November 26, 2010 at 8:27 am

#1255829
RE: Copying data from multiple related tables

Flodpanter (11/26/2010)
This Insert will create 100 new records all with unique identity values in the table dbo.table_referencing_project. Now I have to copy all data that references the dbo.table_referencing_project table. These...
--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)

November 26, 2010 at 8:18 am

#1255828
RE: Copying data from multiple related tables

WO (11/26/2010)
Jeff, Thank you for correcting me, while posting my reply I suddenly remembered having this problem with identity values a while back so I thought it be worth mentioning....
--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)

November 26, 2010 at 8:14 am

#1255826
RE: Alternative To Cursors?

patelmohamad (11/26/2010)
HI,
Avoid Cursor , Using While loop
No insult intended but that's just not good advice. A good FAST FORWARD, READ ONLY, STATIC cursor is nothing more than a Temp...
--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)

November 26, 2010 at 8:10 am

#1255825
RE: Do You Talk Salary in the Interview?

simonk1971 (11/26/2010)
Who would even go to interview without having an idea of the salary range available anyway?
Just about anyone who's been out of work for a while. Also and...
--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)

November 26, 2010 at 8:02 am

#1255822
RE: Database Standards Parsing

Joe Fuller (11/25/2010)
Good Idea.
Besides those Jeff has mentioned>
What do you look for?
Table names (and most other SQL objects. that don't use only the 2 part naming convention. The 2...
--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)

November 25, 2010 at 10:13 pm

#1255696
RE: Do You Talk Salary in the Interview?

I agree... I usually don't even entertain the idea of an interview unless I already know the salary range. I don't want to waste their time or my time.
There...
--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)

November 25, 2010 at 9:36 pm

#1255695
RE: Are the posted questions getting worse?

LutzM (11/25/2010)
Jeff Moden (11/24/2010)
It's a little out of character for me but I know you'll recognize the rhetoric. I just couldn't resist... it was too perfect. Enjoy... 😛
http://www.sqlservercentral.com/Forums/Topic1025567-392-1.aspx#bm1026289
I...
--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)

November 25, 2010 at 9:33 pm

#1255694
RE: vbscript query

Lowell (11/25/2010)
is that characters 10 thru 20 of the whole file, or 10 thru 20 for each row/line in the file? so if the file has 120 lines, you need...
--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)

November 25, 2010 at 9:16 pm

#1255692
RE: Data Types

Nakul Vachhrajani (11/25/2010)
da.drew (11/25/2010)
Hi thanks for your reply, that all makes good sense. What would you suggest for Dates, I read on a website that SQL Server has:
datetime -...
--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)

November 25, 2010 at 9:12 pm

#1255691
RE: Data Types

Brigadur (11/25/2010)
Hi,
My recommendations:
Postcode
If you always have same length then use char(<length>). If it can have different lengths like international postcodes, safest is nvarchar(<length>).
Telephone Number, Mobile Number
These can indeed be...
--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)

November 25, 2010 at 9:09 pm

#1255690
RE: Pass Parameter technique

dtopicdragovic (11/25/2010)
Thanks for all your input.
I will post back once I decide the way I will do it.
That would be a really cool thing to do because a lot 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)

November 25, 2010 at 9:02 pm

#1255689
RE: smallint instead of decimal

marcinSkorupka (11/25/2010)
First of all thank you for your opinions
At the moment we are using sql server 2005.
I know that in sql server 2005 SP2 there is data compression for decimal/numeric...
--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)

November 25, 2010 at 8:59 pm

#1255688
RE: smallint instead of decimal

marcinSkorupka (11/25/2010)
http://technet.microsoft.com/en-us/library/cc917696.aspx
point 6 - vardecimal
Marcin
Ummm... IIRC correctly, vardecimal was deprecated almost as fast as it was born.
--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)

November 25, 2010 at 8:58 pm

#1255687
RE: smallint instead of decimal

Michael Valentine Jones (11/24/2010)
99.99999% of the time, that is going to be a very bad idea.
Just store the data is a datatype that most closely fits the real type 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)

November 25, 2010 at 8:56 pm

#1255686

Viewing 15 posts - 35,911 through 35,925 (of 59,099 total)