Viewing 15 posts - 16 through 30 (of 498 total)
Hyperthreading won't affect the tempdb, growth factor or tran log size. However it may be the problem for this "Write requests are refused, whereas read requests are processed, and any...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
July 20, 2004 at 1:56 pm
One more thing. If you have hyperthreading turned on, turn it off.
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
July 16, 2004 at 3:25 pm
Are you sure you're not running out of log space? If you have a 1.6tb database I don't see how the 80gig log will be large enough! Maybe I'm missing...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
July 16, 2004 at 3:24 pm
Francisco,
You might think about the possibility of turning the sproc into a udf. In this way you would then simply do the following.
INSERT INTO #Foo(...)
SELECT ... FROM dbo.f_YourNewUDF(...)
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
July 16, 2004 at 3:14 pm
Add a log table that you put a record in when the process starts and another when the process finishes. Then simply query the log table using the NOLOCK hint....
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
July 16, 2004 at 3:05 pm
Can you give us some ddl and a sample query to work with? Also if you separate it out to individual queries do they all run?
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
July 16, 2004 at 2:48 pm
I don't think your VB code is correct on the last post. You would first have to create the command object and then execute it. At that time you should...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
July 16, 2004 at 2:46 pm
I don't think I would want to have my SQL Server calling winsock directly. If it were to error out more than likely you would end up downing the server This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
July 15, 2004 at 1:10 pm
This is going to make your life miserable in the long run.
As Alzdba stated I would add an identity column to use as an alternate key for table and...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
July 15, 2004 at 1:00 pm
This is because you have "Smart Quotes" replacement turned on in Word. If you go to the "AutoCorrect" settings you can turn it off and you should no longer have...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
July 15, 2004 at 12:31 pm
If you are worried about the data becoming dirty I would use a transaction and set the isolation level as appropriate. In this way if the update were to fail...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
July 15, 2004 at 12:19 pm
I don't think it is the constraints that are causing the problem here. Here is what I would try.
Create a nonclustered index on the CycleID and ExtractTypeId fields to use...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
July 7, 2004 at 12:44 pm
You could do something like
WHERE distance <= ISNULL(@MaxDistance, distance)
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
July 7, 2004 at 12:31 pm
OK. Lets try removing the SQL Maint all together and creating a job manually to see if we can find out what is happening.
Try creating a backup device using the remote...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
July 7, 2004 at 12:20 pm
In this last DDL I see a few places you could speed this up. First since you moved the data into the temp table to do the update. Make sure...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
July 7, 2004 at 12:07 pm
Viewing 15 posts - 16 through 30 (of 498 total)