Jeff Moden

Forum Replies Created

Viewing 15 posts - 51,931 through 51,945 (of 59,102 total)

RE: how to choose composite index

Not normally... of course, there are always exceptions.
--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 10, 2008 at 11:54 pm

#787788
RE: Getting Started - What to Learn / Tools Advice

Most results will be taking a present value from a previous value grouped by a name and show the result eg.
Smith 1/1/2008 ...
--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 10, 2008 at 10:26 pm

#787769
RE: Change Control System Design

Yes... look for "Configuration Management".
--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 10, 2008 at 10:11 pm

#787764
RE: getting into Data Warehousing

Create a datawarehouse environment on your development server? Buy a copy of SQL Server Developer's Edition and install on you home PC? Take a course?
--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 10, 2008 at 10:08 pm

#787763
RE: Im having troubles with code for project Leap Years-help please

The definition of leap years changed many times and leap years didn't always exist. In fact, depending on which country you're talking about, leap year definitions were different 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)

March 10, 2008 at 10:00 pm

#787761
RE: Using VBScript to Automate Tasks

Heh.... Just like SQL allows itself to take any form... or Java... or...
--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 10, 2008 at 9:53 pm

#787756
RE: Turn off logging

Yes... there are... just setting recovery model to SIMPLE doesn't stop logging for loading of data. You have to use BCP or BULK INSERT or SELECT/INTO and your target...
--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 10, 2008 at 9:43 pm

#787755
RE: Help with Year calculations

Agreed... guess I need to wipe some of the egg off my face. DOB columns would be an appropriate place to use DATE only (although I don't know if...
--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 10, 2008 at 9:35 pm

#787750
RE: Cursor in SQl Server

Lynn Pettis (3/10/2008)
And it wasn't that I gave up too early; we had a workable solution, and there were many other things I needed to work on that were considered...
--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 10, 2008 at 9:23 pm

#787746
RE: Can a temporary table created with an execute statement survive that statement?

Giving away a fine "secret" here, but no one's ever heard of temporary stored procedures? Build it using dynamic SQL... execute it... it's all in the same scope that...
--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 10, 2008 at 8:42 pm

#787726
RE: Help with Year calculations

Jack Corbett (3/10/2008)
I like to use between when doing date ranges, I just think it is easier to read. I would use DateAdd(SS, -1, DateAdd(YY, 1, Convert(datetime, @year))) 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 10, 2008 at 8:35 pm

#787723
RE: Creating assembly

Would be a heck of a lot faster if you used a holiday table or, better yet, a calendar 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)

March 10, 2008 at 8:12 pm

#787719
RE: Performance issue for a query with order by clause in SQL 2005 SP2

Bob Fazio (3/7/2008)
using the following;
;WITH table1(col1) AS (
SELECT objects.[object_id] FROM sys.objects
)
SELECT DISTINCT TOP(2000) Table1.col1,Table2.col1,Table3.col1
FROM table1,table1 TABLE2,table1 table3
ORDER BY table3.col1
-- option(force order)
The above comes back...
--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 10, 2008 at 8:09 pm

#787718
RE: Bad Meetings

It's also unfortunately due to the fact that it's substantially easier to get "certified" as a Microsoft DBA than it is in Oracle. You therefore have a lot larger...
--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 10, 2008 at 7:39 pm

#787706
RE: The Daily Routine

I had a dog like Matt's... the only way to get her to take meds was with a small enough piece of steak for her to swallow in one gulp......
--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 10, 2008 at 7:14 pm

#787698

Viewing 15 posts - 51,931 through 51,945 (of 59,102 total)