Viewing 15 posts - 5,236 through 5,250 (of 5,678 total)
fowl language
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 21, 2010 at 2:58 pm
Of course, you could always have some fun with it...
Change the collation to Hebrew_CI_AI, Cyrillic_General_CI_AI, or Japanese_CS_AS.
Use a replacement cypher that only swaps to characters at CHAR(500) +...
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 21, 2010 at 2:51 pm
Found the problem.
This specific line:
,ROW_NUMBER() OVER(ORDER BY p.PortfolioCode) AS POSN_KY_POS_ID
is causing the entire problem. Remove that line (and only that line, the converts were not causing an issue), and...
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 21, 2010 at 2:13 pm
The attachment has flown the coup. Please reattach. 🙂
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 21, 2010 at 1:57 pm
Both excellent ideas, and unfortunately went there already.
In regards to the first one I tried using count(*) instead of any column list to make sure I wasn't dealing with a...
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 21, 2010 at 1:41 pm
Um, wha? What are you trying to do? As already mentioned, the answer is no, not exactly, though kinda yes, because non-clustered will include the clustered as a...
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 21, 2010 at 1:26 pm
GilaMonster (10/21/2010)
Anyone need a good laugh?http://www.careerride.com/sql-server-what-is-index-segmentation.aspx
Oh good grief, my brain already hurt today. Now it's making a run for the border. Tequila, anyone?
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 21, 2010 at 1:23 pm
A bit of additional information I neglected to include in the above discussion:
If I take the select statement directly out of the view and append the where clause directly 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
October 21, 2010 at 12:53 pm
Hey Threadizens,
I've got a confusion that I could really use your assistance with in regards to some strangeness out of the optimization engine. Well, strange to me. If...
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 21, 2010 at 12:25 pm
Lutz, that is wild. I like it. Thanks. :w00t:
Have you done that on huge recordsets? Does it perform well?
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 20, 2010 at 5:42 pm
A serial update might work for this, but the implementation would require me to see the underlying DDL for the table and indexing, specifically the clustered index.
For the proper rules...
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 20, 2010 at 4:22 pm
Steve Jones - SSC Editor (10/20/2010)
Multi-row triggers are something...
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 20, 2010 at 3:42 pm
I'd start with doublechecking the ssrs is looking at the correct database and doesn't have a filter you aren't seeing. After that I forget if data cache'ing can cause...
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 20, 2010 at 3:34 pm
Well, apparently sign me up, shame I'm nowhere near it.
Anyone give me the short form as to why these two are included?
IS NULL
Multi-row triggers
I wouldn't consider auditing an edge...
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 20, 2010 at 3:29 pm
LutzM (10/20/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 20, 2010 at 2:49 pm
Viewing 15 posts - 5,236 through 5,250 (of 5,678 total)