Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,806 through 20,820 (of 59,098 total)

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

GilaMonster (5/10/2015)
Jeff Moden (5/10/2015)
The only recommendation for space savings is to DISABLE NCIs prior to a rebuild.
Which itself is wrong, because ALTER INDEX .. REBUILD on the clustered index...
--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 2:28 pm

#1796855
RE: Space needed for clustered index rebuild

P.S.
Just to be sure, I did a deep dive double-check in Books Online and, as logical as it might seem, I can't find where it even implies that WITH DROP...
--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 1:55 pm

#1796851
RE: Space needed for clustered index rebuild

Eirikur Eiriksson (5/10/2015)
Ken Davis (5/9/2015)
I have a large table in a large database. The DB = 1.2TB and the big table is 70% of the DB or 840GB. ...
--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 1:17 pm

#1796849
RE: Space needed for clustered index rebuild

Ken Davis (5/9/2015)
I have a large table in a large database. The DB = 1.2TB and the big table is 70% of the DB or 840GB. I 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 10:04 am

#1796844

Viewing 15 posts - 20,806 through 20,820 (of 59,098 total)