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: *

  1. dimbulbz

    High Lock wait time on Cluster server?

    We are experiencing very high lock waits/second on our Cluster server - any ideas on what resorces we may need to modify to clear this up? Things are very, very slow. Any ideas, or can you point me to any articles on how latch waits affect performance? I've found some info on what they are...
  2. dimbulbz

    Sysindexes table showing unexpected indid entries?

    A simple query of the sysindexes table is returning up to 220 indid entries for a table that only has one index/key defined. what causes the additonal entries? most tables only have one entry per defined index. The entries also show zero pages associated with them. Does this indicate some kind...
  3. dimbulbz

    Executing the results of a query

    I need to be able to execute the result set of a query. I have used xp_cmdshell, with an ISQL statement, but all I really want to do is call a new SQL widow from within SQL and execute, without all ISQL /U /P /Q"yadayada..." These are simple, one line queries that are loaded into a variable...
  4. dimbulbz

    Moving TempDB in a clustered environment?

    I have a need to relocate Temp DB to another physical drive, are there any issues with doing this on a cluster? - or is it the same process of using the 'Alter DB' and rebooting? Jim Johnston dimbulbz@hotmail.com
  5. dimbulbz

    Query results to a file within a DTS package?

    This ought to be an easy answer, but how do you send 'results to file' query results without being prompted for the file name? I would like to send a DBCC showcontig to a flat file, then import it into SQL using a DTS package. But I cant seem to get the DBCC results to go directly to a file...

Part and Inventory Search

Back
Top