Jeff Moden

Forum Replies Created

Viewing 15 posts - 29,896 through 29,910 (of 59,101 total)

RE: Generating Test Data: Part 2 - Generating Sequential and Random Dates

Lee Crain (5/4/2012)
Jeff,
I may have missed it glancing through all of the posts. When do you plan to produce Part 3?
Thanks for the effort you expended on such excellent...
--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)

May 19, 2012 at 6:33 pm

#1490163
RE: Importing Multiple csv files into one SQL Table

Evil Kraig F (5/18/2012)
BAH! Go back to Cobol you Luddites!
P.S. Heh... that's gotta be your 6 talking because your mouth knows better. How do you like your...
--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)

May 19, 2012 at 4:56 pm

#1490160
RE: Result to a variable

Then the partial answer that MysteryJimbo gave should do the trick for you. Just change out the sample query he used with yours. And, yeah, the query 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)

May 19, 2012 at 4:48 pm

#1490159
RE: Hash Partitioning

Partioning is a great way to reduce index maintenance. It might even help the performance of certain types of queries. However, and I've not done it in Oracle,...
--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)

May 19, 2012 at 12:04 pm

#1490145
RE: Hash Partitioning

opc.three (5/19/2012)
GilaMonster (5/19/2012)
You are highly unlikely to achieve anything other than adding complexity and wasting time. Partitioning is not a performance optimisation (mostly), it's for ease of maintenance, loading 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)

May 19, 2012 at 10:06 am

#1490133
RE: Result to a variable

Ryan007 (5/18/2012)
No, a single variable can store single value. A result set with more than one rows and columns returned from a table can not be put into a single...
--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)

May 19, 2012 at 9:43 am

#1490130
RE: Result to a variable

mirravi (5/18/2012)
Hi,
Thanks for the reply, actually my job is to mail the results to the recipient thru DBmail ,so i want to store the result to a variable and send...
--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)

May 19, 2012 at 9:36 am

#1490129
RE: financial triangles

peseta30 (5/18/2012)
Does anyone knows a good place to find sql server samples to generate Actuaries or the so called Financial Triangles?
I'm trying to do a report using report builder 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)

May 19, 2012 at 9:29 am

#1490127
RE: Audit Trail Generator

rjs123431 (5/17/2012)
Hi All,
We use sql server 2005 and 2008. I need to trace INSERTED,DELETED and UPDATED records in some tables in this manner.
- LogID (auto increment)
- TableName
-...
--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)

May 19, 2012 at 8:13 am

#1490121
RE: Audit Trail Generator

GSquared (5/18/2012)
Jeff Moden (5/18/2012)
And someone please post one of the XML triggers. One of you 3 folks recommending this should have one right at your fingertips, yes? 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)

May 19, 2012 at 7:33 am

#1490118
RE: Importing Multiple csv files into one SQL Table

Evil Kraig F (5/18/2012)
Jeff Moden (5/18/2012)
Lowell (5/18/2012)
I'll go all devils advocate on the SSIS guys and present a solution i put together for other posts that is all TSQL.
Thsi requires...
--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)

May 18, 2012 at 6:30 pm

#1490044
RE: Many to one TOP N UPDATE troubles

CELKO (5/18/2012)
Please stop programming until you are minimally competent and have some manners.
BWAAA-HAAA!!! The pot calls the kettle black.
--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)

May 18, 2012 at 5:53 pm

#1490040
RE: Passing parameter Dynamically to Open Query inside Function

Matt Miller (#4) (5/18/2012)
As while you are correct that the compiler currenly isn't smart enough to detect the stored proc call, you are going against the intended use.
Vinu 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)

May 18, 2012 at 5:47 pm

#1490038
RE: will deleting and restoring database will it improve perfomance?

sukhoi971 (5/18/2012)
my stored procedures are running very slow...
Were they ever actually running fast with the amount of data you currently have?
--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)

May 18, 2012 at 5:44 pm

#1490035
RE: PowerShell - Get Permissions

tomeaton12 (5/18/2012)
Hello,
I am new to Powershell and I have been asked to get the SQL Server Database data path and insert this veriable into a script to gather permissions from...
--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)

May 18, 2012 at 5:36 pm

#1490028

Viewing 15 posts - 29,896 through 29,910 (of 59,101 total)