Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,811 through 21,825 (of 59,098 total)

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
RE: Please explain what this Trigger query does

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 that implementation, that's straight...
--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 19, 2015 at 11:17 pm

#1771294
RE: Find Affected Row Count from a Dynamic Query

danurbin (1/19/2015)
Use
[Code]
Set NoCount ON
[/code]
at the beginning of the script. for good measure, turn it back off when done...
Shouldn't need to turn it off. When the session closes, so...
--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 19, 2015 at 5:48 pm

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

mw112009 (1/19/2015)
use master
select top 100 * from sys.databases order by name
DONE! Do not reply
"Do not reply"??? What's up with that? Heh... DO NOT REPLY... it's a rhetorical question. 😛
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)

January 19, 2015 at 5:43 pm

#1771270
RE: Creating a trace to log values updates by job

It sounds more like you want "auditing" than a trace.
--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 19, 2015 at 5:40 pm

#1771268

Viewing 15 posts - 21,811 through 21,825 (of 59,098 total)