Viewing 15 posts - 3,631 through 3,645 (of 5,678 total)
It's griping because of the single-user mode.
ALTER DATABASE [BTData] SET MULTI_USER WITH NO_WAIT
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
March 19, 2011 at 4:53 pm
Henry, Gail's right (as usual) about the necessity for backups, but it seems like you're an accidental DBA. A little background to why what you're doing didn't work.
There are...
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
March 19, 2011 at 4:51 pm
At a guess you'll get a better idea of what's going on from the lightspeed forums. It sounds like it's looking to use an existing bak file and put...
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
March 19, 2011 at 3:14 pm
Thanks folks, nice to have someone care what I actually type... 😉 Still getting a feel for how it's currently used across the boards. Looks like a cross...
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
March 19, 2011 at 1:18 pm
GilaMonster (3/19/2011)
Craig Farrell (3/18/2011)
Somewhere, the gods are laughing at me... I've started a twitter account.And your twitter handle is????
Was a bit nervous about throwing it out there, but ah, what...
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
March 19, 2011 at 2:33 am
Butterfly, I saw someone mention this earlier in the thread but your way out of this is probably Full Text Indexing. It's a bloat on the data layer but...
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
March 19, 2011 at 12:37 am
Somewhere, the gods are laughing at me... I've started a twitter account.
Now, my one saving grace is I won't be able to get there from work and my phone 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
March 18, 2011 at 4:20 pm
I'd need to see the DDL and the execution plans to really tell you what was happening here, but I don't see any bitwise operators occuring there, so you're 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
March 18, 2011 at 1:44 pm
Koen Verbeeck (3/18/2011)
ProKelly (3/18/2011)
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
March 18, 2011 at 4:33 am
ProKelly (3/18/2011)
My only concern with moving to SSIS is my experience performing tasks such as lookups from OLE DB sources operations are SLOW, really slow compared to SQL code.
I've found...
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
March 18, 2011 at 4:31 am
kirubamca09 (3/18/2011)
'm not clear 'm just generate the script
Then I'll help you find the point of the beginning of your investigation, we can't help you fix this, you MUST understand...
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
March 18, 2011 at 4:27 am
Kiruba, please don't double post.
Please direct all answers and comments to this thread:
http://www.sqlservercentral.com/Forums/Topic1080227-357-1.aspx
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
March 18, 2011 at 4:23 am
Eric Mamet (3/18/2011)
It was running fast on my laptop with either 2005...
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
March 18, 2011 at 4:21 am
Recently dealing with this error in another thread. You found a key via a nonclustered index lookup, and when it went back to the clustered index via keylookup, 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
March 18, 2011 at 4:19 am
leon.booij (3/18/2011)
yes a want to see that, is that possible
Not from decimal, no.
You are in varchar, and need to stay in varchar. You're looking at this the wrong way...
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
March 18, 2011 at 4:16 am
Viewing 15 posts - 3,631 through 3,645 (of 5,678 total)