Viewing 15 posts - 34,561 through 34,575 (of 39,793 total)
Not sure what you mean here. Are you looking for information on reading execution plans?
October 13, 2004 at 10:42 am
Briscoe is correct, so I will award the points back. Also I will correct the question to say "numeric".
Steve
October 12, 2004 at 12:48 pm
You cannot take a backup that includes only tables and I'm not sure what you are trying to do? Are you looking to make periodic backups? Is your app going...
October 12, 2004 at 10:40 am
Joe,
What do you mean disable? Are you trying to test a restore of Master?
October 12, 2004 at 10:39 am
I would assume you'd join the TOrderDetail to the TOrder based on the OrderID column.
October 12, 2004 at 10:38 am
These are hard to track down. The query plan is built based on conditions on the server at the time it's compiled. Have you checked to be sure the indexes...
October 12, 2004 at 10:37 am
Not sure about the buffer size. Haven't worked with it. The batch size, however, can prevent the logs from filling. It tells the package what size of (Rows) to insert...
October 12, 2004 at 10:36 am
Most likely it will continue for the next 5-6 years. SQL Server 7 is still supported (although that's about to end) and it was released on 99.
October 12, 2004 at 10:34 am
What does the process do? Perhaps the data has changed. Be sure you run update statistics on the tables involved, also check dbcc showcontig for fragmentation. If it's drastically changed,...
October 12, 2004 at 10:33 am
If you have a steady enough workload, i.e., not too many ad hoc queries, then this will work. It typically hasn't been an issue with my systems, but we have...
October 12, 2004 at 10:32 am
Or you just give them rights to select from the view or underlying table with granting insert, update, or delete.
October 12, 2004 at 10:21 am
What is the package doing when it is hanging? Try running it interactively from the designer to see.
The waittype means that the OLEDB conenction is waiting on something.
October 12, 2004 at 10:19 am
Be sure that this login has rights to connect to SQL Server. Test logging in yourself as this account.
October 12, 2004 at 10:17 am
The issue with having slow IO and causing the page latches is something you'd fix with hardware changes. You are accumulating latches (lightweight locks) because it is taking too long...
October 12, 2004 at 10:16 am
In SQL Server 2000, you can have collation set at the column level, so each column could be different. You can set a default for the db and change it...
October 12, 2004 at 10:12 am
Viewing 15 posts - 34,561 through 34,575 (of 39,793 total)