Jeff Moden

Forum Replies Created

Viewing 15 posts - 43,576 through 43,590 (of 59,101 total)

RE: text, ntext and image datatypes in triggers

I don't know the answer to your question, but I'd love to see your trigger code for this. I've always had a bit of a problem with InsteadOf triggers...
--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 10:52 pm

#1005636
RE: Need to export column headings with stored procedure

The easiest way to do this is to create a file in advance with the headers in it. BCP the data out to a separate file. Use 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)

June 5, 2009 at 10:47 pm

#1005634
RE: Whats faster, flat files or SQL table

No, you where clear. You just didn't think I was. 😉
Which do you think will be faster if you have 5000 files with 5000 lines each for a total...
--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 10:44 pm

#1005633
RE: Build a table with info on my Tables

I don't know if it'll be overkill for what you're trying to do, but this will certainly let you know what's going on with your tables. Think of 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 10:34 pm

#1005632
RE: Build a table with info on my Tables

DBCC UPDATEUSAGE(0) is all you need to run before you run the script you built. It'll take a little while to run if you have a huge database 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)

June 5, 2009 at 10:28 pm

#1005630
RE: How to update a large text field

dave b (6/5/2009)
It will always be: * " ; Serial" with any given amount of spaces or tabs between the date, semicolon and "Serial."
Do you have to keep those...
--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 10:11 pm

#1005628
RE: Shaking the Money Tree

Heh...
What I have found is that whatever managment thinks is "sexy" will get the dollars. That usually means GUI dev tools or some chunk of hardware with lots...
--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 10:04 pm

#1005625
RE: need help -- tempdb full message, but its only 8 mb in size

I agree with Vinay... sounds like someone set the growth limit on TempDB.
--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:12 pm

#1005620
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

Viewing 15 posts - 43,576 through 43,590 (of 59,101 total)