Jeff Moden

Forum Replies Created

Viewing 15 posts - 16,501 through 16,515 (of 59,067 total)

RE: Shrinking the Log file...best practices?

jasona.work (10/26/2016)
First, shrinking the logs will fragment indexes, so you'll need to plan for some index operations afterwards.
Careful, now. Shrinking the logs has no effect on fragmentation of indexes....
--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)

October 26, 2016 at 6:59 am

#1908867
RE: 8 Ways to Export SQL Results To a Text File

Excellent article! Really enjoyed it. Thanks for taking the time to write that bad boy.
My only gripe would be this...
From the article:
Use it when you have millions 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)

October 26, 2016 at 12:21 am

#1908814
RE: sql backup

Brandie Tarvin (10/25/2016)
EdVassie (10/25/2016)
One thing I did not see explicitly mentioned is the number of backup files.
I don't know if this is true of all dedup technology, but the stuff...
--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)

October 26, 2016 at 12:02 am

#1908809
RE: sql backup

EdVassie (10/25/2016)
One thing I did not see explicitly mentioned is the number of backup files. This can also reduce run time because SQL Server backs up a portion of 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)

October 26, 2016 at 12:01 am

#1908807
RE: Delete massive records and still can't shrink db

Houston, the OP has left the building! 😀
--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)

October 25, 2016 at 11:54 pm

#1908806
RE: Big data: transfer x-number of rows per batch?

Phil Parkin (10/25/2016)
wtren (10/25/2016)
You should use bcp
Please justify this comment.
Although it was a bit short, it's not a bad idea. I've done similar before. Instead of messing around...
--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)

October 25, 2016 at 11:51 pm

#1908805
RE: Clownpocalypse and DR

Eric M Russell (10/25/2016)
Marcia J (10/25/2016)
I remember in the late 80's saying that the 2-digit year would be a problem and getting the message from other programmers, "So what? ...
--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)

October 25, 2016 at 11:45 pm

#1908804
RE: Clownpocalypse and DR

Gary Varga (10/25/2016)
Geoff.Sturdy (10/25/2016)
Gary - the two digit year was born out if the need to conserve memory in early systems - back in the late 70s /early 80s...
--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)

October 25, 2016 at 11:41 pm

#1908803
RE: database features

sqlserverDBA2016 (10/25/2016)
in general , do most of dbas always install ssas and ssis and ssrs when installing sql server 2014
I can't speak for others but I install everything, no...
--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)

October 25, 2016 at 11:29 pm

#1908802
RE: function to clean a phonenumber

ninamahezi (10/25/2016)
thanks,
I have never writen sql function. So I do not know what is.
What we want to do is make an update on the phonenumber taking into account all these...
--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)

October 25, 2016 at 11:15 pm

#1908801
RE: RabbitMQ via SQL Server

TryingToLearn (10/25/2016)
i need to create a queue via a trigger(i'm assuming) that will be consumed by a service/event bus in RabbitMQ. Would MSMQ be the proper way to proceed?
We already...
--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)

October 25, 2016 at 11:14 pm

#1908800
RE: function to clean a phonenumber

Luis Cazares (10/25/2016)
ninamahezi (10/25/2016)
Hello,
I want a sql function that will allow to make one update but with several replace on the same column.
For exemple
Replace the space by vacuum('')
...
--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)

October 25, 2016 at 11:10 pm

#1908797
RE: Splitting Text Field into individual Columns

Maybe if you're trying to do all this to a table, the cCA method might improve performance a bit because you can then take advantage of the starting position parameter...
--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)

October 25, 2016 at 10:41 pm

#1908796
RE: Splitting Text Field into individual Columns

pietlinden (10/25/2016)
Jeff,
My first thought was to be lazy and use DelimitedSplit8K but that would turn each occurrence into a separate record, right?
Yes. You'd have to do a CROSS TAB...
--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)

October 25, 2016 at 10:03 pm

#1908795
RE: Windows Function

It's by design and definition. Referring to the note at the following URL...
[font="Arial Black"]OVER Clause (Transact-SQL)[/font]
NOTE:
If ORDER BY is not specified entire partition is used for a window frame....
--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)

October 25, 2016 at 9:43 pm

#1908794

Viewing 15 posts - 16,501 through 16,515 (of 59,067 total)