Viewing 15 posts - 1,036 through 1,050 (of 1,790 total)
Ok, go ahead and take the next 2 days off. 😛
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 19, 2008 at 12:14 pm
I'm a little confused by the sql statement as it doesn't appear to be referencing the table at all but I am guessing that you are within the function. What...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 19, 2008 at 10:19 am
Making some great assumptions as I still don't have queries but if you are going to be retrieving 2 years of data (is that what you were stating?) then you...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 19, 2008 at 9:49 am
That all depends on table design and access patterns. Being that you are on 2000 you could use a partitioned view to bring the multiple table scenario into one "table"...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 19, 2008 at 9:30 am
You can review the following article on MS for help in the login migration. http://support.microsoft.com/kb/918992
Hope that helps.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 19, 2008 at 9:24 am
Thanks Gail. The question was phrased in a way that it appeared to be a follow-up post which made me suspicious. 🙂
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 19, 2008 at 8:19 am
If you are just looking to copy a table then backup / restore is a bit heavy. Try right clicking on the database, select Tasks, Select Import / Export Data...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 19, 2008 at 8:11 am
Matt - my mistake. Do the developers need to update the database? If so, scratch my other two posts. Ack, bad David....
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 4, 2008 at 10:16 am
You can actually use the secondary server for querying. See BOL;
You can reduce the load on your primary server by using a secondary server for read-only query processing. To do...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 4, 2008 at 10:13 am
Thanks Steve! We had kind of considered that but determined it wouldn't work right in our situation. Hopefully we can hear of some other solutions!
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 4, 2008 at 9:56 am
Matt,
Sorry for the late reply to this (don't get to check the site very often, a bit busy) but something else to consider is that your transaction log files...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 4, 2008 at 9:53 am
Manu,
You would have to run the restore from a connection to server B pointing to the backup file on server A. So, from SSMS connected to server B run...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 3, 2008 at 8:37 pm
From a performance perspective it is going to depend on the utilization of the databases however, if that is the disk availability that you have I would recommend splitting it...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 2, 2008 at 9:07 am
Agreed, the questions are definitely getting worse, and that most recent one that Jeff responded to is right up there on the scale of BAD.
So, the question is what...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
November 24, 2008 at 7:36 am
anorton (11/21/2008)
Is there anyway to get around the server service needing the credentials for the shares?
No, you would need to have the permissions established. One question though, you had stated...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
November 21, 2008 at 3:44 pm
Viewing 15 posts - 1,036 through 1,050 (of 1,790 total)