Jeff Moden

Forum Replies Created

Viewing 15 posts - 34,681 through 34,695 (of 59,099 total)

RE: Update table

Gianluca Sartori (3/10/2011)
I would still wait for Jeff's reply, I might have overlooked something.
You pretty much sussed it, Gianluca. At this point, all I can do is to recommend...
--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 10, 2011 at 9:16 pm

#1297440
RE: Update table

Gianluca Sartori (3/10/2011)
Are you sure, Jeff?
If I understand it correctly, the sort order should not matter.
No. My bad. I didn't read the requirements correctly. My apologies. :blush:
--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 10, 2011 at 9:03 pm

#1297438
RE: SQL Spackle - Find 0 values in sums by date

Patrick Cahill (3/10/2011)
I'll take this one.
I'll be happy to provide a technical review on this one, Patrick. Drop me an email, if you'd like.
--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 10, 2011 at 8:49 pm

#1297437
RE: How do you create Valid_From and Valid_To dates

Allow me to ask a question in return before I respond, please. Why are we playing musical chairs with the requirements? 😉
--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 10, 2011 at 8:40 pm

#1297436
RE: Update Trigger on multiple columns

M Joomun (3/10/2011)
Hello All,
I'd like to create an update trigger to detect changes to multiple columns. I can create a trigger to append an entire row of data to an...
--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 10, 2011 at 8:04 pm

#1297431
RE: Avoiding Logging

Heh... everytime I see someone ask "How do I avoid logging", I want to answer "Stay out of the woods." 😛
--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 10, 2011 at 7:58 pm

#1297429
RE: distributed transaction

sql_2005_fan (3/10/2011)
can we insert the error or error number into the database with an insert statement?
If I understand your question correctly, the answer is "Absolutely". And more.
Lookup Try/Catch 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)

March 10, 2011 at 7:55 pm

#1297428
RE: DataMasking

Maybe HASHBYTES?
--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 10, 2011 at 7:53 pm

#1297427
RE: DBA Concerns

Brilliant! This was the perfect followup to the other editorial you wrote on what acceptable data loss is and the cost of protecting data at different levels. Thanks,...
--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 10, 2011 at 7:52 pm

#1297426
RE: Creating nested xml tree

Heh... ya just gotta love XML "Tag bloat". 😉
--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 10, 2011 at 7:50 pm

#1297425
RE: Are the posted questions getting worse?

Chris Morris-439714 (3/7/2011)
SQLkiwi (3/4/2011)
Exciting day - just had my first Simple Talk article published:
http://www.simple-talk.com/sql/learn-sql-server/understanding-and-using-parallelism-in-sql-server/
Good lord Paul, they get better and better. You have an enviable skill, like Jeff M, at...
--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 10, 2011 at 7:46 pm

#1297424
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (3/9/2011)
jcrawf02 (3/9/2011)
Steve, are you aware that you're sitting on a gold mine? Your barn could power Denver!
http://arstechnica.com/science/news/2011/03/from-the-farmyard-to-the-powerplant.ars?utm_source=rss&utm_medium=rss&utm_campaign=rss
Not sure it's a "gold" mine, but I 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)

March 10, 2011 at 7:37 pm

#1297423
RE: Are the posted questions getting worse?

ALZDBA (3/10/2011)
Brandie Tarvin (3/10/2011)
GilaMonster (3/10/2011)
I'm talking about the case where someone starts a new thread solely to say "Hey everyone, I wrote an awesome blog post on XYZ, go read...
--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 10, 2011 at 7:27 pm

#1297422
RE: Are the posted questions getting worse?

Stefan Krzywicki (3/10/2011)
GSquared (3/10/2011)
Brandie Tarvin (3/10/2011)
It's the Attack of the Acronyms!
Two years ago, we implemented a new process that uses the acronym "RI". I've been working on that process ever...
--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 10, 2011 at 7:22 pm

#1297420
RE: Without using CTE, Please provide a recursive method

dba.varun.in (3/10/2011)
Hi jeff and Bhuvanesh,
I was little bit busy for past few days.I found; u said not to use this query because it will raise issues when data is...
--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 10, 2011 at 7:18 pm

#1297419

Viewing 15 posts - 34,681 through 34,695 (of 59,099 total)