Jeff Moden

Forum Replies Created

Viewing 15 posts - 43,546 through 43,560 (of 59,063 total)

RE: Whats faster, flat files or SQL table

Because you have the data in an array, once loaded, it will probably be the fastest but may not scale well if you consume all of the memory available 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)

June 5, 2009 at 9:08 pm

#1005619
RE: Character Count from a Given String

As Aaron suggests, you might want to let us know why you need to do this so we can ensure you get the best solution.
In the mean time and 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)

June 5, 2009 at 8:59 pm

#1005618
RE: What SQL Server Sites do you use?

99.99% SQLServerCentral.com - I like folks like you and the others I've come to know and some of the other sites just seem to bloody rude at times.
You have my...
--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)

June 5, 2009 at 8:55 pm

#1005617
RE: Parameters

keywestfl9 (6/5/2009)
i am creating a report with four parameter
Application name, region,type,server
i want to do in such a way the user can select
1. Application alone and all details should be displayed
2....
--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)

June 5, 2009 at 8:52 pm

#1005616
RE: Sum of top n rows

arijit (6/4/2009)
Barry, your code has some issue and does not run in SQ 2000.
The error given is
Invalid column name 'studentID'.
You probably have a left over #Temp table 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)

June 5, 2009 at 8:48 pm

#1005615
RE: Index fragmentation

Does the table have a clustered index anywhere on 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)

June 5, 2009 at 8:42 pm

#1005614
RE: What is the equivalent to Yes/No data type in SQL?

Depending on what is really needed outside of that column, I'll sometimes make the column a TINYINT because you can aggregate TINYINT, but not BIT. Of course, same old...
--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)

June 5, 2009 at 8:40 pm

#1005613
RE: charindex help

Borrowing on John's good data creation code and assuming the column is actually a VARCHAR instead of a char, here's a super simple way to take care of double, triple,...
--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)

June 5, 2009 at 8:29 pm

#1005611
RE: Circular logging a T-Log

Ack... my apologies... Lynn already pointed out the {f1} key. Sorry for the duplication of information.
--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)

June 5, 2009 at 6:22 pm

#1005595
RE: Are the posted questions getting worse?

Lynn Pettis (6/5/2009)
GilaMonster (6/5/2009)
Lynn Pettis (6/5/2009)
What I am thinking of doing in the future when I suggest to OP's to read Books Online is to add an additional statement that...
--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)

June 5, 2009 at 3:44 pm

#1005572
RE: Circular logging a T-Log

To add to what Gail said, "Books Online" or "BOL" is the help system that comes free with SQL Server and can normally be reached just by pressing the {f1}...
--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)

June 5, 2009 at 3:38 pm

#1005567
RE: Are the posted questions getting worse?

Gianluca Sartori (6/5/2009)
I won't blame Jeff if some day it stops working, I will just restore the old procedure and tell the users they have to wait 90 minutes 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)

June 5, 2009 at 9:25 am

#1005378
RE: Are the posted questions getting worse?

jcrawf02 (6/5/2009)
Gianluca Sartori (6/5/2009)
I don't know if this is a proof, but for sure it is "half a proof".
Regards,
Gianluca
Does that make it a theorem?
Heh... in theory. 😛
--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)

June 5, 2009 at 9:21 am

#1005371
RE: Execute SQL job through batch file

The use of cmd files to execute sql is a powerful tool that is underutilized...
I absolutely agree with that. And, old or not, the idea is "there". A...
--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)

June 5, 2009 at 8:27 am

#1005313
RE: Convert Date

Bruce W Cassidy (6/4/2009)
[font="Verdana"]We do have a field named "calendar_date_ddmmyyyy", and I suspect it was created by one of the dodgy consultants we had in who we've been cleaning up...
--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)

June 5, 2009 at 7:38 am

#1005249

Viewing 15 posts - 43,546 through 43,560 (of 59,063 total)