Viewing 15 posts - 3,256 through 3,270 (of 5,678 total)
Fill factor only makes sense if you understand how SQL Server stores records. It stores in an object called a page, which when you're done with header information 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
May 3, 2011 at 2:09 pm
If you need to avoid lock escalation, don't go above 5000 rows per pass:
http://msdn.microsoft.com/en-us/library/ms184286.aspx
See about midway down for a description of when the thresholds are hit and locks escalate.
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 3, 2011 at 12:25 pm
vasamsettipradeep (5/3/2011)
I joined two tables but the problem is I want to join another table to this there is no any relation like match rows between these tables.
With no...
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 3, 2011 at 12:22 pm
Steve Jones - SSC Editor (5/3/2011)
For Virtual Restore it's very quick....
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 3, 2011 at 12:18 pm
WayneS (5/3/2011)
Here's the results that I have. The "DemilitedSplit8Kpt" is the new DelimitedSplit8K function, with a permanent tally table.10 to 20 Characters per Element:
B'narg! Whaaaa? After a point...
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 3, 2011 at 11:45 am
vinod.saraswat (5/3/2011)
Drive free space: 201GB
Db size : 133283.31 MB
Space available : 34094.38 MB
Drive free space (For tempdb) :601 GB
After the execution below are the observations
Drive free space: 187GB
Db...
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 3, 2011 at 11:32 am
Bad brain day indeed. Need to GROUP BY on the productId and sum the quantity. 🙂
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 3:35 pm
tfifield (5/2/2011)
Todd,This should give you what you want. It gives each order and its items for only orders that have the same items.
Todd, that can get fouled up by...
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 2:06 pm
ricer (5/2/2011)
Craig Farrell (5/2/2011)
Basically you're saying make sure my ID exists when...
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 12:48 pm
As Dave mentioned, please post the execution plans. The actuals by preference.
I noticed this: WHERE 1=1
This usually occurs when you're dealing with dynamic SQL builds. It looks like...
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 12:44 pm
SQLkiwi (5/2/2011)
Ninja's_RGR'us (5/2/2011)
You can always mail it to me if you want... I won't tell a soul :-).No, I am resisting casting further aspertions on Craig's mental health.
Thank you, I...
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 12:14 pm
GilaMonster (5/2/2011)
Ninja's_RGR'us (5/2/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 2, 2011 at 12:07 pm
Ninja's_RGR'us (5/2/2011)
Brandie(5/2/2011)
Ninja, I can hardly throw stones on that particular point. Being a speed reader tends to work against me on the online forums.
Same here... hence #1 for amount of...
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 12:06 pm
Syed Jahanzaib Bin hassan (5/2/2011)
I am shocked because you dont know about how to generate T-SQL script from SSIS for the maintenance
How to generate a T-SQL script from 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
May 2, 2011 at 12:02 pm
Brandie Tarvin (4/29/2011)
GSquared (4/29/2011)
I tell people that my job description is specifically designed to see how fast a person's eyes can glaze over. The entertainment starts there.
I may have...
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:33 am
Viewing 15 posts - 3,256 through 3,270 (of 5,678 total)