Viewing 15 posts - 5,251 through 5,265 (of 7,429 total)
This might help, or I can look thru MSDN for the C api's if you can translate. http://www.vbcodemagician.dk/resources/perfs.htm
"Don't roll your eyes at me. I will tape them in place." (Teacher...
July 12, 2002 at 10:14 pm
Found this out today and could be a possiblity to your issue. Some boards due not fully support some RAM types and mixing these in can be a factor. Also...
July 12, 2002 at 10:02 pm
Also going back to the clustered index thing you can if you read up on DBCC SHOWCONTIG, if a table does not have a clustred index you can ignore Logical...
July 12, 2002 at 9:54 pm
Could need some extra cleanup. Try sp_updatestats and DBCC UPDATEUSAGE, then DBCC DBREINDEX, and finally try shrink the database. Then run SHOWCONTIG and see if changes. Also what version of...
July 12, 2002 at 9:48 pm
Check out http://www.snmplink.org/News.html it has links to MIB files. Should be able to find the most current if one exists, specific to your needs.
"Don't roll your eyes at me. I...
July 12, 2002 at 8:45 pm
I have not seen this problem myself but here are a few question that may help.
1) How many network adapters are in the server?
2) How do your segments relate, (Is...
July 12, 2002 at 7:55 pm
When I test UPDATES, INSERTS and DELETES I do a SELECT, BEGIN TRANS, SELECT, and ROLLBACK TRANS to be sure in testing the results were as expected even if...
July 12, 2002 at 5:58 pm
I believe I helped with this same thing previously. Can you run the following so I can get an idea of what the Query Manager is doing. Run
SET SHOWPLAN_TEXT ON
GO
YourQueryRunsHere
GO
And...
July 12, 2002 at 2:00 pm
Try ISNULL(column1,1) * ISNULL(column2,1)
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
July 12, 2002 at 1:52 pm
You have to restore as was originally. 9GB, then split it into smaller pieces, backup, then restore like you suggest. You cannot split the file during the restore.
"Don't roll your...
July 12, 2002 at 1:48 pm
See my example in this thread
It will give you an idea of one optional way. Otherwise you may need to use a cursor.
"Don't roll your eyes at me. I will...
July 12, 2002 at 11:15 am
I am betting it is as he wrote it.
quote:
Here is a great SQL Problem. I actually found this in some application code.
July 12, 2002 at 9:13 am
D@&^&IT
That is one of those stupid things you know and forget. A suqeury can use as a reference any column from the outer query. That is why you can this....
July 12, 2002 at 8:39 am
This is assuming you want to know the output table size.
Here is the math I use, it is rough but I believe this is correct.
DatalengthPerRow * NumberOfRows = TotalBytesOfData
8000bytesPerPage /...
July 12, 2002 at 8:34 am
Why??
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
July 12, 2002 at 8:25 am
Viewing 15 posts - 5,251 through 5,265 (of 7,429 total)