Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,316 through 15,330 (of 59,063 total)

RE: Indexes getting fragmented Fast

I've found that fragmentation has nothing to do with deadlocks. Neither does the optimizer even consider fragmentation when determining what the execution plan should look like.
More likely, it's...
--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)

March 25, 2017 at 8:14 pm

#1934960
RE: Is full backup enough

Shifting gears a bit, you've basically posted the same question different ways for the same problem 3 times now. Here are the other two.
https://www.sqlservercentral.com/Forums/1866664/Tlog-backups-indicate-no-data-change
https://www.sqlservercentral.com/Forums/1865369/Migrating-Databases-from-old-version-to-new-version-in-shortest-time
--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)

March 25, 2017 at 7:55 pm

#1934959
RE: The Mysterious Case of the Missing Default Value

@raul,
Didn't see this article when it was first published. Job well done! Thanks for taking the time to write it up!
--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)

March 25, 2017 at 7:44 pm

#1934958
RE: The Mysterious Case of the Missing Default Value

djrubin - Friday, March 24, 2017 10:11 AM
Good stuff but why not go old school and just add a one-to-one table that...
--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)

March 25, 2017 at 7:43 pm

#1934957
RE: A little help with a simple CASE statement

I also recommend that you stop using quoted identifiers for aliases and that you make the resulting datatype for the THEN and ELSE be the same so that you don't...
--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)

March 25, 2017 at 7:06 pm

#1934956
RE: [Generic] Person ETL

I don't have any links to anything specific but I can tell you a bit from personal experience. I don't know what format your external sources are in but every...
--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)

March 25, 2017 at 6:56 pm

#1934955
RE: Tlog backups - indicate no data change

To repeat what I said on your near duplicate post on this topic...
My recommendation stands as it did on the other thread.
1. I assume you're...
--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)

March 25, 2017 at 6:34 pm

#1934953
RE: Is full backup enough

My recommendation stands as it did on the other thread.
1. I assume you're doing normal full backups at the very least. If they're not being done daily, that's...
--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)

March 25, 2017 at 6:26 pm

#1934952
RE: Are the posted questions getting worse?

Heh... "DevOps Specialist". IMHO, that should be the poster-child word example for "oxymoron". 😉
--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)

March 25, 2017 at 4:04 pm

#1934947
RE: Continuous Delivery and the Development DBA

Nothing to do with the article... I'm just really happy that I don't work for a company with 15 development teams and 100+ developers. 😉
--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)

March 24, 2017 at 4:46 pm

#1934911
RE: Tlog backups - indicate no data change

sqlguy80 - Friday, March 24, 2017 12:38 PM
Hi,
For the db backup restore project moving ~ 1200 dbs ( some vldbs 500 GB...
--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)

March 24, 2017 at 4:32 pm

#1934910
RE: Update SQL with excel files?

stino - Friday, March 24, 2017 4:23 PM
Hi,
i need to update 1500 employee records,
my new data i have in Excel,...
--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)

March 24, 2017 at 4:29 pm

#1934909
RE: I'm "working from home"

I've found that working from home on a dedicated project allows me to get a whole lot more done... if I ignore the company email, urgent PMs, text messages, etc,...
--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)

March 24, 2017 at 4:10 pm

#1934905
RE: Columns to rows and rows to columns

p.shabbir - Friday, March 24, 2017 1:17 PM
Hi,
I have table like below.
START_DATE    END_DATE    COUNTRY        VALUES
1/1/2017        2/1/2017        USA                      20
1/1/2017        2/1/2017        INDIA          50
1/1/2017        2/1/2017        AUSTRALIA   ...
--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)

March 24, 2017 at 3:56 pm

#1934902
RE: Format of File Before Bulk Insert

John215 - Friday, March 24, 2017 1:45 PM
Hello all,
I have files that come in everyday that needs to be bulk inserted. Some...
--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)

March 24, 2017 at 3:42 pm

#1934900

Viewing 15 posts - 15,316 through 15,330 (of 59,063 total)