Viewing 15 posts - 2,716 through 2,730 (of 18,926 total)
Yes, but short of not taking any backups, I think that's the worst way to go about this.
September 13, 2011 at 9:30 am
david.adlington (9/13/2011)
Neither work unfortunately.
In the sql server add ROW_NUMBER() / 65000
Then add a group with new page on that new field.
September 13, 2011 at 8:45 am
GilaMonster (9/13/2011)
Home PC. My clients know better (usually because I teach them, sometimes cause they learn the hard way first)
Doesn't the latter lead to the former most of the time?...
September 13, 2011 at 8:43 am
THE-FHA (9/13/2011)
Truncate is not logged so i would assume it being faster!
Wrong, minimally logged, but logged.
http://www.sqlservercentral.com/Forums/Topic908285-1198-1.aspx
September 13, 2011 at 8:35 am
GilaMonster (9/13/2011)
Ninja's_RGR'us (9/13/2011)
GilaMonster (9/13/2011)
Obviously my answer was deemed so unacceptably stupid that it didn't even warrant a reply... :hehe:
Of course not, what the hell do you know about DR? ...
September 13, 2011 at 8:34 am
Ninja's_RGR'us (9/6/2011)
I don't have SSD in prod nor do I have tested it.
The fact is afaik MS never spoke about disk speed in their fragmentation...
September 13, 2011 at 8:30 am
GilaMonster (9/13/2011)
Obviously my answer was deemed so unacceptably stupid that it didn't even warrant a reply... :hehe:
Of course not, what the hell do you know about DR? :Whistling:
September 13, 2011 at 8:28 am
halifaxdal (9/13/2011)
GilaMonster (9/13/2011)
halifaxdal (9/13/2011)
Ninja's_RGR'us (9/13/2011)
Get Gail in for a consult. Can't be done over forums.
I would love to, but if that costs any expense, then I personally can't make...
September 13, 2011 at 8:26 am
GilaMonster (9/13/2011)
halifaxdal (9/13/2011)
Ninja's_RGR'us (9/13/2011)
Get Gail in for a consult. Can't be done over forums.I would love to, but if that costs any expense, then I personally can't make it.;-)
Absolutely,...
September 13, 2011 at 8:19 am
halifaxdal (9/13/2011)
A backup room is being seeked and hopefully we find it so we don't have to do the fix on the real prod server
Stupid-ish question. Any other db...
September 13, 2011 at 8:09 am
barryFS (9/13/2011)
Can I ask another question on this.
Now I have the data that I want, how can I get the rows inserted into a table that I have created, so...
September 13, 2011 at 8:01 am
Gianluca Sartori (9/13/2011)
If you want a replacement for sp_MSForEachDB, (it appears to have some issues) you can take a look here:http://spaghettidba.wordpress.com/2011/09/09/a-better-sp_msforeachdb/
What issues?
September 13, 2011 at 8:00 am
halifaxdal (9/13/2011)
September 13, 2011 at 7:59 am
espanolanthony (9/13/2011)
If I knew I would not have posted here. I would very much appreciate if someone shed some light on it please.
I know a lot, but google knows more...
September 13, 2011 at 7:58 am
halifaxdal (9/13/2011)
Then wait 400 years untill mankind lives without money and all will be good.
I would really very much like to have money to spend, I just don't see the...
September 13, 2011 at 7:56 am
Viewing 15 posts - 2,716 through 2,730 (of 18,926 total)