Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,761 through 20,775 (of 59,072 total)

RE: Space needed for clustered index rebuild

Ken Davis (5/12/2015)
Jeff,
We can assume I will have more space on separate LUNs. FYI a few months ago I estimated the need for 2.5TB of space to keep us...
--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 12, 2015 at 11:08 am

#1797341
RE: Not Only a Meeting of Minds, but of Open Minds.

Just so that no one thinks I'm a Luddite, I absolutely believe in new and better technology. For example, ROW_NUMBER and the other ranking functions are one of 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 12, 2015 at 8:05 am

#1797280
RE: Not Only a Meeting of Minds, but of Open Minds.

Gary Varga (5/12/2015)
Don't worry Jeff. I didn't take it personally. BTW who is this Maj Orrant??? 😛
Heh... he's the voice in my head that I normally talk to so that...
--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 12, 2015 at 7:51 am

#1797273
RE: where is sql server TVF return type stored in system tables

Bill Talada (5/12/2015)
Thanks everyone, the sys.columns does hold the TVF returned columns; not sure how I missed that except I was also working with TVPs at the same time which...
--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 12, 2015 at 7:47 am

#1797270
RE: Can Auditing Fail?

In that case, I recommend major CYA efforts on the part of the DBAs because that's where the blame will end up if audits fail, audit data is missing 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)

May 11, 2015 at 11:02 pm

#1797144
RE: Space needed for clustered index rebuild

Anything on my questions above, Ken? Also, is the extra disk space you talked about going to be a reality? That would sure simplify things and make this...
--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 11, 2015 at 10:22 pm

#1797142
RE: where is sql server TVF return type stored in system tables

Lynn Pettis (5/11/2015)
Jeff Moden (5/11/2015)
Try this, Bill. The sys.parameters thing isn't for the return of TVFs. sys.columns is.
SELECT OBJECT_NAME(object_id),*
FROM sys.columns
WHERE object_id...
--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 11, 2015 at 6:17 pm

#1797139
RE: Not Only a Meeting of Minds, but of Open Minds.

Just to be sure, Gary... that wasn't directed at you personally even though I quoted your post.
It's just that I've seen...
<MAJORRANT>
...people actually take the time to setup 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)

May 11, 2015 at 4:05 pm

#1797125
RE: where is sql server TVF return type stored in system tables

Try this, Bill. The sys.parameters thing isn't for the return of TVFs. sys.columns is.
SELECT OBJECT_NAME(object_id),*
FROM sys.columns
WHERE object_id = OBJECT_ID('nameofyourfunctionhere')
;
--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 11, 2015 at 3:45 pm

#1797124
RE: where is sql server TVF return type stored in system tables

Bill Talada (5/11/2015)
Eirikur Eiriksson (5/11/2015)
Bill Talada (5/11/2015)
Regular functions store the return value as parameter zero in sys.parameters but I can't find the TVF table definition for the following sample function....
--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 11, 2015 at 3:34 pm

#1797121
RE: How to check page splits number?

SQL Guy 1 (5/11/2015)
Thanks again.
Here is the query that I came up with:
select f1.Operation,
f1.AllocUnitName,
...
--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 11, 2015 at 3:31 pm

#1797120
RE: Query

sonu_mhl (5/11/2015)
Hi
I have below data & i want record with value 6 & 2013 should be returned. Both the fields are numeric
U_MonthU_Year
122012
12013
22013
32013
42013
52013
62013
Thanks
Glad you got the help you needed...
--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 11, 2015 at 11:41 am

#1797051
RE: Space needed for clustered index rebuild

Getting back to the subject, can any of the NVARCHAR columns be change to VARCHAR or even INT/BIGINT for things that have numbers in them? It's not a requirement...
--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 11, 2015 at 10:55 am

#1797038
RE: Index on calculated field with UDF?

Alan.B (5/11/2015)
Yes and ~~Yes~~ no. If you post an example of what you are trying to do specifically we can provide a specific example.
If you are talking about doing something...
--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 11, 2015 at 10:51 am

#1797036
RE: Space needed for clustered index rebuild

Ken Davis (5/11/2015)
Thanks again for the advice and thanks Jeff for any time you spend on this.
My next concern with this big DB is the 2TB disk limit. 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)

May 11, 2015 at 10:46 am

#1797032

Viewing 15 posts - 20,761 through 20,775 (of 59,072 total)