Jeff Moden

Forum Replies Created

Viewing 15 posts - 18,871 through 18,885 (of 59,072 total)

RE: How to reduce Huge Log File size

WhiteLotus (12/21/2015)
I haven't changed the autogrow option yet , it is still in 10% growth position.
I am thinking to change it to 512 MB . What do you think ?...
--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)

December 21, 2015 at 8:11 pm

#1847323
RE: DBA Tasks - To automate or use my own eyes

Oh, and getting back to the title question of this post of "DBA Tasks - To automate or use my own eyes", the only correct answer is both. Automation...
--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)

December 21, 2015 at 8:03 pm

#1847322
RE: Using SELECT as 'IN' predicate condition for PIVOT

matt.warren 33350 (12/21/2015)
Hello Luis,
I can't thank you enough for all your help.
I ran into some errors with the code you helped me with, but having seen your advice, it makes...
--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)

December 21, 2015 at 7:47 pm

#1847320
RE: Another Recursive Hierarchy bit of help needed...

Jason A. Long (12/21/2015)
Jeff will no doubt follow up with something super cool...
Not so much as the hierarchical query goes. You pretty much topped that off quite nicely....
--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)

December 21, 2015 at 7:21 pm

#1847316
RE: How to reduce Huge Log File size

ScottPletcher (12/21/2015)
Yeah, everybody always "warns" about that, but who on earth would want to apply a 299GB log anyway??
Obviously and especially in this case, it wouldn't. The log file...
--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)

December 21, 2015 at 6:52 pm

#1847315
RE: Check given number

John Hanrahan (12/21/2015)
The front end can only do so much to stop bad user action. We have some items which allow decimal places and some that don't. Our...
--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)

December 21, 2015 at 4:36 pm

#1847307
RE: DBA Tasks - To automate or use my own eyes

There are three things that I absolute don't believe in automating... a cocktail before and a cigarette after. 😀
--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)

December 21, 2015 at 4:33 pm

#1847304
RE: How to reduce Huge Log File size

And if you do cycle through the SIMPLE Recovery Model, don't forget to at least do a DIF backup after you return to FULL recovery to restart the log chain.
Also...
--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)

December 21, 2015 at 4:31 pm

#1847303
RE: Query performance

T2512 (12/21/2015)
That's what i always thought, from a users perspective speed is the only factor.
During an interview I was asked apart from reducing speed, what else does a developer...
--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)

December 21, 2015 at 10:47 am

#1847213
RE: How to reduce Huge Log File size

Eric M Russell (12/21/2015)
Is the transaction log competing for space with the data files or another database? Perhaps there is no need to actually shrink the log, just let 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)

December 21, 2015 at 9:47 am

#1847199
RE: Another Recursive Hierarchy bit of help needed...

simon_s (12/21/2015)
Thanks Jeff for the handy hint on the sort of data required and how to post it .. heres a very small subset of data, one chain with 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)

December 21, 2015 at 9:40 am

#1847198
RE: Load date time field to date field

only4mithunc (12/21/2015)
Hi All,
I have a flat file source with a field of type date time ( it has got the data in Year-Month-Day-Hour-Minute-Second-Millisecond format )
In the destination table I have...
--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)

December 21, 2015 at 9:20 am

#1847183
RE: Query performance

T2512 (12/21/2015)
Hello
I am relatively new to SQL Server. I had a view that was taking about 10 min to run, i was able to reduce the time to 3 seconds...
--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)

December 21, 2015 at 9:14 am

#1847179
RE: Outer Joins

patricklambin (12/20/2015)
I may go wrong , but I don't think that there is an available support from Microsoft for 2008 .For SQL Server 2008 R2 , I think that 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)

December 21, 2015 at 8:29 am

#1847148
RE: How to reduce Huge Log File size

WhiteLotus (12/20/2015)
Yayy you are right !
Now I get 99% free space . Thanks so much !!
Now you need to shrink it. It's going to take a long time and...
--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)

December 21, 2015 at 8:26 am

#1847145

Viewing 15 posts - 18,871 through 18,885 (of 59,072 total)