Jeff Moden

Forum Replies Created

Viewing 15 posts - 47,161 through 47,175 (of 59,102 total)

RE: My application's response time has gone down from 20 sec to 2 sec after upgrading from SQL Server 2000 to SQL Server 2005.

Heh... you guys are missing it... OP wants to know why performance IMPROVED so much after the upgrade so they can go back to the original database and make 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)

November 18, 2008 at 7:15 pm

#900252
RE: Optimizing Database Growth

I agree... do an estimate to figure out what the total size should be with a year of data and add 20 to 25% to that number. Set 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 18, 2008 at 7:11 pm

#900249
RE: SQL Table Variable Issue

If they're all like the one you posted with a couple of cursors calling another sproc that probably has another cursor in it, you could be in for some real...
--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 18, 2008 at 7:06 pm

#900246
RE: MS SQL Aggregate Function

Please post what you tried so we can see things like what you tried to GROUP BY. Thanks.
--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 18, 2008 at 6:57 pm

#900243
RE: Overlapping query help

The data should actually match the table definition... instructions in the atricle everyone has posted would really make this easy.
Msg 515, Level 16, State 2, Line 3
Cannot insert the value...
--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 18, 2008 at 6:51 pm

#900240
RE: permissions

metro17 (11/18/2008)
I have 2 tables . Dept and Names . Now I need to grant access to 1 person in Names table on 1 department row in the Dept table...
--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 18, 2008 at 6:44 pm

#900239
RE: Sending Query Results in SMTP Mail

James A. Lawrence (11/18/2008)
Sorry! Already mentioned above!
Still, thanks for the thought.
--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 18, 2008 at 5:45 pm

#900225
RE: Tips for New DBAs

I've got a hell of a lot of comments to make about this article... but, let me summarize, instead...
[font="Arial Black"]"Oh... very well done. Should be required reading for everyone...
--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 18, 2008 at 6:17 am

#899860
RE: Help writing function to get decimal from string

BWAA-HAA! I guess it's because I need more coffee, as well! Maybe that qualifies. 😛
--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 18, 2008 at 6:09 am

#899854
RE: Find out which table columns were inserted from within a trigger

Just remember that you will get an advisory about total row length exceeding 8060 bytes if you use more than a very small handful of columns in the same table...
--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 18, 2008 at 6:07 am

#899853
RE: Help writing function to get decimal from string

Garadin (11/18/2008)
Jeff Moden (11/18/2008)
The really good part about it all is that no matter what goes wrong, I always learn something new even if it's only how to "read minds"...
--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 18, 2008 at 6:02 am

#899847
RE: Select based on Date- How to?

mpdillon (11/18/2008)
But this time I wanted to find a more intuitive method. Some(OK most) of my queries are difficult to read. Having to interpret dates makes them even more so...
--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 18, 2008 at 5:58 am

#899842
RE: Recursive is query is slow

vkundar (11/18/2008)
Jeff thanks for the links.
gborasaniya you are right as this in data warehousing environment mainly in ETL we have constraints on using or creating indexes. we need to deal...
--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 18, 2008 at 5:35 am

#899824
RE: Help writing function to get decimal from string

Chris Morris (11/18/2008)
How often have you spent hours, even days, on a solution for a desperate punter only to find they've not bothered to post all the details of 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 18, 2008 at 5:30 am

#899818
RE: Help writing function to get decimal from string

Dooza (11/18/2008)
... and was setup like this by the developers.
Heh... of that, I have no doubt. Thanks for the feedback, Steve. 🙂
--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 18, 2008 at 5:27 am

#899817

Viewing 15 posts - 47,161 through 47,175 (of 59,102 total)