Viewing 15 posts - 3,271 through 3,285 (of 5,678 total)
azhar.iqbal499 (5/2/2011)
Thanks for your valuable time,Attached image file explain Memory settings of our server.
Thanks
Azhar
6400 MB of RAM used by SQL Server on an 8 gig system. Can you confirm...
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
May 2, 2011 at 11:32 am
You're correct, it's valid, but pointless. SQL doesn't stop you from doing it, but it has no effect.
Basically you're saying make sure my ID exists when my ID exists....
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
May 2, 2011 at 11:26 am
Jeff Moden (5/1/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
May 1, 2011 at 11:21 pm
GilaMonster (5/1/2011)
Craig Farrell (5/1/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
May 1, 2011 at 11:18 pm
GilaMonster (5/1/2011)
Craig Farrell (5/1/2011)
Azhar, I'm surprised noone brought this up before. Latches are primarily memory objects.Err, I did... 😉
"Excuse me, waitress? I'll take my foot with ketchup...
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
May 1, 2011 at 4:04 pm
seanhalvers (5/1/2011)
In regards to:
1). Yes, everything eventually rolls up to a single parent. It may seem...
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
May 1, 2011 at 3:15 pm
Thanks Jeff. It's great to walk with you through your beer-popsicle thought process, and for all the work you did here.
I thought I was the only one who 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
May 1, 2011 at 3:08 pm
azhar.iqbal499 (4/30/2011)
OS:Window Server 2003 Enterprize R 2 64 bitRAM: 8GB
SQL Server: MS SQL Server 2008 R2 64-bit Enterprize
Azhar, I'm surprised noone brought this up before. Latches are primarily memory...
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
May 1, 2011 at 2:38 pm
Hey Sean.
What you're dealing with here is a Hierarchal self-join. You usually hear of them in regards to either OrgCharts, or Bills of Materials. I'm not sure 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
May 1, 2011 at 2:31 pm
Syed Jahanzaib Bin hassan (5/1/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
May 1, 2011 at 2:25 pm
Right, that's on the oracle side. What we need to do confirm that your ODBC driver is taking that to the SSIS as datetime. You need to look...
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
May 1, 2011 at 2:13 pm
crainlee2 (4/29/2011)
Great questions, Craig.We only use Compellent's simple replays (snapshots/backups) for the database backup files produced by SQL Server's regular backup operations.
Interesting. So you're not using the SAN...
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
May 1, 2011 at 2:11 pm
LutzM (4/30/2011)
removed. doesn't work under a different test condition...
Well, Lutz, if it makes you feel any better, neither does mine. I forgot the order by in the correlated subquery...
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
April 30, 2011 at 4:27 am
You mention you use simple backups. If you have full backups and need point in time restoration capability, can compellent's snapshots deal with this? I'm assuming it can'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
April 29, 2011 at 5:18 pm
STherrien-978820 (4/29/2011)
My...
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
April 29, 2011 at 4:51 pm
Viewing 15 posts - 3,271 through 3,285 (of 5,678 total)