Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,776 through 20,790 (of 59,072 total)

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
RE: Query

sonu_mhl (5/11/2015)
Hi
I have 3 fields month,year,status. Status will have value 0 or 1
Thanks
You have to understand that we don't know anything even about the simple data you posted....
--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:05 am

#1796961
RE: The Service Pack Fiasco

Ed Wagner (5/11/2015)
While I think that SQL Server is an awesome product, the problems with the service packs are a joke. Microsoft releasing a new major version every two...
--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 7:55 am

#1796959
RE: You know you're having a slow day when...

Heh... I obviously suffer from the same problem/joy. 🙂
--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 7:02 am

#1796947
RE: Can Auditing Fail?

Gary Varga (5/11/2015)
Jeff Moden (5/10/2015)
I think a lot of people get "auditing" mixed up with "logging". In the former, it must not fail because there are legal reasons for...
--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:52 am

#1796944
RE: You know you're having a slow day when...

Gosh... I strongly second what Brandie said. Ending the article with your epiphany that the journey outshined the destination and why make a wonderful addition to the collection 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 6:42 am

#1796940
RE: The Service Pack Fiasco

Gary Varga (5/11/2015)
Of course, any customer may choose to not apply SPs but the consequences are on them.
Heh... yeah... their stuff will continue to work properly. 😀
MS has to 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)

May 11, 2015 at 6:34 am

#1796936
RE: Space needed for clustered index rebuild

Alright, Ken,
Now that we're done with our diversion, back to you problem. Please see my first post on this thread and answer some of those questions so that we...
--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:30 am

#1796934
RE: Linked Server performance post-migration

Thanks for taking the time to post that. That's going to help me a lot in a couple of days. Really appreciate 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 11, 2015 at 6:25 am

#1796933
RE: Stored Procedure -Question-

Hmmmm.... I recognize those tables. I would strongly recommend NEVER deleting from those tables because 1) you could orphan a whole lot of information that many applications rely on...
--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 10, 2015 at 4:13 pm

#1796862
RE: Space needed for clustered index rebuild

GilaMonster (5/10/2015)
Cool, I thought it always rebuilt the NCs in a drop_existing on the cluster. Glad there's some extra common sense in there.
That said, I'm not sure why one would...
--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 10, 2015 at 3:35 pm

#1796861
RE: Can Auditing Fail?

I think a lot of people get "auditing" mixed up with "logging". In the former, it must not fail because there are legal reasons for it. In 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 10, 2015 at 3:06 pm

#1796860

Viewing 15 posts - 20,776 through 20,790 (of 59,072 total)