Jeff Moden

Forum Replies Created

Viewing 15 posts - 33,706 through 33,720 (of 59,099 total)

RE: A Saturday QOTD - If you get it right and live in Nashville, TN a few Happy Hour Brews are on ME!

The Dixie Flatline (6/12/2011)
I suspect the TRY...CATCH doesn't work the way you expect because the TRY is actually succeeding.
Procedure dbo.sp_start_job runs twice, successfully sending start job requests...
--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)

June 12, 2011 at 9:57 pm

#1337559
RE: Need to filter by date range...

allmhuran (6/12/2011)
Jeff Moden (6/12/2011)
As a bit of a side-bar, find a good "indented" standard for formatting your code.
I use someone's formatting as the first and fastest indicator of how mature...
--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)

June 12, 2011 at 1:34 pm

#1337510
RE: A Saturday QOTD - If you get it right and live in Nashville, TN a few Happy Hour Brews are on ME!

MyDoggieJessie (6/12/2011)
Appreciate the input guys (sincerely) and it's immensely VALUED but this still doesn't resolve the error at hand:
Msg 22022, Level 16, State 1, Line 0
SQLServerAgent Error: Request to run...
--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)

June 12, 2011 at 1:22 pm

#1337506
RE: Using SELECT INTO a bad practice?

allmhuran (6/12/2011)
SQL seems to have trouble with constructs like...
with c1 as (...),
c2 as (select ... from c1 ...),
c3 as (select ... from c2 ...)
... etc. Fair enough too, I'd say.
That's...
--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)

June 12, 2011 at 1:11 pm

#1337504
RE: Difference between.

shiv-356842 (6/11/2011)
Hi Team,
Thank you for your suggestion
Next time i could not do this type of mistakes
Really i dont know that the reason only i have posted because 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)

June 12, 2011 at 1:04 pm

#1337503
RE: Using SELECT INTO a bad practice?

allmhuran (6/12/2011)
It's bad if it's unnecessary for performance.
A lot of the time when I see select into temp tables I also see cursors processing those temp tables. In other...
--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)

June 12, 2011 at 12:21 pm

#1337500
RE: Need to filter by date range...

The Dixie Flatline (6/11/2011)
That guy's about as useless as a varchar(1). -- Original
I like that quote. Here's another one that I frequently use on managers that promise things 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)

June 12, 2011 at 11:53 am

#1337495
RE: A Saturday QOTD - If you get it right and live in Nashville, TN a few Happy Hour Brews are on ME!

mister.magoo (6/11/2011)
BEGIN TRY
IF EXISTS(
select 1 FROM msdb.dbo.sysjobs_view sjv
join msdb.dbo.sysjobactivity sja
on sja.job_id = sjv.job_id
JOIN msdb.dbo.sysjobhistory sjh ON sja.job_history_id = sjh.instance_id
where name='test')
...
--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)

June 12, 2011 at 9:30 am

#1337467
RE: Need to filter by date range...

First of all, [font="Arial Black"]NEVER EVER DO A BETWEEN ON DATES![/font] Heh... yeah... I'm yelling here. 😀 The reason why to never do a BETWEEN on dates is 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)

June 12, 2011 at 9:00 am

#1337465
RE: Select From Table Before Transaction Begin

Steve Jones - SSC Editor (6/11/2011)
but i need to build [font="Arial Black"]one [/font]Stored procedure to handle any changes on data whatever was the table
Ah... no. That would require some...
--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)

June 12, 2011 at 8:22 am

#1337461
RE: Inserting identity value into more than one column

I took a look at your website, Dave. It's nice and simple yet informative.
My only suggestion comes from when I first opened the site which was, "Where's the Title...
--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)

June 12, 2011 at 8:14 am

#1337459
RE: Expanding functions within a script

chas.clarke (6/10/2011)
Can someone possibly help me?
I want expand 2 functions within my script so that I don't have to call any functions (or stored procedures).
The line within my...
--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)

June 12, 2011 at 7:50 am

#1337457
RE: Store Huge Files in database

ashkan siroos (6/11/2011)
Yes, I want sql to index my file content, because I want to do a content search on that...
Lookup FULL TEXT SEARCH and the files need to be...
--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)

June 11, 2011 at 5:26 pm

#1337427
RE: Slow performance after Migration from Access to SQL back-end

naphan.710 (6/7/2011)
thanks
Spam reported.
--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)

June 11, 2011 at 5:22 pm

#1337426
RE: Log File Space during Updates of a Table

Grizzly Bear (6/11/2011)
It is a simple UPDATE statement.
UPDATE <tablename> SET <columnName> = 1 WHERE <datefield> < 'TodaysDate'
And no the <ColumnName> is not part of any Index.
I can't help if you're...
--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)

June 11, 2011 at 4:48 pm

#1337423

Viewing 15 posts - 33,706 through 33,720 (of 59,099 total)