Jeff Moden

Forum Replies Created

Viewing 15 posts - 50,221 through 50,235 (of 59,099 total)

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
RE: SELECT * INTO temp table

Matt Miller (5/30/2008)
bcronce (5/30/2008)
when you do a (select * into #table), doesn't it lock the tempdb the entire time of the select staments because the tempdb is locked during the...
--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:12 pm

#822608
RE: Cannot insert the value NULL

Look at the code, guys... column was previously defined as NOT NULL.
Dunno if it'll work because no one provided the code for the rest of the table, 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)

May 30, 2008 at 6:46 pm

#822607
RE: tuning a stored procedure

I'd say to never look at the percentage of batch in the execution plan... it lies... a lot...
--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 6:32 pm

#822606
RE: Tuning advice sought

First, I think I'd use UNION ALL... considering the source tables, there's probably not much chance of duplication, anyway.
The other thing is that the CPU time is not varying all...
--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 6:29 pm

#822605
RE: Composite Key Question

Tomm,
Your code won't work on SQL Server 2000 (this forum is a 2k forum)... keyword PERSISTED does not exist and the calculated column is considered "non-deterministic" in 2k so the...
--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 6:02 pm

#822602
RE: The Hazards of IT

Heh... regular doses of a good Scotch and soda fixed mine... 😛
--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 5:27 pm

#822599
RE: Is a Temporary Table Really Necessary?

jmapledoram (5/30/2008)
But correct me if I'm wrong, doesn't a Table Variable get stored in ram rather than the tempdb? You will want to consult your DBA before writting a lot...
--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 5:17 pm

#822596

Viewing 15 posts - 50,221 through 50,235 (of 59,099 total)