Viewing 15 posts - 376 through 390 (of 5,678 total)
IanSinclair (3/5/2014)
This option might not work - so plitting a source stream...
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 5, 2014 at 9:23 am
Hey Dwain,
Excellent usage explanation article, thanks for that.
The issue with table parameters is the big reason you'd want to use one, cross database or cross server data table pollination, fails....
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 4, 2014 at 4:13 pm
Included columns are stored alongside the clustered index key lookup information at the leaf level, thus widening the storage for that index. It's a powerful tool, but easy to...
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
February 27, 2014 at 4:49 pm
DaveDB (2/24/2014)
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
February 24, 2014 at 11:36 am
Never personally used it. Haven't even booted up the interface. Never had to.
One of my vendors who runs our SoR seems to use it pretty heavily. Haven't...
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
February 21, 2014 at 4:19 pm
Sounds like a data, network, or request timeout.
What you see is what's called 'firehosing'. Basically the system starts returning data even though it's not finished getting all of 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
February 21, 2014 at 4:13 pm
ghitpro (2/21/2014)
I would like to include few columns (varchar and int data types) from same table in below query without adding in group clause, i do not want these column...
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
February 21, 2014 at 2:12 pm
nrajeshkumar (2/20/2014)
the condition is the query should be within 140 characters..
Please link the site to the competition so we can see all the rules at once instead of you feeding...
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
February 21, 2014 at 1:26 am
ericjorg (2/20/2014)
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
February 20, 2014 at 9:00 pm
Just to clarify...
You're updating 500 gigs of data and wondering why you have growth of 400 gigs, or did I misunderstand that part?
In SSIS, on your destination, what's your commit...
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
February 20, 2014 at 5:39 pm
SELECT CONVERT( INT, LEFT( column, CHARINDEX( column, '\') - 1))?
What chapter in which textbook are you guys working on? That'll help us know what they're trying to get you...
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
February 20, 2014 at 5:10 pm
This may sound silly but when you login to the target server with the login you're logged into your local as, and look at the database, you can see tables/procs/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
February 20, 2014 at 4:00 pm
You need to adjust your wildcard usage.
1/2 is handled via the %mydata and mydata%. You can't use an anchor character but that will function. For #3, you need...
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
February 20, 2014 at 3:25 pm
To confirm, you're sa/dbo on production with your NT login?
Go to security in the linked server. What is the default setting for a login not defined? Is 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
February 20, 2014 at 3:22 pm
Really it depends on how fine you want your error controls, and if you're doing bulk or singleton inserts.
If your inserts come down one at a time, that's fine. ...
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
February 19, 2014 at 5:47 pm
Viewing 15 posts - 376 through 390 (of 5,678 total)