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!

  • Congratulations strongm 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: sqlcasey
  • Order by date
  1. sqlcasey

    Jobs - 2 questions

    Hi, ver 2005 1.) What does it mean when it shows a job executed successfully at such and such time, but there is no history under "view history" ? 2.) Is there a reason that an "EXEC (mySQLStmt)" would not run from a stored procedure that is called from a job? That is, if I run the "EXEC...
  2. sqlcasey

    working with the latest and greatest technology?

    Dude, you are making the right choice... personally and karmically... you can do some other things in the meantime, and it ain't so bad - 1.) educate yourself in your spare time and be grateful for the opportunity to do so in your much NICER environment 2.) find another job with the...
  3. sqlcasey

    Question about backups

    Hi, I just wanted to get a "consensus" about this issue. Our company recently moved its datacenter out of state. We are now using SAN technology for all of our data files and backups... that is, everything now resides on the SAN disk array - files and backups. To date, we have no mechanism in...
  4. sqlcasey

    don't understand why this index is fragmented

    wait, i was confused... you are right... i think the solution here is to convert some of these indexes to clustered indexes... since they are UNIQUE, non null anyways... it will be easier than the 3 options you mentioned thanks
  5. sqlcasey

    don't understand why this index is fragmented

    I find this statement interesting because every week the log indicates the the DBCC DBREINDEX took place on non-clustered indexes. And running DBCC SHOWCONTIG on the index in question, it shows: - Pages Scanned................................: 102 - Extents...
  6. sqlcasey

    don't understand why this index is fragmented

    found the culprit - the table is truncated on a weekly basis, then the fields re-populated i guess that would explain the fragmentation? not sure how, though
  7. sqlcasey

    Error: 18456, Severity: 14, State: 16.

    MicheleWeaver, first question - why does the error log also indicate SQL Server starting up? second question - are you currently running 2005 on a 64 bit server? if so, please be aware that there is a serious memory bug in 2005 on 64 bit servers this may have nothing to do with your...
  8. sqlcasey

    don't understand why this index is fragmented

    Hi, I am examining the weekly index defrag report... I run DBCC REINDEX on a weekly basis on indexes that are fragmented. This is weird. One of the indexes that was reindexed was an index on a numeric ID field - it's a nonclustered, unique, primary key index - don't ask me why this is a...
  9. sqlcasey

    Question about DBCC DBREINDEX

    Hi, I have a weekly job that examines the index fragmentation of all tables in a given database. If the index fragmentation reaches a certain threshhold, then it runs DBCC DBREINDEX against the table, with a fillfactor of 75 (the decision to use 75 was somewhat arbitrary on my part). However...
  10. sqlcasey

    Boss behavior - is this normal?

    dear aarenot, your read on the situation is totally off - frankly i could care less about a promotion here (i am already in the highest position I could ask for in my dept, as a DBA)- nor am i interested in status or title, i just want an intelligent, reasonable manager, and i just want to be...
  11. sqlcasey

    sql server 2000 start date - end date

    select * from mytable where datepart(month, mydate) > 1 and datepart(month, mydate) < 3 and datepart (year, mydate) = 2006 -- this would return all dates with a month of February, or month = 2, in the year of 2006 -- see datepart in BOL
  12. sqlcasey

    Boss behavior - is this normal?

    Thanks, all... really there is no solution here, and that's ok, I've decided, as it is time to move on! Boss really is #3 on my list... #1 is lack of meaningful work assignments, and #2 is the fact that I can never make what I'm worth here So even if #3 disappeared, I'd still be moving on to...
  13. sqlcasey

    Boss behavior - is this normal?

    Hi, Just want to get a reality check here. Prior to our company getting bought out, I had a pretty decent manager. Despite a few annoying idiosyncracies (like talking too much!), he was bright and energetic, and actually very helpful at times. I also had a pretty good relationship to his boss...
  14. sqlcasey

    misc questions

    Thanks to everyone for their advice. SQLSister, thanks for the "data analyst" tip - sounds like that could be right up my alley... I actually had no idea what this was, and that I would be qualified for this type of work. Good to know. And there seem to be lots of jobs!
  15. sqlcasey

    Aggregation tables for reporting

    No, we're not going to any advanced stuff for now. It was more just an informational question, mostly for myself, because I seriously doubt we would ever use this here. :-)
  16. sqlcasey

    Aggregation tables for reporting

    Hi, Thanks for the posts. George, we have implemented your solution exactly. I guess my question is, what would be the next step, so to speak, using SQL Server solutions, such as OLAP and Analysis Services? That is, when do you know when to use these tools? Thanks
  17. sqlcasey

    misc questions

    Yeah, I'm definitely not ready for an interview yet I'm still working on the resume :-)
  18. sqlcasey

    misc questions

    Thanks SQL Bill. That is encouraging.
  19. sqlcasey

    Career advice

    Hi, I have been at my present company for about a year and half. Before this job, I had been out of the IT loop for about 4 years due to living on a beautiful tropical island with no IT jobs :-) That said, I was eager to return to IT, and a real paycheck. My previous career had been as an...
  20. sqlcasey

    misc questions

    my favorite job was a temporary summer cook position but that was a different era, ha so, at this point, i glean that knowing vb or c# is a good thing, along with dts, ssis, and reporting services

Part and Inventory Search

Back
Top