Jeff Moden

Forum Replies Created

Viewing 15 posts - 18,901 through 18,915 (of 59,098 total)

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
RE: Why is trivial plan creating statistics

MadAdmin (12/21/2015)
Jeff Moden (12/20/2015)
If you think you have problems with statistics, imagine code that automatically generates statistics for every bloody table column in every bloody database and then regenerates them...
--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:04 am

#1847136
RE: Simultaneously transaction Update on different Database

To be honest, I use a combination of triggers and staging tables with a job to move the data from the staging tables to their targets in a sort 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)

December 21, 2015 at 7:56 am

#1847132
RE: Are We Engineers?

roger.plowman (12/21/2015)
Good, fast, and cheap, pick any two...
Always include "Good". Fast and cheap usually follow auto-magically.
--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:43 am

#1847127
RE: How to dynamically create 12 rows per customer in a SQL Table

ciskypete (12/21/2015)
Jeff Moden (12/18/2015)
ciskypete (12/18/2015)
Thanks for the reply Jeff! Would you possibly be able to explain this concept a little deeper? (as in, how I would go about setting 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)

December 21, 2015 at 7:37 am

#1847124

Viewing 15 posts - 18,901 through 18,915 (of 59,098 total)