Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,346 through 15,360 (of 59,097 total)

RE: Database Architecture Question

I don't know what your hardware is like but we use SAN snapshots for things like this. It's nearly instantaneous. Each SAN manufacturer seems to have their own way 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)

March 25, 2017 at 8:42 pm

#1934964
RE: Is full backup enough

OMG!!! Make that 6 posts on the same subject.
https://www.sqlservercentral.com/Forums/1861649/Moving-2-TB-600-databases-from-32-bit-SQL-Server-2008-R2-to-64-bit-SQL-Server-2014-from-Friday-night
You now have the steps to take. Just do 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)

March 25, 2017 at 8:34 pm

#1934963
RE: Is full backup enough

Whup! Lookie there! Yet another post on the same subject more than a month ago.
https://www.sqlservercentral.com/Forums/1858895/Upgrading-from-SQL-Server-2008R2-Std-Ed-on-32-bit-hardware-to-SQL-Server-2012-Ent-64-bit-on-64-bit-h
What really sucks about this is that Joe Pattyn gave 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)

March 25, 2017 at 8:27 pm

#1934962
RE: Is full backup enough

Make that a total of 4 posts on the similar subject now.
https://www.sqlservercentral.com/Forums/1862600/moving-several-large-databases-from-old-hardware-Live-to-new-hardware
Seems like we've gone from 40 databases to 500 database to 1200 databases back to 500...
--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:18 pm

#1934961
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

Viewing 15 posts - 15,346 through 15,360 (of 59,097 total)