Viewing 15 posts - 2,296 through 2,310 (of 3,232 total)
I'm not sure I totaly agree with you guys on processes not being able to block themselves. A process can show up as blocking iteself when there is network or...
April 30, 2007 at 8:34 am
Sree, you've gotten some great advice here so far. I only have one thing to add. If you've been tasked with looking into performance tuning an application, a good first...
April 27, 2007 at 4:04 pm
I'm not sure. Books on line does not say this. Microsoft's MSDN page says it is new to SP3: http://msdn2.microsoft.com/en-us/library/aa214020(SQL.80).aspx
April 27, 2007 at 11:58 am
It is an executable that gets installed with SQL Server. It will be in your SQL Server installation directory's Binn folder. Just run SQLDiag.exe. It takes just a minute or...
April 27, 2007 at 11:22 am
I would also recommend that you run SQLDiag at the time of freeze up. This will help determine blocking/locking issues and wait types as well as much other useful info.
April 27, 2007 at 10:15 am
I don't know if you can read the column names in via ActiveX, but there may be a way that I am not aware of. What about using the data...
April 27, 2007 at 8:57 am
You mean if the duplicates are not limited to the 5 columns and instead we have to check all 60 columns? In that case, you must scale out the GROUP...
April 26, 2007 at 4:01 pm
There may be a better way, but here's what I would start with.
1. Create 2 staging tables, one for the Quantity data and one for the Price data.
2. Import the...
April 26, 2007 at 3:54 pm
You say that 5 of the columns define the uniqueness. I assume then since you have a duplicate row that there is not a constraint of any kind here to...
April 26, 2007 at 3:44 pm
Well, if you look in BOL, error 701 says:
There is insufficient system memory to run this query.
Can you tell us a bit more about your environment (Windows OS, SQL Server...
April 26, 2007 at 3:23 pm
So does the job actually fail or does it just appear hung? If it does fail, what is the failure message? If it just appears hung, have you looked at...
April 26, 2007 at 3:07 pm
I don't think this is a protocol issue. Especially if you've had a significant increase in your storage requirements. Timeouts occur because a process is taking too long (big duh,...
April 26, 2007 at 12:58 pm
I think we need a bit more info here. Can you post your table DDL, sample data, and an example of what you want to have happen. What determines which...
April 25, 2007 at 3:47 pm
Insert results from xp_Fixeddrives into a temp table as such:
CREATE TABLE #DriveTable (Drive CHAR(1), [MB Free] int)
INSERT INTO #DriveTable
EXEC master..xp_fixeddrives
SELECT *
FROM #DriveTable
DROP TABLE #DriveTable
Now, use t-sql to query the...
April 25, 2007 at 9:52 am
Viewing 15 posts - 2,296 through 2,310 (of 3,232 total)