Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,791 through 20,805 (of 59,098 total)

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
RE: Space needed for clustered index rebuild

Thanks, Ken. I'll have a deeper look tonight after work.
In the mean time, is it absolutely necessary for all those NVARCHAR columns to be NVARCHAR. Can some 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)

May 11, 2015 at 9:42 am

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

Gary Varga (5/11/2015)
So true. There is an expression saying that for a person with a hammer everything looks like a nail.
Then there's the problem of people searching for the latest...
--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 9:05 am

#1796974
RE: The Service Pack Fiasco

Yep... we did talk about it. My post was mostly for other people that might be going through the same thing but also wanted to give you a post...
--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 8:44 am

#1796968
RE: Space needed for clustered index rebuild

Ken Davis (5/11/2015)
Jeff Moden, to your questions, this is an audit database where rows are written once and never updated. They are queried for research. I have to...
--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 8:39 am

#1796966

Viewing 15 posts - 20,791 through 20,805 (of 59,098 total)