Jeff Moden

Forum Replies Created

Viewing 15 posts - 50,206 through 50,220 (of 59,091 total)

RE: How to write Insert Trigger

Any chance of changing the design to something a bit more normal instead of storing seconds for hours, minutes, and seconds?
Also, what have you tried? Generally speaking, you should...
--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)

June 1, 2008 at 8:23 pm

#822757
RE: How do you keep up your technical skill if your company does not have the latest technology?

Spend %50-60 USD on SQL Server 2005 Developers edition... install it on your home PC. Start answering/verifying questions on this forum... you'll stay current.
But it does takes some...
--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)

June 1, 2008 at 5:08 pm

#822745
RE: Using dynamically created Column names in a query?

Um... is [DC-Base] the changing part number you're referring to? And, if so, what is the datatype of that column?
--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)

June 1, 2008 at 4:56 pm

#822743
RE: Tuning advice sought

Ronnie.Doggart (6/1/2008)
Hi
When you say I/O output problem do you mean network bandwidth ?
Ronnie
Yep... that and recompiles... because of the 1=1 trick to make it easier to form a WHERE clause,...
--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)

June 1, 2008 at 10:26 am

#822724
RE: Don't know the answer, can't form the question...and, besides, I'm a chicken (wearing a hat)

Which sites did you try that you were disappointed with?
--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)

May 31, 2008 at 4:33 pm

#822685
RE: Index on a Temp table conundrum

Just because a proc may run more than once concurrently, I try to never name constraints on temp tables.
--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)

May 31, 2008 at 4:17 pm

#822684
RE: The Hazards of IT

David.Poole (5/31/2008)
Before I die I am going to do that ride.
Or, maybe in the process 😀
--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)

May 31, 2008 at 4:09 pm

#822683
RE: Passing Parameters as (almost) 1, 2, and 3 Dimensional Arrays

Thanks for the links and info, Tom... I'll take a look.
--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)

May 31, 2008 at 4:06 pm

#822682
RE: Naming Convention

You certainly don't need any prefixes to make them run. So far as not being able to tell what the views are used for, that's thanks to the lack...
--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)

May 31, 2008 at 10:36 am

#822647
RE: TempDB size

Ok... I'm just going to go ahead and guess you meant "shrinking" TempDB... 😉
Yes... you may shrink the "files" associated with TempDB as you would any other database. It...
--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)

May 31, 2008 at 10:28 am

#822646
RE: Is it possible to disable the IDENTITY constraint?

Yes... here's the syntax from Books Online (comes free with SQL Server)...
SET IDENTITY_INSERT [ database. [ owner. ] ] { table } { ON | OFF }
... but, generally, there's...
--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)

May 31, 2008 at 10:18 am

#822645
RE: display data columnwise in table

adshisode85 (5/30/2008)
I have only column in my table and i want to display values in table columnwise. like this
1 6
2 7
3 ...
--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)

May 31, 2008 at 10:09 am

#822643
RE: Passing Parameters as (almost) 1, 2, and 3 Dimensional Arrays

Howdy folks,
Someone who wishes to remain anonymous, send me an email asking the following questions related to this article. I've not worked with SQL Server 2008 (shoot, I'm just...
--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)

May 30, 2008 at 10:43 pm

#822623
RE: Cannot insert the value NULL

I don't believe anything is missing... just alter the column like I did... don't mess with the constraint or the default.
--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)

May 30, 2008 at 9:28 pm

#822619
RE: TempDB size

karthikeyan (5/30/2008)
Also , i have some questions on TempDB.
1) what is the best size of TempDB ? The answer may be 'it depends',But if anybody added some valid points then...
--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)

May 30, 2008 at 7:45 pm

#822610

Viewing 15 posts - 50,206 through 50,220 (of 59,091 total)