Jeff Moden

Forum Replies Created

Viewing 15 posts - 39,421 through 39,435 (of 59,072 total)

RE: SQL QUERY TAKES more than 4 mnts....any help me plz..

Even your 1 lakh table is comparatively small for a lot of people and should probably be nearly instantaneous. But, "It Depends" on things we cannot see from here....
--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)

March 9, 2010 at 7:19 pm

#1131083
RE: Brain Fried

Most DBAs, whether System, Application, or Hybrid, don't know everything about SQL Server. There's just not enough time in the day. Some do better than others but even...
--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)

March 9, 2010 at 7:12 pm

#1131081
RE: Sync Production Databases with Stage

If the systems are on a decent SAN, a SAN Clone is a great option. Production system never goes down during the "transfer" and the dev system is only...
--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)

March 9, 2010 at 7:07 pm

#1131080
RE: Are the posted questions getting worse?

Dan.Humphries (3/9/2010)
I thought I would throw my two cents in on this one since I beleive I have likely asked a question in the past that seemed obvious to many....
--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)

March 9, 2010 at 4:42 pm

#1131060
RE: Enormous Tables - How to still get Best Performance

That's why I was asking "which edition"... IIRC, indexed views and partitioned tables (which I believe would also help here) are only available in the Enterprise Edition (understood they're also...
--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)

March 9, 2010 at 8:49 am

#1130721
RE: Concatenate column rows into one row with a group by

Ah... if it was a snake, it would have bitten me...
]--It is here where I would like to concatenate the ledger(s)[/i]
I'll have to take a look at this tonight.
--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)

March 9, 2010 at 8:46 am

#1130716
RE: Concatenate column rows into one row with a group by

I'm at work right now and might just be missing because I'm in a bit of a press for time, but how does what you just posted have anything 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)

March 9, 2010 at 8:44 am

#1130713
RE: Enormous Tables - How to still get Best Performance

Are you using the Enterprise or Standard Edition of SQL Server?
--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)

March 9, 2010 at 6:09 am

#1130584
RE: speed concerns for a large report

I believe that pre-aggregation would be one of the keys to speed here. Since you're running it as a job every 30 minutes, my suggestion would be to try...
--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)

March 9, 2010 at 5:31 am

#1130567
RE: Performance tuning

anishrtuladhar (3/8/2010)
Do performance tuning using SSAS....... when u need.:-D
Not sure what you mean. How do you performance tune a query using SSAS?
--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)

March 9, 2010 at 5:17 am

#1130564
RE: always use incorrect index to run the query by sql server

ColinChen (3/8/2010)
Thanks for everyone.
Now I found the issue:
Because the fieldB is varchar , and the fieldC is nvarchar.
select * from tableA where fieldB in(select fieldc from tablec)
If I alter 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)

March 9, 2010 at 5:15 am

#1130563
RE: Creating Temp Table with Avg

Nah... I was "Jonesin' " for a code problem instead of all the bloody performance problems we've had lately. Heh... I was on a "mission" on this one especially...
--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)

March 8, 2010 at 9:40 pm

#1130419
RE: What is the Best Practice of designing a table for storing a period of dates, Query for fiding the period

Ismail Ahmed (3/8/2010)
Hi Friends,
I have to add a table 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)

March 8, 2010 at 9:18 pm

#1130411
RE: Creating Temp Table with Avg

jrgustin 30365 (3/8/2010)
Hello,
I am trying to create a function that will produce an avg() for the selected results based on a string containing the digit of the filed ie(rda1)....
--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)

March 8, 2010 at 9:02 pm

#1130404
RE: Pivot table for dynamic data

Thanks for the referral, Paul.
--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)

March 8, 2010 at 7:29 pm

#1130377

Viewing 15 posts - 39,421 through 39,435 (of 59,072 total)