Viewing 15 posts - 151 through 165 (of 5,678 total)
Cost.
Raid 0 doesn't protect your data from a drive failure. Raid 1 requires you to have two disks for a single disk of space (or 4 for 2, etc,...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
August 7, 2014 at 6:03 pm
rodrigo_fabiam (8/7/2014)
There is not this colums.
It is because this that I want to show this way for the user.
Because they will have to mark what site is...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
August 7, 2014 at 5:02 pm
A note on HA/DR solutions, and one that's not always considered, so bear with me. Yes, I'm playing Devil's Advocate.
The most likely need for HA/DR is power outage and/or...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
August 7, 2014 at 4:56 pm
Try the following, then just join normally:
DECLARE @xmlInsertRecordString XML
DECLARE @iDoc INT
SET @xmlInsertRecordString = '<AllForcast>
<SESA>SESA99999</SESA>
<EmployeeName>Alex Bea</EmployeeName>
<HiringStatus>Full Time</HiringStatus>
<EmployeeGroup>HW</EmployeeGroup>
<EmployeeSub-Group>HW</EmployeeSub-Group>
<City>Burnaby</City>
<ProjectStatus>Active</ProjectStatus>
<ProjectName>AB-1</ProjectName>
<ProjectCode>411</ProjectCode>
<ProjectManager>John Doe</ProjectManager>
<Notes></Notes>
<Date>Jan 1 2016</Date>
<Effort>1</Effort>
<RecordBy>SESA123456</RecordBy>
<RecordID>4</RecordID>
</AllForcast>'
EXEC sp_xml_preparedocument @iDoc OUTPUT, @xmlInsertRecordString
SELECT
*
FROM
OPENXML( @iDoc, '//AllForcast')
WITH (EmpSubGroup VARCHAR( 50) 'EmployeeSub-Group',
SESA VARCHAR(50)...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
August 7, 2014 at 4:43 pm
Can you provide a sample schema and data (just the basics, don't need to go nuts) that show how your data is organized, by what keys, and if you're update...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
August 7, 2014 at 4:24 pm
Wow, I don't even go near that until I have some conceptual concepts of the model.
IE: Archiving usually only happens on a few tables. Security may or...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
August 7, 2014 at 4:22 pm
I'm not sure I'm clear on your objective. Are you simply trying to get your three columns into a single select into the same table, or have I horribly...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
August 7, 2014 at 4:17 pm
Excellent Setup for clarity, Rodrigo. A question. I assume this is a simplified version of the real data. Is there a column that indicates which kit each...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
August 7, 2014 at 4:14 pm
After your SET NOCOUNT ON;, include:
SET FMTONLY OFF;
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
August 7, 2014 at 2:22 pm
What mechanisms do you have to determine which is the most recent file for overlaps? Is the report/pull date in the text file, do you need to extract it...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
August 7, 2014 at 1:16 pm
GilaMonster (8/7/2014)
Ed Wagner (8/7/2014)
Put them in the same boat as WC.
Speaking of... If you tried running a query against a table (a simple select) and if never returned, what would...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
August 7, 2014 at 1:09 pm
I think I'm having an ESL problem. Can someone stick their head into this thread and see if I'm just not asking the right question or if they can...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
August 7, 2014 at 1:04 pm
2sbhagat (8/7/2014)
might have to add extra column when loading data to staging table
Probably more than one, but you're not answering the question in the manner I'm hoping to find out....
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
August 7, 2014 at 1:01 pm
If data overlaps between two files, how do you determine who 'wins'? I realize that it's possible there shouldn't be discrepencies, but humor me. What's your merge conflict...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
August 7, 2014 at 12:51 pm
More information is needed. Are these files the exact same layout/format? How do you determine who 'wins' when data overlaps? Are you allowed to create/affect schema and...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
August 7, 2014 at 12:11 pm
Viewing 15 posts - 151 through 165 (of 5,678 total)