Jeff Moden

Forum Replies Created

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

RE: Select Average By DATEPART Weekday

I just got done fixing a bunch of errors (most missing parens on table creations) in the data scripts. And, because the post is so long (I recommend attaching...
--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)

May 30, 2010 at 8:32 pm

#1174375
RE: DBA, phantom job title?

Paul White NZ (5/29/2010)
On the flip side of this particular coin, what is worse: DBA by committee or a single DBA that posts the sort of questions we see on...
--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)

May 30, 2010 at 3:34 pm

#1174363
RE: ADD column storeID while bulk inserting

Matt Miller (#4) (5/30/2010)
CirquedeSQLeil (5/30/2010)
Why is SSIS not an option? Your databases do not need to be SQL 2005 to be able to use SSIS on them.
Even if SSIS...
--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)

May 30, 2010 at 3:27 pm

#1174362
RE: How to find the size of each Stored procedure located in a Database and Total size of Stored Procedures in a database.

Sourav-657741 (5/30/2010)
I've already taken 'Script out' of all the SPs thru 'Generate Script' and taken the list thru 'Export List'.
So you're all set then, right?
--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)

May 30, 2010 at 3:25 pm

#1174361
RE: Memorial Day 2010

WayneS (5/29/2010)
To anyone that has ever served in any branch of the military, I say:
Thank you for your sacrifice and service!
I also thank your family for their sacrifice.
As one who...
--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)

May 30, 2010 at 12:44 pm

#1174356
RE: change to 12 hour time format

man9500 (5/30/2010)
using this: http://www.tek-tips.com/faqs.cfm?fid=4191
executing this sql on that procedure select dbo.fn_formatdatetime (getdate() ,'h:nnAM/PM');
always returns the 24 hour time format , I want it to return the 12 hour time format.
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)

May 30, 2010 at 12:36 pm

#1174355
RE: How to find the size of each Stored procedure located in a Database and Total size of Stored Procedures in a database.

Sourav-657741 (5/30/2010)
You're absolutely correct. I too believe the same. Will pass across the comments to Dev.
Gosh... why can't you just script the procs out to individual files and then do...
--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)

May 30, 2010 at 12:28 pm

#1174352
RE: Select Average By DATEPART Weekday

spike62 (5/30/2010)
Sorry Jeff!:-)
I guess I was impatient and looking for a quick push in the right direction. I've gotten most of the code together, but have to go to work...
--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)

May 30, 2010 at 12:21 pm

#1174350
RE: Are the posted questions getting worse?

GilaMonster (5/30/2010)
Ok, I give up. What's a clustering agent?
http://www.sqlservercentral.com/Forums/Topic930164-146-1.aspx
Who's got the crystal ball?
Heh... I wish posters like that would learn the quintessential skill of how to use Google.
It would appear...
--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)

May 30, 2010 at 11:42 am

#1174348
RE: Are the posted questions getting worse?

GilaMonster (5/30/2010)
This one's not much better...
http://www.sqlservercentral.com/Forums/Topic929458-357-1.aspx
If you have a 2 TB database and don't know how to plan backup and restore strategies, there's a bigger problem there.
Heh... the bigger problem...
--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)

May 30, 2010 at 11:04 am

#1174344
RE: Are the posted questions getting worse?

Paul White NZ (5/29/2010)
Jeff Moden (5/29/2010)
I wonder what the interview process was and how full of hooie the resume was that allowed someone to have a job that required someone...
--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)

May 30, 2010 at 10:58 am

#1174342
RE: ADD column storeID while bulk inserting

As requested, here's a very simple SQL Server 2000 solution and it will load "hundreds of files" provided that they are, in fact, all named the same except for StoreID...
--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)

May 30, 2010 at 10:18 am

#1174336
RE: ADD column storeID while bulk inserting

daniarchitect (5/30/2010)
Unfortunatley our company uses DB2 as main database ,
but they have sql server on side which is version 2000.
I ask apology for posting it here,but that was the only...
--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)

May 30, 2010 at 9:21 am

#1174333
RE: ADD column storeID while bulk inserting

Paul White NZ (5/29/2010)
Use an XML format file and OPENROWSET BULK. This allows you to modify the bulk load stream without losing any of the benefits of bulk loading...
--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)

May 29, 2010 at 10:50 pm

#1174289
RE: Are the posted questions getting worse?

I wonder what the interview process was and how full of hooie the resume was that allowed someone to have a job that required someone to do the following simple...
--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)

May 29, 2010 at 10:28 pm

#1174288

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