Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: vnad
  • Content: Threads
  • Order by date
  1. vnad

    Unique by set - How to get resultset

    So I have a problem that I don't think is too rare but having a brain fart. So I have multiple sets of data. Id1 Id2 Column1 1 2 A 1 2 B 1 2 C 1 3 A 1 3 B 1 3 C 1 4 A 1 4 D 1 4 E So I have a 1 unique set of id1=1 with A, B, C and another uniquie set of...
  2. vnad

    How do you check if full text change tracking is on?

    I have a table and I want to see if full text change tracking is enabled? Where do you check this? Also, how would you check to see if auto propagation for the background update index is on as well?
  3. vnad

    Full text indexing / MSSEARCH - different server?

    Is it possible to move the MSSEARCH.EXE service off our production server to a 2nd (SQL) server so we can distribute the CPU and I/O of the incremental populations that are going on for the full text indexes? We are seeing high CPU usage and I/O from the loads we are doing throughout the day...
  4. vnad

    Symmetrix vs HP local disk (8 x 72gb 15k raid 5), HP winning

    I am running some comparisons on a HP ML570 box. We have one 36gb (8GB luns, 0+1) drive on the company EMC Symmetrix attached by two emulex 9802 fibers with powerpath. We also have 400GB drive with 8 x 72gb 15k local attach scsi disks running a raid 5. When I run comparisons, the local attached...
  5. vnad

    Wscript hangs when running command

    I am running a pretty simple command through VBscript Set oShell = CreateObject("Wscript.Shell") commandRun = "cmd /k WZZIP " & destinationFolderPath & sDate & " " & destinationFolderPath & "dn*" set OutputValue = oShell.Exec (commandRun) Do while (outputValue.Status <> 2) wscript.sleep(1000)...
  6. vnad

    Path not found - Virtual directorys / File system objects

    I have the following code <BODY> The path of the virtual directory is <% Response.Write Server.MapPath("VD_Path\SQL") %> <% set oFso=Server.CreateObject("Scripting.FileSystemObject") For Each oFile In oFso.GetFolder(Server.MapPath("VD_PATH\SQL")).Files...
  7. vnad

    Bulk insert hangs at end of inserting (BCP)

    I am moving data out of a table using BCP to a file and then loading it back into a different table using BCP. I am moving about 5 million to 10 million per call. The data gets to the file quick enough (5-10 mins). The problem is with the load. It loads about 95 percent of the data, then it...
  8. vnad

    Possible to create one logical drive out of 2 physical drives?

    We are currently on a EMC SAN solution and the disk partitions get presented to our server. I heard of a way through windows to take two SAN partitions and concatenate them to one logical drive. Is this possible and how is it done? Thanks.
  9. vnad

    Performance hit when moved to 550GB drive

    We are on a EMC Symmetrix and have been running great for over a year. We were running low on space, so we added a 550GB drive. When we copied our SQL Server database over to the drive, we lost about 40% in performance from the drive we were on (250GB) drive. We are using only one HBA (LP8000)...
  10. vnad

    Update statistics after drop/readd of indexes?

    Does the statistics get updated when you drop and readd the indexes of a table? Would there be a performance gain if we did an update stats on every index?
  11. vnad

    Join or Union between two tables?

    I have two databases with similar data. I want to do a join the same tables from each database into one result set. If I do a union, everything seems to be ok except I am getting duplicate records if one field is updated in one table. For example Table 1 id name address 10...
  12. vnad

    SQL Standard can take more than 2 gigs?!?

    We have heard that SQL standard can take over 2 gigs of memory. We are currently running SQL 2000 Standard on Windows 2000 Advanced Server with 4 gigs physical memory. When we go into the SQL server properties, we can set the max limit to 3.8 gigs for SQL to take. Now, SQL server only takes...
  13. vnad

    Checkpoint / TLog hangs, does not release resources

    We are running a Tranlog backup and it is taking way too much time to complete. On average, it would take about 5 mins to backup. We are experiencing log backups to over an hour for only 100 mb log. It places the file out on the backup directory within seconds of starting. It also moves the...
  14. vnad

    Would null values reduce size of a table?

    We have a large table and would like to reduce the amount of physical disk it is occupying. We cannot delete rows since we need the data. Would the size of the table go down if we changed all the fields we do not use in the table to NULL? We cannot cut the fields out of the table since it is a...
  15. vnad

    Get 2nd row (not 1st) from result set

    I would like to return the second row of a result set to compare against. I am currently using TOP 1 but I do not want that row that is returned. Here is my code. select * from uTable where sField = (select TOP 1 sField from utable where sAccount = '12345') I would like to get the second...
  16. vnad

    Sum of Top 7 rows - then next 7 rows....

    I am working with a table that I want to take the first seven rows, group and sum them, write them to a table then take the next seven rows, group and sum them, write them to a table on so on. Do you know of any good ways of doing this? Thanks, Dan
  17. vnad

    SLA Reporting - Looking for ideas

    I am looking for ideas on how to determine Service level agreements with our customer. We currently just calculate when the server goes down but I would like to know what other ways we can calculate response time / user outages. Any ideas on how you have it setup would be welcome. Thanks, Dan
  18. vnad

    How do you get database response time?

    We are in contract negotiations and our customer wants to base their contract off a service level agreeement that has database response time in it. I need to find out how long it takes for them to process a transaction on our server. If we know how long it takes to return the transaction, we can...
  19. vnad

    SAN performance - percent disk Time over 100!

    I am running the perfmon in NT and I am trying to get percent disk time for the San. I am getting a value over 100. Anyone tell me what this means or how to interpret it? Thanks.
  20. vnad

    After EPO install, SQL enterprise manager bombs

    After I installed the EPO agent. I cannot fire the Enterprise manager on that server. It gives me the SQLDMO is not registered, please run setup. Any ideas?

Part and Inventory Search

Back
Top