Forum Replies Created
Viewing 15 posts - 21,166 through 21,180 (of 59,072 total)
-
RE: Forum Etiquette: How to post data/code on a forum to get the best help
dallas13 (3/24/2015)
Hi... How do I attach a screenshot in my question? When I clicked on image--->but how do I insert there? I dont want to make attachment.
At 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) -
RE: bulk insert
Srl832 (3/23/2015)
I have been asked by the management to provide a script for importing customer related data contained in a CSV file to a production db table next week...--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) -
RE: What would Fill Factor Do?
Ah... I should have known that such would be the case. And if you touch it, you void the support.
I agree with you that a 10% fill factor 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) -
RE: What would Fill Factor Do?
PHYData DBA (3/24/2015)
In response to you're suggestion above. This database supports a patient data medical application, EMR to be specific, and using staging tables is not an option.Shouldn't matter. ...
--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) -
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) -
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) -
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) -
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) -
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) -
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) -
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) -
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) -
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) -
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) -
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...
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)
Viewing 15 posts - 21,166 through 21,180 (of 59,072 total)