Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,991 through 43,005 (of 59,098 total)

RE: Earch Table Size

Heh... I know where this one came from because it avoids RBAR 😉
--===== "Space Used on Steroids"
-- If "UnusedKB" is negative, it's likely you need...
--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)

July 17, 2009 at 10:29 am

#1026310
RE: Use sp_MSforeachtable to gen COUNT(*) for each table in MyDBname

The following takes about the same time as the sp_MSForEachTable and has the distinct advantage of returning the row counts as a sortable single result set instead of a result...
--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)

July 17, 2009 at 9:24 am

#1026254
RE: Advice for the Unemployed

Doc (7/16/2009)
One little thing I would add to this list -- get your own blog or a web site and write, let the Employers see that you are interested into...
--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)

July 17, 2009 at 5:23 am

#1026093
RE: SQL While Loop

Roger Abram (7/16/2009)
It worked out just fine and I really want to thank you for your help!
Rog
That's cool, but there're two ways to do things... the way that works 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)

July 17, 2009 at 5:02 am

#1026085
RE: deleting dupliacte records from one table

desktopteam (7/16/2009)
I agreee didn't want to mess with any of the standard tables they may have. It's something that has been appering over time, with over 15000 computers in our...
--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)

July 17, 2009 at 4:51 am

#1026082
RE: deleting dupliacte records from one table

desktopteam (7/16/2009)
Hi,
I am pretty new to sql in terms of updating or deleting databases. we currently use Symatnec antivirus and are noticing an increase in dupliacte computer names but they...
--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)

July 16, 2009 at 11:40 am

#1025813
RE: Date functions causing queries to take longer

Heh... nah... you and I both know... "It Depends". Test everything... leave little to chance.
--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)

July 16, 2009 at 11:26 am

#1025807
RE: Naming Conventions Standards

deewiley (7/16/2009)
When I saw this question I had to add some information on how we do this in our shop. We do not generayy use prefixes for tables or views...
--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)

July 16, 2009 at 10:43 am

#1025787
RE: Date functions causing queries to take longer

Grant Fritchey (7/16/2009)
TheSQLGuru (7/16/2009)
I think we will have to disagree on this one. I estimate that 90+% of the time a user has a query with a date range...
--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)

July 16, 2009 at 10:14 am

#1025770
RE: Is This The Best Way to Remove Duplicate Records ?

Heh... the devil's in the data. Thanks for the feedback. 🙂
--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)

July 16, 2009 at 10:01 am

#1025758
RE: Is This The Best Way to Remove Duplicate Records ?

ifila (7/16/2009)
I found the issue. It was NOT the delete SQL code !
Thanks
Two way street here... what was the problem you found and how did you fix 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)

July 16, 2009 at 8:22 am

#1025687
RE: Date functions causing queries to take longer

Could it be that the problem is being caused by non-deterministic functions?
--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)

July 16, 2009 at 8:18 am

#1025682
RE: Is This The Best Way to Remove Duplicate Records ?

Heh... good luck... that doesn't help much on our end.
--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)

July 16, 2009 at 7:40 am

#1025640
RE: Help us tune a query

Jeff Moden (7/16/2009)
One other thing you might want to take a gander at.... the wrong type of quotes have been used on the IFCode Shortcuts that have them. 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)

July 16, 2009 at 7:27 am

#1025624
RE: Help us tune a query

One other thing you might want to take a gander at.... the wrong type of quotes have been used on the IFCode Shortcuts that have them. For example, ”sql”...
--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)

July 16, 2009 at 7:24 am

#1025620

Viewing 15 posts - 42,991 through 43,005 (of 59,098 total)