Viewing 15 posts - 3,046 through 3,060 (of 7,429 total)
As I have not played with this myself I can only suggest what I would try. Since you are getting some of this from SQL NS in VB do a...
May 6, 2003 at 4:07 am
If you have a high number of transaction on the server the differential backup can in some situations take longer than a full backup especially later in the time frame....
May 6, 2003 at 4:05 am
Not sure, is this happening often and is it always the same SPID for the operation? In addition have you added any hot patches after SP3 install and maybe revisioned...
May 6, 2003 at 3:50 am
quote:
Remember the 90-10 rule. 90% of the code runs only 10% of the time, and 10% of the code runs 90%...
May 6, 2003 at 3:36 am
I would not let go below 80% if possible but it might help to segment older data to another table and join with a view if there is a way...
May 5, 2003 at 3:48 pm
I got a copy and found it to be highly usefull. My only concerns are what is the compression threshold before loseless becomes lossy potential in data. But so far...
May 5, 2003 at 8:48 am
Create a job in SQL Agent, just paste your Script into a step and set a scheduled time.
May 5, 2003 at 6:35 am
No they feel it is well optimized and that there is no reason to do this. (Says so in BOL in their own words).
If you are looking to see if...
May 5, 2003 at 4:23 am
If you mean can you access other databases without having to disconnect from one and connect to another the answer is yes. As long as they have proper permissions the...
May 5, 2003 at 4:20 am
First it is saying that for object dbo.tblDrug it cannot find a column named 'Category'.
Secondly there is no Aggregation going on with DrugName so if you correct the Category column...
May 5, 2003 at 4:11 am
I would most likely suspect just that. You might try setting the locking to page level specifically or use NOLOCK in your Report query to see if affects. However, the...
May 5, 2003 at 4:01 am
Which version of SQL Server?
If SQL 6.5 it is the Configuration Option 'tempdb in ram'
7 or later is no longer supported.
May 5, 2003 at 3:57 am
SQL 7 is 1024
SQL 2K is 2100
Found under Create Procdure in BOL for property of n argument.
All can be Input or Output.
Edited by - antares686 on 05/02/2003 09:12:26 AM
May 2, 2003 at 9:12 am
Really the major issue there is the fact the number of rows within the index can vary based on the data length of each record. This does cause a bit...
May 2, 2003 at 8:54 am
Viewing 15 posts - 3,046 through 3,060 (of 7,429 total)