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!

Recent content by cornercuttin

  1. cornercuttin

    unmute audio on startup in Solaris 10 CDE

    We are having a problem with one of our installs (Solaris 10, CDE). When the user logs in, the sound is muted by default. As our main application uses the sound for alerts and whatnot, it needs to be unmuted by default. Does anyone know of any way to do this? We have looked and looked and...
  2. cornercuttin

    faster queries in sql 2000

    ok. so i looked at the indexes. this table has 1 index, and it indexes 7 of the 60 or so columns in this table. it is non-clustered. the type of query i want to run is a count(*) query. it has 4 rows in the "where" part of the query, and 3 of the 4 are indexed. i performed one of the...
  3. cornercuttin

    faster queries in sql 2000

    hmm. i dont think there are any indexes set up. i didnt set up this database, so i dont know the eact sql used to create the table, but when i double click the table in the enterprise manager, it doesnt say anything about indexes. also, what do you mean by execution plan? im not sure what...
  4. cornercuttin

    faster queries in sql 2000

    i am using a database that is hosted using sql 2000 (i think), and it is on a box that is from the same year or a year later, so the hardware and software are about 6 or 7 years old. one of the tables in the database is about 6.5 gigs in size, and it is extremely slow to perform queries on...
  5. cornercuttin

    stored procedure - do something for every day between x and y

    do you really think triggers would be ok for this? we get roughly 25 thousand insertions a day into this 1 table. there are about 25 tables in this one database, and there are also another 10 or so databases running on this ms sql server. with that many insertions, are triggers not going to...
  6. cornercuttin

    stored procedure - do something for every day between x and y

    yeah. there are actually year, month, day, hour, and second fields for this table. the trigger wouldnt work. the table for last year had about 9 million insertions. thousands or even tens of thousands of inserts a day. i am starting to figure it out a little. if i get it figured out, i...
  7. cornercuttin

    stored procedure - do something for every day between x and y

    and i also guess i should say, this stored procedure will be called by a "job", and will be run every day. the thing is, if i could be assured the "job" was called every day, then this would be a lot easier. but because this system is a bit volatile, i cannot assume that the sql server will...
  8. cornercuttin

    stored procedure - do something for every day between x and y

    i am relatively new to sql server, and even more new to stored procedures (I have done quite a bit of SQL, but it has all been "1 liner" kind of things). basically, i have a table that is getting quite a bit of updates every day, and each update gives me a timestamp of when the insert was done...
  9. cornercuttin

    sql help concerning dates

    ok. i have been sitting here looking at this for a few hours thinking about it, and i have no idea where to go. the situation is as follows: i have this huge table that gets updates throughout the day, and in this database there are fields for year, month, day, hour, second for when the...
  10. cornercuttin

    very newbie needs a little help getting started

    yeah, through a lot of trial and error, i figured out it is the linux box. the gateway wasnt set, but whenever i try to set it (via the route command), it sets the default gateway, but whenever the interface(eth0) goes down and comes back up, that entry in the routing table is deleted. is...
  11. cornercuttin

    very newbie needs a little help getting started

    ive figured out that the problem is not the switch at all, but the linux computer. ive somehow set the static ip incorrectly. i can ping everything on my local net, but cant get outside of the gateway. any hints? thanks
  12. cornercuttin

    very newbie needs a little help getting started

    im extremely new to cisco, so of course, im having a little trouble getting my initial setup working. basically, im just wanting to hook up my switch to my dsl gateway and then hook up my servers to the cisco switch and assign them static ip's. i have 5 available static ip's and then the dsl...
See more

Part and Inventory Search

Back
Top