Jeff Moden

Forum Replies Created

Viewing 15 posts - 36,301 through 36,315 (of 59,102 total)

RE: Efficient ways to reset lost sql sa password

yitiana (9/19/2010)
Have you ever forgot or lost your SQL Server sa password?
I'm always amazed at how many people do such a thing.
--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)

October 24, 2010 at 12:18 pm

#1241350
RE: Is this "global recession" over?

Oksana March (10/24/2010)
Can somebody who knows say for sure if this global recession is over now? I am getting conflicting information.
I am not talking about what it *feels* like, but...
--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)

October 24, 2010 at 12:15 pm

#1241349
RE: Are the posted questions getting worse?

Wow... thanks for the insight on SSIS, folks. I've mostly resisted spending any decent amount of time on it because of what I've seen. Thanks to other people's...
--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)

October 24, 2010 at 12:11 pm

#1241348
RE: How best to push large DB Copies over the wire on a regular schedule

As a side bar, IIRC, changing the recovery model to "Simple" breaks the restore chain. If this is transfer of data needs to occur on a regular basis, I'd...
--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)

October 24, 2010 at 9:42 am

#1241338
RE: Sequence-numbering groups

Paul,
Do the source (##temp) and destination (##Results) tables need to be global tables in order for the solution that you posted to work?
--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)

October 23, 2010 at 8:41 am

#1241284
RE: Sequence-numbering groups

Paul White NZ (10/23/2010)
If the results need to be persisted, simply change the SELECT into a SELECT INTO.
Heh... Of course... I've really got to stop posting when I'm tired. ...
--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)

October 23, 2010 at 8:13 am

#1241280
RE: Sequence-numbering groups

Paul White NZ (10/23/2010)
I'm not sure I see where the requirement to update the original table comes from?
True enough. I suppose the output could be consumed by other code.
--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)

October 23, 2010 at 8:02 am

#1241278
RE: SPLIT TSQL Between two character

With that good thought in mind, here's a link to all of Paul White's articles. For the current problem at hand, take a look at his two articles on...
--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)

October 22, 2010 at 10:37 pm

#1241237
RE: Sequence-numbering groups

Chris Morris-439714 (10/22/2010)
Heh Jeff's gonna hate me for this but I couldn't resist it.
400,000 rows in 15 seconds:
Actually, I don't hate you. That's some good, solid, creative, fast code,...
--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)

October 22, 2010 at 10:29 pm

#1241235
RE: SPLIT TSQL Between two character

Craig Farrell (10/22/2010)
WayneS (10/21/2010)
Here is the latest version of the Delimited Split Function
DelimitedSplit8k... d'oh. My bad. Thank you Wayne. It's now (finally) stored in my 'favorites' folder.
Jeff...
--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)

October 22, 2010 at 8:33 pm

#1241232
RE: SPLIT TSQL Between two character

By the way, if you do decide to use the DelimitedSplit8K function (which, of course, has lots of uses), here's how to solve the same problem using it... and 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)

October 22, 2010 at 8:22 pm

#1241231
RE: SPLIT TSQL Between two character

Craig Farrell (10/21/2010)
Here's the DelimitedString8k function that's been heavily worked on round these parts. Modify to suit your needs. I didn't create it, didn't work on it, 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)

October 22, 2010 at 8:16 pm

#1241230
RE: SPLIT TSQL Between two character

Ok... we'll handle this in a couple of steps. First, we need some test data. Take a look at the first link in my signature line at 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)

October 22, 2010 at 4:27 pm

#1241216
RE: More efficient way

Bill_CCAC (10/22/2010)
It is fun Chad 😀
I'm thinking I shouldn't post the table structures or anything like that because of our privacy and security restrictions. I may have even stepped over...
--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)

October 22, 2010 at 1:48 pm

#1241163
RE: SPLIT TSQL Between two character

ja0 (10/22/2010)
I made simple function that make what I wanted. The problem is that, I dont know how to do with a table like this,
ID Value
1 ...
--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)

October 22, 2010 at 1:46 pm

#1241161

Viewing 15 posts - 36,301 through 36,315 (of 59,102 total)