Viewing 15 posts - 4,081 through 4,095 (of 5,678 total)
You have to assign the new file to a different logical filegroup in the database, otherwise you can't control it.
Once you have done that, you rebuild the clustered index in...
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
February 9, 2011 at 3:48 pm
EDIT: Late update, ignore.
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
February 9, 2011 at 3:02 pm
To extrapolate on what Mike provided above, you can't edit an IDENTITY column while it's being included, and you can't update it after the fact.
You can, however, INSERT into it...
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
February 9, 2011 at 2:41 pm
Stefan Krzywicki (2/9/2011)
Craig Farrell (2/9/2011)
GSquared (2/9/2011)
Kit G (2/9/2011)
To those Threadzians (and everyone else) getting hit by the latest winter storm, stay warm and safe.
And to those in Florida who 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
February 9, 2011 at 2:24 pm
Silly as it sounds, try it without the dbo. in front of the #Accounts
Also, I assume IF @AccountType = 'Account' is supposed to be @Type, from the parameters.
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
February 9, 2011 at 2:22 pm
GSquared (2/9/2011)
Kit G (2/9/2011)
To those Threadzians (and everyone else) getting hit by the latest winter storm, stay warm and safe.
And to those in Florida who can't deal with frigid, sub-70...
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
February 9, 2011 at 2:17 pm
In the real code, remove the 'WhatItFinds' column, I merely left it in there as an example.. You don't want to call a correlated subquery twice. This 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
February 9, 2011 at 2:02 pm
adonetok (2/9/2011)
I try to run code from SSCommitted but I got an error as below. How to fix it?
Our company is still using SQL 2000. I do...
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
February 9, 2011 at 12:50 pm
adonetok (2/9/2011)
I need to move Excel data to SQL. In Excel, it is easier to calculate duration:...
How to code in SQL is really hard for me. Can someone help me?
One...
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
February 9, 2011 at 12:18 pm
Hey Denny, welcome to SSC. Since you're new here, you'll probably want to take a look at the first link in my signature. It describes how to setup...
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
February 9, 2011 at 11:27 am
GSquared (2/9/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
February 9, 2011 at 10:50 am
Jan Van der Eecken (2/9/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
February 9, 2011 at 10:38 am
smac (2/8/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
February 9, 2011 at 10:24 am
In addition to Gus' method, a second pass will also ease your mass rewrite by simply updating all (NOLOCK) to WITH (NOLOCK), and then the second pass updating all WITH...
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
February 9, 2011 at 10:15 am
Drag another lookup to the screen, and bring the datastream (green/red arrows) to it to do your next lookup. The previously defined lookup gets added to the metadata 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
February 9, 2011 at 10:12 am
Viewing 15 posts - 4,081 through 4,095 (of 5,678 total)