Viewing 15 posts - 5,491 through 5,505 (of 5,678 total)
You'll want to try it without the NOEXPAND then, or we'll need to look at optimizing it. Either way, to get the correct values, you're subquerying and then reconnecting...
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
September 20, 2010 at 11:03 pm
IF it's taking largish snapshots to deal with multiple enforced relationships... yeah, I could see it, especially if you're meticulous about FK relationships.
As to affecting the log, hm... That...
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
September 20, 2010 at 11:00 pm
I'm curious, but what's wrong with adding additional filters after the view's built? This is a short form of your code, but it's to help me understand what you're...
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
September 20, 2010 at 10:54 pm
DBCC CHECKDB uses an internal database snapshot for the transactional consistency needed to perform these checks.
What's your free space like at the moment? 🙂 It may have just needed...
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
September 20, 2010 at 10:48 pm
Take two: Please actually read the link. You're going to want to give us a CREATE TABLE, INSERT INTO SELECT ... UNION SELECT... structure. Well, unless someone gets...
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
September 20, 2010 at 10:43 pm
Ayie,
I'll save you some trouble before the optimization experts swing through and they can look at your code immediately, you'll want to follow the directions in this link:
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
What you've got...
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
September 20, 2010 at 10:39 pm
Balaji, can you post the actual error you're getting? I think I followed your predicament but it would help to see the actual error.
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
September 20, 2010 at 10:36 pm
Hey Threadizens...
Can someone do a flyby on this post and make sure I haven't missed something that ends up with me blowing smoke and sunshine, and sending this soul off...
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
September 20, 2010 at 10:34 pm
Please provide a sample table and data. See the first link in my signature to help if you need it.
Short form: You'll be looking at creating a 'minutes' table,...
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
September 20, 2010 at 10:29 pm
David O (9/20/2010)
I've updated on the post with the full sql statement for spid 94.
The detailed trace file has everything the spid 94 did from the full minute before...
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
September 20, 2010 at 9:37 pm
An oddity for me, do you happen to still have eventsequence 7003193444, or was it completely unrelated to spids 91 and 94?
I'll save some researchers a bit of lookup for...
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
September 20, 2010 at 5:28 pm
Steve Jones - Editor (9/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
September 20, 2010 at 4:54 pm
No, there isn't... they've wrapped implicit transactions with explicit ones but didn't including anything extra. THIS would be different, however:
CREATE PROCEDURE ProcName
AS
BEGIN
BEGIN TRAN
INSERT Statement
INSERT Statement
COMMIT TRAN
END
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
September 20, 2010 at 4:16 pm
Edogg (9/20/2010)
http://msdn.microsoft.com/en-us/library/ms186865(v=SQL.100).aspx
The BACKUP LOG WITH NO_LOG 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
September 20, 2010 at 4:14 pm
GilaMonster (9/20/2010)
Or, if you don't want to believe me, how about someone who used to work on the storage engine team for SQL 2005.
Not that I don't believe you Gail,...
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
September 20, 2010 at 3:24 pm
Viewing 15 posts - 5,491 through 5,505 (of 5,678 total)