Viewing 15 posts - 1,231 through 1,245 (of 1,790 total)
From BOL:
The minimum permission required is ALTER on table_name. TRUNCATE TABLE permissions default to the table owner, members of the sysadmin fixed server role, and the db_owner and db_ddladmin...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 12, 2008 at 11:03 am
Wrong with it? No. If you have the bandwidth and the time then by all means you can run those nightly. However, if you have extra time do you mow...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 12, 2008 at 10:57 am
41 ah, I remember 41. Let's see, that was...... oh yeah, this year for me too. 😉 Happy Birthday.
What would I like? A new acoustic guitar. Something mid-range, not...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 12, 2008 at 4:00 am
Richard - If you can really split easily then that is going to be your quickest gain. Additionally, you will immediately split the IO which again is a bonus. The...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 11, 2008 at 7:03 am
You will still have to do an update but something more dynamic. Ultimately you will need a scripting method for reading the contents of a folder. Check out the "Scripting...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 11, 2008 at 5:14 am
Agreed with Gail, you can spread the load with replication effort but that has to be done very carefully and well architected. I have only seen a few environments where...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 11, 2008 at 5:08 am
Based on what you submitted it looks like you need to do an update similar to the following;
update table1
set ref = 'your reference here'
where id = 123
If you are...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 11, 2008 at 5:01 am
I used to have a great side-by-side comparison when I worked at another company where we supported both. Boy do I miss those days.... NOT!!! 🙂
After a bit of searching...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 10, 2008 at 2:38 pm
That depends on how your clients are going to be connecting to the instance. If you working with a fixed set of client connections within your firewall then CAL's should...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 10, 2008 at 8:08 am
Is there application the only thing app hitting that database? If so, and they are confident that there will be no adverse affects then go for it. Make sure you...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 10, 2008 at 7:55 am
Yes.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 10, 2008 at 7:53 am
Can you post your tries so that we can help?
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 10, 2008 at 7:51 am
Have you updated stats on that table following the large data load? I have seen stats cause things to go out to lunch like that.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 10, 2008 at 7:50 am
Agreed but it is one of those necessary oddities so that they can maintain proper releases to their customer community without forcing fixes on them that they don't want or...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 8, 2008 at 7:37 am
Critical - If it is not a usable tool I am going to do something different or create something myself. So, being that I take such a strong stand, I...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 8, 2008 at 7:33 am
Viewing 15 posts - 1,231 through 1,245 (of 1,790 total)