Jeff Moden

Forum Replies Created

Viewing 15 posts - 57,826 through 57,840 (of 59,067 total)

RE: SQL 2000 only addressing 8 GB of avail 16 GB memory...why?

Don't ya just love Microsoft? Fixes for their fixes!! Thanks for the tip, Daniel and welcome to SQLServerCentral.com.
--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)

August 16, 2006 at 8:12 pm

#655366
RE: Monthly Metric Report

My DBA is the one who set it up so I'm not sure... but I'll find out...
--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)

August 16, 2006 at 8:01 pm

#655365
RE: Convert Varchar to datetime

Yep... you can do that... like you said though, the automagic century-cutoff should do the trick but even that can be wrong if these dates are DOB's.
The slashes were an...
--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)

August 16, 2006 at 6:46 am

#655238
RE: Pivot Report

Oh yeah... almost forgot... if you want to see the code the script above generates, just change the "EXEC" to a "PRINT".
--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)

August 15, 2006 at 11:11 pm

#655195
RE: Pivot Report

Great code one and all. I've got a slightly different idea and it's pretty flexible for making other reports, as well. It also includes columnar and row totals as well...
--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)

August 15, 2006 at 11:02 pm

#655194
RE: Convert Varchar to datetime

Nicely done... I'm just a bit squemish about relying on what the default datetime formats have been set to... also, if you replace @String with a column name in 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)

August 15, 2006 at 8:14 pm

#655191
RE: ''''SMITH'''' does NOT equal ''''SMITH ''''

Why do you have trailing spaces and what is it that you're trying to do? Are you trying to find entries that have trailing spaces to eliminate the trailing spaces...
--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)

August 15, 2006 at 7:57 pm

#655189
RE: Update statement referencing another database from same server

Obviously, I've not tested this... but it should work...
UPDATE u1
    SET InstantASP_UserID = u2.UserID
   FROM MyDB1.dbo.Users u1,
        MyDB2.dbo.InstantASP_Users u2,
        dbo.aspnet_Membership a
WHERE a.UserId = u1.UserID
    AND u2.EmailAddress...
--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)

August 15, 2006 at 7:26 pm

#655187
RE: Combine two columns into one?

Having been in the telecommunications world for about 11 years, lemme just say...
DON'T COMBINE THE NPA AND NXX COLUMNS!!!!!!!! You will hate yourself so bad in the future for 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)

August 15, 2006 at 7:20 pm

#655186
RE: Checking if a Table Exists

Stop looking at tables for this... use the built in functions...
IF OBJECT_ID('databasename.ownername.objectname') IS NOT NULL
DROP objecttype ownername.objectname
--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)

August 15, 2006 at 7:15 pm

#655185
RE: SQL 2000 only addressing 8 GB of avail 16 GB memory...why?

Are you using the ENTERPRISE edition of SQL Server? If not, you must be using the STANDARD edition and that would be the reason why...
--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)

August 15, 2006 at 7:11 pm

#655184
RE: Monthly Metric Report

Deadlocks ARE "critical errors"!!!
Deadlocks are lost data (an excessive waits) and are a key measure to the health of an SQL based system. Perhaps most companies have executives that are simply...
--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)

August 15, 2006 at 7:51 am

#655059
RE: Can I do this using a ''''self-join''''? Please Help.

You bet, John... thank you kindly 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)

August 15, 2006 at 7:36 am

#655050
RE: Id of the last inserted

Bill,
I'm well aware of NextID tables (sequence tables) and the methods to use them without causing a bottle-neck without any chance of a deadlock or extended wait even during 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)

August 15, 2006 at 7:35 am

#655048
RE: Exporting to oracle

Oracle is case sensitive for table and column names and must be upper case during this type of transfer. Put the quotes back in and modify the things in quotes...
--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)

August 14, 2006 at 9:39 pm

#654995

Viewing 15 posts - 57,826 through 57,840 (of 59,067 total)