Viewing 15 posts - 4,081 through 4,095 (of 5,685 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...
February 9, 2011 at 3:48 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...
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...
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.
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...
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...
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...
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...
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...
February 9, 2011 at 11:27 am
GSquared (2/9/2011)
February 9, 2011 at 10:50 am
Jan Van der Eecken (2/9/2011)
February 9, 2011 at 10:38 am
smac (2/8/2011)
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...
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...
February 9, 2011 at 10:12 am
Viewing 15 posts - 4,081 through 4,095 (of 5,685 total)