Viewing 15 posts - 1,081 through 1,095 (of 5,678 total)
What recovery mode is the database in, out of curiousity?
Also, what exact version and SP pack are you currently running? Any hotfixes/odd startup flags on the server?
My guess 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
October 9, 2012 at 1:59 pm
You need to call a service running on Server2 to execute the process, else the exe gets transferred to server1 and ran there. So, you'll need something already existing...
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
October 9, 2012 at 1:57 pm
You might want to look into the use of .RAW files in SSIS. They're basically SSIS's version of temp tables. What they do is pull off a single...
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
October 5, 2012 at 1:01 pm
Nadrek (10/5/2012)
CptCrusty1 (10/5/2012)
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
October 5, 2012 at 12:58 pm
Abu Dina (10/5/2012)
Hmmm... I made a lame attempt to answer the 8 questions. I then researched the answers online.You wouldn't have hired me! Lol 😀
Noone can know everything about SQL...
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
October 5, 2012 at 12:53 pm
You will need to continuously backup the transaction log, it's part of maintaining a database in anything except simple recovery. Most places I know do either 1 hour 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
October 4, 2012 at 6:31 pm
You will slightly to heavily slow down any other query using that index, but that's not a bad thing depending on how large an item you stuffed in there.
At 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
October 4, 2012 at 6:10 pm
dallas13 (10/4/2012)
That's sounds great. Thanks but I dont want CTE. Common table expression is there any other way? Thanks a ton
All a CTE presents is an encapsulated subquery. Just...
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
October 4, 2012 at 6:09 pm
Grab a backup and restore it on your notebook? I hate that wizard, it's got so many danged little issues.
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
October 4, 2012 at 4:41 pm
This is a compound problem. static is the easy part, it's consistent.
First, you need to know if you've got Y, N, or mixed. That can be handled with...
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
October 4, 2012 at 4:39 pm
Table tblgas01g4c40 is returning more than one distinct record for that ID. There's nothing that can be 'fixed' in the statement, you're returning too much data in your subselect.
Either...
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
October 4, 2012 at 4:28 pm
Chain your charindexes.
Basically, you'll want a where clause that looks like this:
WHERE
CHARINDEX( LastName, '/') > 0 -- / exists
AND CHARINDEX( LastName, '/', CHARINDEX( LastName, '/') + 1) = 0 --...
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
October 4, 2012 at 4:09 pm
aaron.reese (10/3/2012)
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
October 4, 2012 at 3:04 pm
Hey Abby,
You're new here so you're probably just not sure of how to present your issue. If you take a look at the first link in my signature below,...
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
October 4, 2012 at 2:48 pm
Right, use an extra column to create the identities, then a calculated column for your varchar field that converts it into the one you need with formatting
Otherwise, no, not really....
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
October 4, 2012 at 2:46 pm
Viewing 15 posts - 1,081 through 1,095 (of 5,678 total)