Jeff Moden

Forum Replies Created

Viewing 15 posts - 36,556 through 36,570 (of 59,067 total)

RE: I need some help with a test, please.

Paul White NZ (9/22/2010)
Jeff Moden (9/22/2010)
Heh... Of course it doesn't handle Unicode correctly... the variables are all VARCHAR.
That's a bit circular! It doesn't handle Unicode because it doesn't? 😛
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)

September 22, 2010 at 8:44 am

#1225660
RE: I need some help with a test, please.

The problem with the Tally Table related splits is that I forgot :blush: to add 1 to the length....
WHERE N BETWEEN 1 AND LEN(@Parameter)+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)

September 22, 2010 at 8:33 am

#1225648
RE: I need some help with a test, please.

Paul White NZ (9/22/2010)
This seems a good time to highlight some other issues too:
The Tally solution does not handle trailing blank records or Unicode characters correctly:
Heh... Of course it doesn'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)

September 22, 2010 at 8:30 am

#1225639
RE: Today's Random Word!

re-freakin'-flection 😀
--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)

September 21, 2010 at 10:35 pm

#1225333
RE: Are the posted questions getting worse?

Alvin Ramard (9/21/2010)
GilaMonster (9/21/2010)
Shawn Melton (9/21/2010)
I like this one:
Knock Knock
Who's There?
sp underscore
sp underscore who?
spid1, spid2, spid3....
I told that one at a dinner at the PASS Summit a few years ago...
--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)

September 21, 2010 at 10:31 pm

#1225332
RE: Are the posted questions getting worse?

Steve Jones - Editor (9/21/2010)
Paul White NZ (9/21/2010)
jcrawf02 (9/21/2010)
I'm with Bob on this one, not sure I fully understand all the requests, but the ones I got look useful 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)

September 21, 2010 at 10:28 pm

#1225330
RE: Are the posted questions getting worse?

GilaMonster (9/21/2010)
Alvin Ramard (9/21/2010)
A query walks into a bar, sees two tables and says: "May I join you?" 😀
That's so old the archaeologists are tired of it.
Reminds me 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)

September 21, 2010 at 10:25 pm

#1225327
RE: Are the posted questions getting worse?

Stefan Krzywicki (9/21/2010)
CirquedeSQLeil (9/21/2010)
Stefan Krzywicki (9/21/2010)
CirquedeSQLeil (9/21/2010)
Chris Morris-439714 (9/21/2010)
khanameerkhan (9/20/2010)
Is there any way to determine who deleted the database in sql server 2008.
Look under tables and in cupboards for one...
--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)

September 21, 2010 at 10:23 pm

#1225326
RE: I need some help with a test, please.

GilaMonster (9/20/2010)
Jeff
Would you like a run on 2008 R2? Will have to be this weekend at earliest, cause I'm not planning to upgrade before then.
Hi Gail... now that I actually...
--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)

September 21, 2010 at 9:45 pm

#1225323
RE: I need some help with a test, please.

rob.symonds (9/20/2010)
Anyone else a little concerned about the 2k8 results for the inline Tally?
Sorry, I would obviously try this myself but I don't have a 2k8 instance to hand, could...
--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)

September 21, 2010 at 9:39 pm

#1225322
RE: fn_fixeddrives() : an alternative for xp_fixeddrives

SQueaLer1 (9/21/2010)
Hi David,
I appreciate the concept but I have to disagree with the approach. We programmers can come up with a lot of "nice" solutions, but they don't always 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)

September 21, 2010 at 6:26 pm

#1225291
RE: SQL Server 2008 - CItrix environment

We ran into this... I don't know what the actual fix was because the boys in OPs took care of it but it had to do with the "number 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)

September 21, 2010 at 7:32 am

#1224800
RE: where can I start with performance Improvement for SQL 2008

Tim Parker (9/20/2010)
Well you have already started with the first thing that needs to be addressed when improving performance in a database. In many cases, regardless of memory or...
--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)

September 21, 2010 at 7:29 am

#1224797
RE: Need to zip and move C2 level audit files

shew (9/21/2010)
ps. (9/21/2010)
Hey Jeff, the problem will arise when there are multiple files on the folder and he tries to zip them in a loop. there will be seperate wipzip...
--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)

September 21, 2010 at 7:21 am

#1224790
RE: Need to zip and move C2 level audit files

ps. (9/21/2010)
Jeff Moden (9/20/2010)
Ah... that may be the key. Is there any problem with you just zipping one file at a time instead of putting a bunch of files...
--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)

September 21, 2010 at 7:17 am

#1224783

Viewing 15 posts - 36,556 through 36,570 (of 59,067 total)