Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,816 through 37,830 (of 59,072 total)

RE: Error! Msg 103, Level 15, State 4, Line 1

Anamika (7/1/2010)
Many Thanks,
Ami
Um... no... not yet. Take a look at the data you have. See all those "\N" thingies??? That's not supposed to be a part of 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)

July 1, 2010 at 6:35 pm

#1187976
RE: SSIS - Writing Exceptions to Flat File

I'm pretty sure that it can't actually be done. I believe you're stuck with just deleting the empty file. As a side bar, though, I wouldn't delete 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)

July 1, 2010 at 6:26 pm

#1187974
RE: what are the roles and resposibilties on sql dba

And one more link... I consider it to be the best link on the subject yet and it also teaches an essential skill that all aspiring DBA's must absolutely master...
--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)

July 1, 2010 at 6:19 pm

#1187972
RE: How to handle Tempdb.dbo.##XXXXXXX

zeeaay (7/1/2010)
Under my Systems Databases>tempdb>temporary tables; I have there table with dbo. ##XXXXXX. when I run an application I get the following error
Microsoft SQL Server Cannot insert the value NULL...
--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)

July 1, 2010 at 6:16 pm

#1187971
RE: Flexible ETL package

priya__ (7/1/2010)
Hi all,
I have a package to be designed in a flexible way, actually I have a source in which I have some column which I have to eliminate in...
--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)

July 1, 2010 at 6:11 pm

#1187970
RE: DROPPIN PRIMARY TABLE..

Ram:) (7/1/2010)
Any body to give comments on this..
as i don't know it is the right platform to post this problem or is my problem idiotic
Only 24 minutes went by......
--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)

July 1, 2010 at 6:02 pm

#1187969
RE: Sql dynamic query

bladerunner148 (7/1/2010)
Hi there,
I have to produce the following result set.
Gender Count Percentage
Male ...
--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)

July 1, 2010 at 5:55 pm

#1187967
RE: There Must Be 15 Ways To Lose Your Cursors… Part 2: Just Put It in a S

Mike C (7/1/2010)
Jeff Moden (7/1/2010)
Mike C (7/1/2010)
Good catch on the week # UMG. As you mentioned, I did assume 2005 or 2008, but only because 2000 is out of...
--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)

July 1, 2010 at 4:50 pm

#1187959
RE: deadlock by 2 triggers on same table

KBSK (7/1/2010)
Jeff Moden (7/1/2010)
GilaMonster (6/30/2010)
Jeff Moden (6/30/2010)
... but don't mind giving a little advice on what to change. 😉
The entire thing? 😉
Heh... z'actly. 😛
Hi All,
thanks for your valuable suggestions.
i know...
--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)

July 1, 2010 at 4:42 pm

#1187955
RE: converting rows to columns

priya__ (7/1/2010)
any help on this:
http://www.sqlservercentral.com/Forums/Topic946357-148-1.aspx
I'd say "Not on this thread". Keep your stuff together, please... especially since you already have an answer on the other thread.
--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)

July 1, 2010 at 2:42 pm

#1187915
RE: Creating Clustered index on a large table

anish_ns (7/1/2010)
I could make a partition based on Fiscal Year and I think that would help the performance a lot. Can you please point me in the right direction 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)

July 1, 2010 at 2:38 pm

#1187911
RE: 2008r2 License Costs

hemakumar_p (6/29/2010)
Hi,
SQL Expression edition is cool tool and comes with free of cost.
Express edition don't have Agent to schedule the jobs and reporting services But we can do a custom...
--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)

July 1, 2010 at 2:33 pm

#1187907
RE: There Must Be 15 Ways To Lose Your Cursors… Part 2: Just Put It in a S

Mike C (7/1/2010)
Good catch on the week # UMG. As you mentioned, I did assume 2005 or 2008, but only because 2000 is out of support :). If using...
--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)

July 1, 2010 at 6:56 am

#1187636
RE: Excluding rows from table

Ah... dang it... gotta read down before posting. I see the 101 thing has been resolved.
--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)

July 1, 2010 at 6:49 am

#1187632
RE: Excluding rows from table

anitha.cherukuri (6/30/2010)
Hi Jeff
The Reason is If reading type is final that meter will be historic one.
Thats why i dont want to see 101.
Your test data has a "Final" 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)

July 1, 2010 at 6:47 am

#1187630

Viewing 15 posts - 37,816 through 37,830 (of 59,072 total)