Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,766 through 21,780 (of 59,072 total)

RE: Please explain what this Trigger query does

Nope. No error. I kept thinking that MERGE would fire triggers simultaneously if it did both an UPDATE and a DELETE. It doesn't. They're treated as...
--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 22, 2015 at 12:02 am

#1772064
RE: Using a cursor in Sql trigger

dwain.c (1/21/2015)
dopydb (1/21/2015)
Yea only 100 or so inserts a day, otherwise i wouldnt use a trigger at all
Any tips for making it more efficient? 🙂 always interested in other approaches
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 11:39 pm

#1772061
RE: What is the best practice about maintain and using Big Log Database

Yes. Use the SQL Server Enterprise Edition and do Table Partitioning.
--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 11:20 pm

#1772060
RE: Please explain what this Trigger query does

Sorry. Spotted a bug in my code and had to take it down. I'll be back.
--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 10:34 pm

#1772057
RE: Please explain what this Trigger query does

crmitchell (1/19/2015)
another caveat on no 6.
Check that you don't have any jobs which disable or worse delete and then later reenable or recreate those triggers.
If you do then they will...
--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 10:23 pm

#1772055
RE: SAN Response Times

burfos (1/21/2015)
Yes it is an application with separate application servers and it is my least liked system at this site for many many reasons reasons some of which are...
- 9448...
--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:56 pm

#1772048
RE: SAN Response Times

Wayne West (1/21/2015)
I hate to ask this, but is your canned system running an application server? At a prior job we had one that required no stored procedures in...
--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:53 pm

#1772047
RE: Alter table performance

Charles Kincaid (1/21/2015)
Understanding the way that SQL Server stores things is very helpful in understanding why some table alterations seem to take no time at all and other will bring...
--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:49 pm

#1772044
RE: Prevent sp_ Procedures with SQLCop

John Mitchell-245523 (1/21/2015)
Well off-topic now, but I think I can guess. I use ANSI compliant where it's the only distinguishing feature between two alternatives. For example, CURRENT_TIMESTAMP and...
--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:40 pm

#1772042
RE: Prevent sp_ Procedures with SQLCop

John Mitchell-245523 (1/21/2015)
Whether anyone thinks it's arrogant or controlling or what have
I only said it's arrogant to tell someone that you don't know and whose environment and circumstances 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)

January 21, 2015 at 6:42 pm

#1772040
RE: Prevent sp_ Procedures with SQLCop

RonKyle (1/21/2015)
Just because you are cleaning up these things doesn't mean Hungarian notation is bad.
You'll have to pardon me when I say that, IMHO, it's horrible especially when 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)

January 21, 2015 at 9:27 am

#1771890
RE: Prevent sp_ Procedures with SQLCop

There's nothing arrogant about it, John. There are many DBAs that simply haven't run into the problems associated with "tbl-ling" and they need to be made aware. 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:41 am

#1771858
RE: Are the posted questions getting worse?

Sioban Krzywicki (1/21/2015)
Jeff Moden (1/21/2015)
Sioban Krzywicki (1/21/2015)
I hope everyone here is ok with it too...
To be honest, I don't care if someone's eyes are on stems and they leave snail...
--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:32 am

#1771853
RE: Backup/restore parition

GilaMonster (1/21/2015)
Jeff Moden (1/21/2015)
GilaMonster (1/21/2015)
If you're restoring to a new database, the Primary filegroup has to be restored first, then any file/filegroup backups, the the log backups need to be...
--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:31 am

#1771852
RE: Are the posted questions getting worse?

Sioban Krzywicki (1/21/2015)
I hope everyone here is ok with it too...
To be honest, I don't care if someone's eyes are on stems and they leave snail tracks. Your contributions...
--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:28 am

#1771849

Viewing 15 posts - 21,766 through 21,780 (of 59,072 total)