Viewing 15 posts - 721 through 735 (of 1,790 total)
K. Brian Kelley (3/9/2009)
DavidB (3/9/2009)
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 9, 2009 at 11:59 am
Laughing.... I have struggled down a path or two with that one before as well and found myself wondering if I was talking to two different people and then realizing...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 9, 2009 at 11:45 am
Lynn Pettis (3/9/2009)
Lynn Pettis (3/9/2009)
And Gail, its easy to see why you leave Mike to others to answer. I mean, really.Okay, I just went sarcastic in this thread.
I think...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 9, 2009 at 11:39 am
Hey Mike,
You need to know which chipset (processors) you are using. x86 is 32-Bit, x64 is 64 Bit and IA64 is the Itanium chipset which I doubt you have...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 9, 2009 at 11:33 am
sp_spaceused includes both the data and log files in the size represented.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 9, 2009 at 9:40 am
Most likely if things are running fine for most of the time then it is probably a query or a set of queries that are causing the problems. I think...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 9, 2009 at 9:37 am
My guess is that the FTI will perform better, and I believe you would limit those reads a bit as well. 🙂
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 6, 2009 at 2:17 pm
Unfortunately there is not a concrete answer on that as it really depends on the size of the table. If you are looking at a relatively small table my guess...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 6, 2009 at 2:09 pm
When we are speaking in the realm of personal tastes, coffee, chocolate, poetry, etc we can have our likes expressed freely (albeit carefully) but when we come to the world...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 6, 2009 at 2:04 pm
GSquared (3/6/2009)
tosscrosby (3/6/2009)
GSquared (3/6/2009)
I'm surprised, with your credentials, that you don't know that. Or is writing and performance-tuning SQL not your strong point?
Good one G. I don't like to...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 6, 2009 at 2:00 pm
It should not affect replication in that replication will still work. I know that you cannot add an index on any columns added by replication as that will break things...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 6, 2009 at 1:53 pm
Mangal9i (3/6/2009)
Is there can be any logical reasoning for liking something?
I would think there would have to be correct? If I like coffee better than tea for example, it would...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 6, 2009 at 1:43 pm
That would be a right outer join and should be replaced by the proper syntax as that will not function in the future.
Hope this helps.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 6, 2009 at 9:52 am
Karsten (3/6/2009)
A thought crossed my mind, whether this is similar to the default implementation of READ COMMITTED isolation level in Oracle databases, isn't it?
Uh Huh. 😀
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 6, 2009 at 7:50 am
SQL ORACLE (2/27/2009)
Could you provide references or links for your statements?
My first response was a direct quote from BOL (Books On Line). Look under the arguments section at the @objname...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 28, 2009 at 6:11 am
Viewing 15 posts - 721 through 735 (of 1,790 total)