Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,301 through 21,315 (of 59,098 total)

RE: Trigger for updates on a row using previous record value?

Enjoy_SQL (3/13/2015)
I ended up creating a view using similar logic to MMartins1, then build a trigger on the main table to reference the view. It works nicely. 🙂
Thanks everyone for...
--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 14, 2015 at 10:59 am

#1784037
RE: Trigger for updates on a row using previous record value?

CELKO (3/11/2015)
>> I appreciate the quick response. Apologies, I am new to the forum .. I will try to clarify. <<
Thanks for trying, but you have not learned basic data modeling...
--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 14, 2015 at 10:56 am

#1784036
RE: Count number of backup files are deleted from a default backup location

To be honest, I wouldn't use the DOS "loop" to do the deletes. I'd import the results of a DIR into a table and parse the row information 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)

March 14, 2015 at 10:17 am

#1784034
RE: delete data from partitions - faster approach

Greg Robidoux has a short article on the subject. The keyword in SQL Server is "Switch". You might also want to look that word and the phrase "partitioned...
--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 14, 2015 at 10:14 am

#1784033
RE: Add 15 minutes to a time in char format

CELKO (3/12/2015)
CREATE TABLE Timeslots
(slot_start_time TIME(1) NOT NULL PRIMARY KEY,
slot_end_time TIME(1) NOT NULL,
CHECK (start_time < end_time));
INSERT INTO Timeslots --15 min intervals
VALUES ('00:00:00.0', '00:14:59.9'),
('00:15:00.0', '00:29:59.9'),
('00:30:00.0', '00:44:59.9'),
('00:45:00.0', '01:00:59.9'),
..
('23:45:00.0',...
--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 13, 2015 at 2:13 pm

#1783988
RE: Setting Different Colors for Connections in SSMS

Jeff Moden (3/13/2015)
Carl Neirynck (3/13/2015)
!!! Be aware that this ONLY works if you open a query window via Registered Servers!!!
So if you connect to a server/instance through the Object Explorer...
--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 13, 2015 at 8:56 am

#1783911
RE: Setting Different Colors for Connections in SSMS

Carl Neirynck (3/13/2015)
!!! Be aware that this ONLY works if you open a query window via Registered Servers!!!
So if you connect to a server/instance through the Object Explorer or when...
--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 13, 2015 at 8:51 am

#1783908
RE: The Worst Comments

Gary Varga (3/13/2015)
I was going to try and say "no comment" in a witty way but as I am not first to highlight the issue (and I am not always...
--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 13, 2015 at 6:20 am

#1783840
RE: Data Breach Danger

The thing that absolutely pisses me off about all of this is the cavalier attitude that many companies have about their data. I regularly see posts that obviously come...
--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 12, 2015 at 11:56 am

#1783680
RE: De-identification of Fields

g.britton (3/12/2015)
What does this mean: "de-identification of specific fields"
perhaps if you post some sample data and required results, we can help.
Obfuscation of personally identifiable information, I believe...
--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 12, 2015 at 11:36 am

#1783672
RE: Share your best possible answers--

Koen Verbeeck (3/12/2015)
Alvin Ramard (3/12/2015)
Seems to be a trend to use color that are not best for contrast. It's more common on web pages. My pet peeve? Why...
--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 12, 2015 at 10:22 am

#1783638
RE: Share your best possible answers--

below86 (3/12/2015)
Jeff Moden (2/19/2015)
The correction I would make is that the sources that you mention aren't what I'd call "heterogeneous". The sources that you mention are very specific 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)

March 12, 2015 at 10:21 am

#1783637
RE: SQL Server Idle Time

One of the things I have running is a PerfMon that takes a sample every 15 minutes. I use PerfMon because I'm still currently stuck in the world 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 11, 2015 at 8:00 pm

#1783507
RE: status suspended on command Killed/RolleBack

smoham22 (3/4/2015)
Its a scrubbing job. it takes a backup from production and restores it on development server and scrubs out the sensitive data for development.
spid went away after 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 11, 2015 at 7:51 pm

#1783505
RE: Share your best possible answers--

Luis Cazares (2/26/2015)
Jeff Moden (2/26/2015)
Moin Ul Haque (2/26/2015)
Jeff Moden (2/25/2015)
Moin Ul Haque (2/25/2015)
I can quote my own experience here - Out of need, I was asked to develop a database...
--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 11, 2015 at 7:46 pm

#1783504

Viewing 15 posts - 21,301 through 21,315 (of 59,098 total)