Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,196 through 21,210 (of 59,098 total)

RE: job failed for time out of connection

I guess I don't understand. Why would you think you wouldn't have a problem if the Web Service was running when you rebooted SQL Server? Disable the Web...
--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 23, 2015 at 11:01 pm

#1785874
RE: Will there be any problem in migrating data from evaluation edition DB ?

Joy Smith San (3/23/2015)
Thanks Jeff.
I thought its 180 days. Well, it will be a separate temporary server.
So I just need to backup and restore all user DBs to 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)

March 23, 2015 at 10:58 pm

#1785873
RE: Error running Stored procedure from SSIS runs fine in SSMS

RantaSanta (3/23/2015)
/*Populate the table from fleets table which are enabled and not in system*/
INSERT INTO @databases
SELECT
number,
status
FROM
XYZ.dbo.abcTable
WHERE
Status = 'N'
AND [font="Arial Black"]number [/font]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)

March 23, 2015 at 10:52 pm

#1785872
RE: Partition for a particular value and not

Anamika (3/23/2015)
hi,
How can I make partitions on a table for a particular value and ranges together?
For example, for customer id 12345 i need a separate partition, then for 56789 i...
--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 23, 2015 at 10:47 pm

#1785871
RE: Hierarchies on Steroids #2: A Replacement for Nested Sets Calculations

Since you seem hell bent on stealing it for profit, I'll make you a deal. 😉
Since these articles are copyrighted, it would seem that a partial co-author cut 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)

March 23, 2015 at 9:49 pm

#1785866
RE: What would Fill Factor Do?

Almost forgot. You can also "pad" the BTREE with the same fill factor. Again, that would be a judgment call and should not necessarily be a blanket policy.
--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 23, 2015 at 9:15 pm

#1785863
RE: What would Fill Factor Do?

Just to add some information to this thread.
REORGANIZE
1. Is not always faster. If an index is heavily fragmented, it can be quite a bit slower.
2. Reorganize is...
--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 23, 2015 at 9:12 pm

#1785862
RE: Design Question to minimize blocking

tim_harkin (3/23/2015)
I am trying to come up with some tuning recommendations for a design pattern I have seen in several places that is causing blocking. I have a 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)

March 23, 2015 at 7:07 pm

#1785855
RE: Vendor Changed the Flat File Format

I strongly agree with Elliott's take on pork-chopping the vendor for making unagreed upon changes but there's a way around this. If the files have no PII or proprietary...
--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 23, 2015 at 6:34 pm

#1785853
RE: Hierarchies on Steroids #2: A Replacement for Nested Sets Calculations

CELKO (3/23/2015)
I cover some to this stuff in my TREES IN SQL book. Which will have this thread's material when they ask me to update it. Hey. Imitation is 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)

March 23, 2015 at 6:28 pm

#1785852
RE: Vendor Changed the Flat File Format

Vertigo44 (3/23/2015)
Sorry Phil. No.
I found a possible solution to dynamic flat file columns using...
http://ssisdfs.codeplex.com/
and a script task component. I am going to try to implement it and see if 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)

March 23, 2015 at 4:00 pm

#1785829
RE: convert from access to sql server please help

draganl2000 (3/23/2015)
HI
Thanks for reply that is code I delete order by give me error in access . In attachment is result . please help
TRANSFORM First(Eval1to4.answer) 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)

March 23, 2015 at 3:49 pm

#1785828
RE: bulk insert

Srl832 (3/23/2015)
I want to bulk insert data into a table named scd_event_tab inside a database named rdb.
when I do select * from rdb.dbo.scd_event_tab, i get :
JOB_ID RUN_ONPRIORITYPAYLOADTIMEOUT_INTERVALSTATUSPICKUP_TIMESCD_TYPESCHEDULE_IDDB_ADMIN_LOGIN_REQUIRED_YN
I saved 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)

March 23, 2015 at 3:32 pm

#1785826
RE: Call Stored Procedure from a Function

Heh... I guess that if enough people say it should "never" be done and that it's a "bad practice" without a detailed explanation as to why, we can actually write...
--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 23, 2015 at 11:38 am

#1785783
RE: Are the posted questions getting worse?

venoym (3/23/2015)
I don't normally weigh in on the gender imbalance conversations. However, I think that there is more to it than any of us has, or can, present. ...
--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 23, 2015 at 10:00 am

#1785749

Viewing 15 posts - 21,196 through 21,210 (of 59,098 total)