Viewing 15 posts - 17,911 through 17,925 (of 22,214 total)
No, I don't think it rearranges the nonclustered indexes.
If you're doing large scale loads, you might want to drop the indexes & recreate them after the load because a large...
March 27, 2009 at 5:50 am
Jeff Moden (3/26/2009)
Grant Fritchey (3/26/2009)
Bob Hovious (3/26/2009)
YOU are Mr. 3000.
In honor of this momentous occasion, you get to buy beers for...
March 26, 2009 at 7:52 pm
Alvin Ramard (3/26/2009)
Jeff Moden (3/26/2009)
Grant Fritchey (3/26/2009)
Bob Hovious (3/26/2009)
YOU are Mr. 3000.
In honor of this momentous occasion, you get to buy...
March 26, 2009 at 7:51 pm
Lynn Pettis (3/26/2009)
And I really have to ask, what is a fnords?
If you have to ask, we can't tell you.
Actually, you shouldn't be able to see fnord:anything between the:fnord fnords....
March 26, 2009 at 1:12 pm
musab (3/26/2009)
sorry I am unable to get your point please explain again !
Sorry, you ought to be able do something like the following. There are probably better ways, but this...
March 26, 2009 at 12:40 pm
Luke L (3/26/2009)
Chris Morris (3/26/2009)
Grant Fritchey (3/26/2009)
Besides, I've operated nuclear power plants while inebriated (not my fault, my chief liked drinking partners) and nothing happened.
If anybody wants to know...
March 26, 2009 at 9:14 am
Quotes are acting all wonky...
Anyway, I sure can have scotch & fly a Star Fury. It's space... what am I going to hit?
Besides, I've operated nuclear power plants while inebriated...
March 26, 2009 at 7:33 am
Bob Hovious (3/26/2009)
YOU are Mr. 3000.
In honor of this momentous occasion, you get to buy beers for the whole gang, and...
March 26, 2009 at 7:02 am
Chris has it. You should be able to use the PK value as an ordering clause. Delete the rows where the ID is not equal to the top ID ordered...
March 26, 2009 at 7:00 am
How about using the last update date column as a differentiator. Then you can order by that column and join on the text column. I would think that should get...
March 26, 2009 at 6:12 am
Not without some structures and execution plans. It's just too hard to guess at what might work in your circumstances.
March 26, 2009 at 5:46 am
Actually, it works fine. I just did it. You get the query results and the messages in a single window when you change the output from the default grid to...
March 26, 2009 at 5:44 am
I'd suggest picking up a copy of Craig Mullins book "Database Administration." It's technology agnostic and just talks about the job of being a DBA. It's a great read.
March 26, 2009 at 5:33 am
One option is to change the output of the results from a grid to text. Then the columns and the I/O all come out in a single window.
March 26, 2009 at 5:31 am
You should look up full text indexing for the varchar(max) column. That's the best mechanism for use with this sort of thing.
Are there other indexes on the table? A PK?
March 26, 2009 at 5:30 am
Viewing 15 posts - 17,911 through 17,925 (of 22,214 total)