Jeff Moden

Forum Replies Created

Viewing 15 posts - 41,581 through 41,595 (of 59,067 total)

RE: Allowing users to create tables though the front end.

Ruaghain (10/7/2009)
Hi Lutz,
I hear ya, but unfortunately it is a business requirement that we are required to implement (against the better judgement some, and including the points that you mentioned...
--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)

October 7, 2009 at 7:37 pm

#1063201
RE: Ensure Unique Value Across Records

david.c.holley (10/7/2009)
I just answered my own question...
Alter table contactuserids
Add constraint ix_WindowsUserId UNIQUE(WindowsUserID)
Alter table contactuserids
Add constraint ix_ContactId Unique(ContactId)
I just didn't know what the term was.
Keep in mind that UNIQUE constraints will...
--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)

October 7, 2009 at 7:13 pm

#1063191
RE: create procedure

Why not just restore a backup?
--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)

October 7, 2009 at 7:03 pm

#1063189
RE: Dark Forum Skin

Hear here! That would be helpful, indeed! Even a medium gray like the slide bars would help a boat load but I like the idea of a "lights...
--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)

October 7, 2009 at 6:49 pm

#1063183
RE: Help with a Long running stored procedure

Also, you might want to provide that output as an attachment to the post rather than listing it up front. Thanks.
--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)

October 7, 2009 at 6:15 pm

#1063174
RE: Help with a Long running stored procedure

How do things like this go from 1 hour to over 3 hours overnight? Since it's legacy code and I'm not likely to offend you personally, it's what happens...
--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)

October 7, 2009 at 6:13 pm

#1063172
RE: Estimated remaining time for a SPID

To Grant's good point... estimated times for anything with a loop, some forms of recursion, and some functions will be surprising low while the actual time will be surprisingly high....
--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)

October 7, 2009 at 4:37 pm

#1063146
RE: Generic SPROC to write data to text file.

What format shall the text file be in? CSV? TSV? Fixed Length Fields? Space Delimited? True CSV? Text Qualified CSV? Other Delimited? Do...
--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)

October 7, 2009 at 4:28 pm

#1063143
RE: query optimizing

Mike McQueen (10/7/2009)
where ((avg_cost - std_cost)*in_stock >= @A
or (avg_cost - std_cost)*in_stock <= -1* @A)
will cause a scan every time, as well as the computation.
I don't know that much...
--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)

October 7, 2009 at 4:20 pm

#1063139
RE: STEPPING THROUGH A ROW AT A TIME

ian.dunlop-843887 (10/7/2009)
HI, Thanks again for above- works a treat - last bit honest
I finally need to create a column for each period into the existing or new table...
--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)

October 7, 2009 at 4:10 pm

#1063136
RE: not null column is taking empty data

It's easier than that. To reject things that are either blank or null in VARCHAR columns, you simply need to check for anything greater than a blank...
WHERE somecolumn >...
--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)

October 7, 2009 at 3:59 pm

#1063133
RE: Opportunities are less for SQL DBAs.?

Any kind of job is scarce right now. If you log onto "Michigan Works" and take a look, there are more than 1.2 million resumes available for a bit...
--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)

October 7, 2009 at 3:50 pm

#1063128
RE: .fmt and Bulk Insert importing Bad Data

dzirkelb (10/7/2009)
I am importing a .fmt for a bulk insert, but, it is causing the data to be incorrect. here is the .fmt file:
8.0
12
1SQLCHAR0255"\t"1Allied ""
2 SQLCHAR 0 255 "\t"...
--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)

October 7, 2009 at 3:44 pm

#1063125
RE: Are the posted questions getting worse?

Roy Ernest (10/7/2009)
The recoil usually is pretty strong and your 12 yr old can handle that. And still hit a clay pigeon.
10 year old, 12 guage gun.
--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)

October 7, 2009 at 3:36 pm

#1063119
RE: SQL & the JOIN Operator

Andy DBA (10/7/2009)
SuperDBA-207096 (10/7/2009)
Wagner,
You might want to mention in the:
"Excluding the Intersection of the Sets" section this is similar to
select... where not in (select... from table2) but it performs...
--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)

October 7, 2009 at 3:08 pm

#1063104

Viewing 15 posts - 41,581 through 41,595 (of 59,067 total)