Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,781 through 21,795 (of 59,072 total)

RE: Backup/restore parition

GilaMonster (1/21/2015)
No, not unless the file groups in question are read only.
To restore a DB from file/filegroup backups, the following is required:
1) If the DB is in simple recovery, then...
--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)

January 21, 2015 at 8:16 am

#1771839
RE: Prevent sp_ Procedures with SQLCop

John Mitchell-245523 (1/21/2015)
Jeff
Yes, I share your distaste for Hungarian notation. But some people swear by it, and if it works for them, who am I to tell them to avoid...
--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)

January 21, 2015 at 8:13 am

#1771836
RE: What are First Steps for a dba in new Office?

Again, this is for what the first things are that need to be done. The most important things are the backups and basic security, as in those things need...
--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)

January 21, 2015 at 8:05 am

#1771827
RE: Please explain what this Trigger query does

Eirikur Eiriksson (1/20/2015)
Jeff Moden (1/19/2015)
Eirikur Eiriksson (1/19/2015)
Quick thought, if the table's content is only being maintained with the MERGE statement, it would be better to move the trigger's logic into...
--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)

January 21, 2015 at 8:00 am

#1771822
RE: Please explain what this Trigger query does

lawlietdba (1/21/2015)
Hi Jeff,
Please guide me in re writing the trigger for two scenarios which you have advised ... I'm very much interested in doing
That ... I have given 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)

January 21, 2015 at 7:54 am

#1771820
RE: Backup/restore parition

These two movies by Kimberly Tripp should help you a lot.
https://technet.microsoft.com/en-us/sqlserver/gg545009.aspx
https://technet.microsoft.com/en-us/sqlserver/gg545008.aspx
--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)

January 20, 2015 at 3:15 pm

#1771639
RE: Backup/restore parition

I believe it's as simple as backing up and restoring by file name. If you need to do a restore and the partition file isn't read_only, then you'll need...
--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)

January 20, 2015 at 3:12 pm

#1771638
RE: Prevent sp_ Procedures with SQLCop

RonKyle (1/20/2015)
It's a real fun trip through the code if even one well used column has its datatype changed.
Just because something is difficult on change doesn't mean it's a bad...
--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)

January 20, 2015 at 2:58 pm

#1771635
RE: Prevent sp_ Procedures with SQLCop

John Mitchell-245523 (1/15/2015)
SQLvis (1/15/2015)
Is there a list of standard object nomenclature for indexes, procedures, functions, and views (etc) that most teams should follow?
Not really. It's more important to 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)

January 20, 2015 at 2:45 pm

#1771625
RE: Database growth calculations & Shrinking DBs

Brandie Tarvin (1/20/2015)
Does anyone have any recommendations on the best methods for figuring out proper database growth percentages (or MBs)?
Lately it seems many of our databases are growing "extra large"...
--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)

January 20, 2015 at 9:46 am

#1771513
RE: Please explain what this Trigger query does

ScottPletcher (1/20/2015)
Jeff Moden (1/19/2015)
ScottPletcher (1/19/2015)
I still see no reason to risk @@ROWCOUNT if you just want to know if a row was modified or not -- that easy enough to...
--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)

January 20, 2015 at 9:34 am

#1771507
RE: Recursive data but increasing date by one day

richardmgreen1 (1/20/2015)
Hi Jeff
I think that just about covers it.
I'll also need the dates so I can do a DATEDIFF to find the number of days.
K. Thanks, Richard. I'll...
--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)

January 20, 2015 at 7:44 am

#1771463
RE: Rebuilding Indexes - Clustered v Non-Clustered

Grant Fritchey (1/20/2015)
Doing the rebuilds online can reduce contention, but it will increase the amount of time it takes. It's a tradeoff.
I've been doing some experiments concerning the differences between...
--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)

January 20, 2015 at 7:43 am

#1771462
RE: Using GetDate() between two dates

You bet. Thank you for your feedback.
--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)

January 20, 2015 at 7:35 am

#1771459
RE: How do I get a list of all the databases within the sever

mw112009 (1/20/2015)
Sorry what I meant when I said "DO NOT REPLY" is I had already found the solution. Didn't want to bother anyone.
Ah... got it. Thanks for your consideration.
--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)

January 20, 2015 at 7:34 am

#1771458

Viewing 15 posts - 21,781 through 21,795 (of 59,072 total)