Jeff Moden

Forum Replies Created

Viewing 15 posts - 35,956 through 35,970 (of 59,099 total)

RE: Big table 50MB containing just 1000 records ( a few small fields each record)

Iulian -207023 (11/23/2010)
I am sorry Chris I don't have the table structure at hand.
Thanks,
Iulian
Heh... you know how much the table is using for space and can't generate the script...
--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)

November 23, 2010 at 10:28 pm

#1254889
RE: Need help building a query.

Ram2002 (11/23/2010)
Hi Thanx for Reply...
Yes based on Emp_ID and start date. It is like the row follows with end date or if end date not there then next row will...
--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)

November 23, 2010 at 10:25 pm

#1254888
RE: cross apply

kevin4u06 (11/23/2010)
I dont want to join the function and the table ...i want to pass data in the column from the table as a variable to the function
Cross Apply is...
--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)

November 23, 2010 at 10:22 pm

#1254885
RE: Dynamic SQL issue

LutzM (11/23/2010)
What's the specific reason for you not to use global temp tables (##table)
Concurrency and logical separation of data between concurrent runs because all sprocs that use it see 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)

November 23, 2010 at 10:17 pm

#1254884
RE: Dynamic query in a function

sumit.agrawal (11/23/2010)
this proc should store the output in temp table.. then create a function which will get the values from the temp table....
Just to be clear, one can no more...
--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)

November 23, 2010 at 7:58 pm

#1254864
RE: Dynamic query in a function

S_Kumar_S (11/22/2010)
Well Jeff, I didn't ask if we can execute a dynamic sql from function, I asked if there is a work around for it. i knew there is no...
--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)

November 23, 2010 at 7:54 pm

#1254863
RE: Work around for SQL server performance issue

Gangadhara MS (11/21/2010)
Dear Experts,
We are having performance issues on production server.
The following task i have carried out and i need your suggestion further.
1.I have used profiler to trace 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)

November 23, 2010 at 7:27 pm

#1254858
RE: how to get consecutive records grouped

@Justin,
Are you all set now?
--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)

November 23, 2010 at 7:42 am

#1254463
RE: how to get consecutive records grouped

mister.magoo (11/23/2010)
This sounds like it could be solved by the "Quirky Update" method to me - as you need to compare each row to the previous row.
See Jeff's article about...
--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)

November 23, 2010 at 7:41 am

#1254462
RE: how to get consecutive records grouped

Justin,
Sachin's code almost did it. It just needed a push over the edge to get it where you wanted it. Here's the push...
WITH
cteGroups AS
(
SELECT dt,
...
--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)

November 22, 2010 at 11:41 pm

#1254198
RE: how to get consecutive records grouped

Sachin Nandanwar (11/22/2010)
It's quite difficult to give a solution without actually looking at the records which are causing the problem.
What on Earth are you talking about? The OP gave...
--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)

November 22, 2010 at 11:37 pm

#1254196
RE: need help with loading a string

WayneS (11/22/2010)
kevin4u06 (11/22/2010)
There is one more added complexity , in some recordds the state has for example
Arizona
New Jersy
instead of just their abbreviation
The spaces in this are going to complicate things...
--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)

November 22, 2010 at 8:01 pm

#1254156
RE: Are the posted questions getting worse?

Looks like the stress you were talking about caught up with you, Jack. I've actually been through that a couple of times including the trips to the hospital. ...
--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)

November 22, 2010 at 7:58 pm

#1254155
RE: Are the posted questions getting worse?

Alvin Ramard (11/22/2010)
Brandie Tarvin (11/22/2010)
CirquedeSQLeil (11/22/2010)
Alvin Ramard (11/22/2010)
Brandie Tarvin (11/22/2010)
I live in Florida now. Black Friday is not so bad when you can wait in line at 2:00 a.m. 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)

November 22, 2010 at 7:46 pm

#1254154
RE: Little Devices

WayneS (11/22/2010)
Jeff Moden (11/22/2010)
I just don't ever want to be that "productive". Down-time is very important to me.
Yes, but I refer back to what Steve posted above:
If 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)

November 22, 2010 at 7:35 pm

#1254153

Viewing 15 posts - 35,956 through 35,970 (of 59,099 total)