Viewing 15 posts - 5,371 through 5,385 (of 5,678 total)
The reason for the highly variable results is the industry your in can, and will, change the auditing level and specific controls you might run into.
Example: One place 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
October 5, 2010 at 3:42 pm
SuzDBA (10/5/2010)
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, 2010 at 3:38 pm
Tara-1044200 (10/5/2010)
any scripts to help this from the forum members?
Direct script, no, but this will help with the across the server bit:
sp_MSforeachDB
You can run the same script across all db's...
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, 2010 at 3:35 pm
GilaMonster (10/5/2010)
Craig Farrell (10/5/2010)
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, 2010 at 2:56 pm
Hrm. So, dedicated box, dedicated drives, no failures and all RAID 10. You've reindexed, defragged, and anything else that be causing physical churn.
You're getting spotty results between 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 5, 2010 at 2:36 pm
I got it right, but a question regarding dedicated extents. I know page splits will happen, etc etc, but does an extent stay compact for a range of data,...
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, 2010 at 2:25 pm
I'd still be leaning towards a drive problem. What kind of arrays are they, and do you have a drive failure if they're RAID 5?
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, 2010 at 2:19 pm
loki1049 (10/5/2010)
WayneS (10/4/2010)
DataYear,
YearlyWage,
FiveYearWage = (SELECT SUM(YearlyWage)...
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, 2010 at 1:14 pm
Alvin Ramard (10/5/2010)
Steve Jones - SSC Editor (10/5/2010)
Perhaps Gail could practice some archery in view of the office. Maybe aim for low down on the torso 😛
Waving a shiny piece...
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, 2010 at 12:52 pm
Lance Roberts (10/5/2010)
I don't need to see that kind of obscene language in emails. I've unsubscribed.
?? :unsure:
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, 2010 at 12:34 pm
Sounds like unexpected outside pressure. I assume your drives are on a SAN. Get your network administrators to double check if your LUNs were recently shared with another...
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, 2010 at 11:28 am
GilaMonster (10/5/2010)
CirquedeSQLeil (10/5/2010)
Wow - I think I would pull that PM and my boss aside. That is bogus.
The PM's boss fully supports him. I'm an external consultant (ie slave),...
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, 2010 at 11:26 am
gheinze (10/5/2010)
Thanks to all. You were helpfull to me to understand a lot of things about locks.Now I will test on my production system and check how it behaves.
Yikes! ...
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, 2010 at 10:57 am
WayneS (10/4/2010)
Chad Crawford (10/4/2010)
GilaMonster (10/4/2010)
Chad Crawford (10/4/2010)
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, 2010 at 6:14 pm
Change this:
SELECT @strQuery= 'SELECT VendorId From Vendors
WHERE CountryId = '+@CountryId+' '+@CityId+'
ORDERBY CreatedDate'
To this:
SELECT @strQuery= 'SELECT VendorId From Vendors WHERE CountryId = '
+CAST( @CountryId AS VARCHAR(100) )
+' '
+@CityId
+'ORDERBY CreatedDate'
I think,...
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, 2010 at 4:08 pm
Viewing 15 posts - 5,371 through 5,385 (of 5,678 total)