Viewing 15 posts - 4,996 through 5,010 (of 5,678 total)
I assume the table has a timestamp of some kind on it?
If so, create a SQL Agent job with a T-SQL statement in it that DELETE FROM table WHERE timestampCol...
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
November 10, 2010 at 3:15 pm
You're going to have a tough time with doing this *and* keeping it optimized. Pretty much a one or the other scenario.
The other difficulty you'll have in this 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
November 10, 2010 at 3:13 pm
Tara-1044200 (11/10/2010)
CraigIts not the link server connection, I am trying to connect to 2008 database engine from the sql 2005 interface.
Check this post out:
You need to use SSMS SP2 CU5...
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
November 10, 2010 at 3:04 pm
I agree with Celko on this one. You haven't provided us enough of the business rules to know how you do your rollups on I into S and rowId...
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
November 10, 2010 at 3:01 pm
CELKO (11/10/2010)
For example, there is no such thing as a "category_id" -- an attribute can a "<something>_category" or a "<something>_id" , but not that nonsense.
Sure there is, watch:
CREATE...
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
November 10, 2010 at 2:33 pm
krypto69 (11/10/2010)
Thanks Craig!
No problem, my pleasure. 🙂
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
November 10, 2010 at 2:28 pm
The GOs are just there to build the CREATE PROCs.
The key is that Proc2 calls Proc1, which like any proc could be fed parameters and the like.
You'll have to be...
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
November 10, 2010 at 2:12 pm
Silly question, but what are you trying to connect the '05 to the '08 with?
Linked server? SSMS '05 looking at '08 registered servers? SSIS?
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
November 10, 2010 at 2:04 pm
Um, you mean something like:
CREATE PROC Proc1 AS
SELECT 'Proc1' AS Procname
GO
CREATE PROC Proc2 AS
SELECT 'Proc2' AS ProcName
EXEC Proc1
GO
EXEC Proc2
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
November 10, 2010 at 2:02 pm
I agree with you it's possible, but the 4.xml statement was the one that got me. He's overloading the load with multiple types, which is gonna go ugly. 🙂
The...
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
November 10, 2010 at 2:00 pm
I broke this into ctes to make the logic more obvious. I also added a few entries into H111 to allow for multiple minutes over 60 to force a...
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
November 10, 2010 at 1:25 pm
I think you're looking for this (Please note how I adjusted your build to create the full test script):
DECLARE @MyTable TABLE ( FirstCol VARCHAR(50), SecondCol INT)
INSERT INTO @MyTable (FirstCol, SecondCol)
VALUES...
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
November 10, 2010 at 1:14 pm
Personally I'd use a method I typically take with HIPAA data and swap everything identifying a company/person into a GUID, and populate that GUID out to everywhere that references. ...
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
November 10, 2010 at 1:09 pm
jcrawf02 (11/10/2010)
aaaaand, Wayne does NOT get the "position"......
Well, that all depends on what "position" Wayne was aiming for. If he was combining the two concepts at once, he might...
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
November 10, 2010 at 1:05 pm
Two approaches.
Entirely within SSIS: Use multiple sources, one your flat file(s), the other the target table in the database. Bring them both through a Merge Join to detect for...
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
November 10, 2010 at 1:02 pm
Viewing 15 posts - 4,996 through 5,010 (of 5,678 total)