Jeff Moden

Forum Replies Created

Viewing 15 posts - 47,191 through 47,205 (of 59,095 total)

RE: Using UNION ALL with ORDER BY NEWID()

De nada!
--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 16, 2008 at 5:27 pm

#899121
RE: Using SSIS to import a non fixed length CSV file

Alex koranteng (11/15/2008)
Is it possible to import non fixed length CSV file into SQL server 2005 table. I have reading forums and have seen inconsistent reviews. I am a...
--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 16, 2008 at 5:02 pm

#899115
RE: Faking Multidimensional Arrays in T-SQL made easy!

zpq4 (11/16/2008)
So I’m sure I’m missing something. Anyone care to enlighten me?
Heh... not unless you've ever had to pass an array from a GUI to the database....
--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 16, 2008 at 4:57 pm

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

I agree on both counts... storing numerics as varchar just doesn't sit well with me either. Neither does storing a large negative number as a default. You could...
--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 16, 2008 at 10:11 am

#899085
RE: why sql jobs are still running even if I disabled the jobs

If you have DTS or SSIS packages, they may be calling some of those jobs and they'll run when called whether they're disabled or not.
--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 16, 2008 at 9:24 am

#899081
RE: Best of SQL Server Central

Cool... thanks, 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 16, 2008 at 9:20 am

#899079
RE: BYOC

Maybe I'm an old stick in the mud, but to me, it does matter.
For example, a lot of folks just flat refuse to work over 40 hours... can't...
--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 16, 2008 at 9:18 am

#899077
RE: Reading File attributes (datecreated,datemodified....) using sp_OACreate....

Ahmad Osama (11/16/2008)
I ran this command on my machine and setup.txt file do exist........
You need to read the rest of my previous post... SQL Server CANNOT see your drive as...
--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 16, 2008 at 8:11 am

#899069
RE: Invalid Object Name error

Stupid question, but have you checked to make sure the object still exists? Someone may have dropped it or maybe a DBA renamed it to see who squawks 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)

November 15, 2008 at 9:03 pm

#899044
RE: Custom Password Policy Stored Procedure Needed

Ah..., sorry Brian. I was, in fact, missing your point. Now I understand what you meant and why. 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 15, 2008 at 8:59 pm

#899043
RE: Best of SQL Server Central

Just curious... do authors still get free copies? And, what was the cutoff for V6?
--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 15, 2008 at 8:39 pm

#899041
RE: DBCC

I got it right but this is a really bad question for people who are still stuck with SQL Server 2000. These types of questions should probably identify 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 15, 2008 at 8:31 pm

#899040
RE: BYOC

Yet, the same company will break your horns for sending private emails from work or using the company telephone to make personal calls to an old flame in Australia.
Nah... mixing...
--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 15, 2008 at 8:25 pm

#899039
RE: Ethics in IT - Database Weekly (Nov 17, 2008)

Good editorial, Steve. I noticed the following statement...
"On one hand I can understand that ethics and morals are becoming more important."
Heh... when were they ever not the most important...
--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 15, 2008 at 8:18 pm

#899038
RE: Reading File attributes (datecreated,datemodified....) using sp_OACreate....

I just ran the following on my server... only thing I changed was the file name to match a file I had.
DECLARE @hr int,@object int,@objfile int,@datecreated int,
@path varchar(200),@filename varchar(100)
set @filename='c:\Sample.txt'
EXEC...
--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 15, 2008 at 7:59 pm

#899037

Viewing 15 posts - 47,191 through 47,205 (of 59,095 total)