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 Rhinorhino 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. ousoonerjoe

    Report Viewer at Runtime

    Will this not work? Bear with the sample. It's snip-its from our Reporting Class that is also a wrapper for displaying reports. Private ParamLisings As Generic.List(Of Microsoft.Reporting.WinForms.ReportParameter) = Nothing If ParamLisings Is Nothing Then ParamLisings = New...
  2. ousoonerjoe

    Report Viewer at Runtime

    Are you trying to use Server Side reports or is the report local to the app? -------------------------------------------------- “Crash programs fail because they are based on the theory that, with nine women pregnant, you can get a baby a month.” --Wernher von Braun...
  3. ousoonerjoe

    Collation Mismatch

    Thanks, George. I suspected a column level shift was pretty basic, but yeah, the searches returned some pretty drastic answers that I thought were rather over the top. I appreciate the answer. -------------------------------------------------- “Crash programs fail because they are based on...
  4. ousoonerjoe

    Collation Mismatch

    Simple question... I think. I have a table that all the VARCHAR fields got converted to "SQL_EBCDIC037_CP1_CS_AS" whereas the rest of the system is using "SQL_Latin1_General_CP1_CI_AS" which is the system default. Don't ask how it happened, this is an inherited system. Five years later, we're...
  5. ousoonerjoe

    Design Question

    Many years ago, I worked for a Doc Imaging Company. What we did was store the image (usually a TIFF) on the server and it's relative path in the database. Then when the user clicked <Next Item>, we would pull the file path and pass it over to the image control. Granted, this was back in the VB6...
  6. ousoonerjoe

    How To Deal WIth A Micromanager

    Like your boss or not, I would advise against burning your bridges. It has a way of coming back on you down the road. Micro-mangers are the worst, and it would seem that the higher-ups are at least aware there is an issue. You're out of the frying pan, and just leave it at that. Hopefully your...
  7. ousoonerjoe

    Odd Deadlock Issue

    UPDATE: It appears that it is an issue with the Indexes. 1 PK on an Identity Seed, 1 on a Date field, and 2 on VARCHAR fields with a 90% Fill Factor. It would seem as the indexes were splitting and re-ordering on INSERTS, the heavy traffic of that table couldn't keep up. Once we dropped the two...
  8. ousoonerjoe

    I have no hope

    About 15 years ago I worked as a hardware tech and warranty repair counter. I taught myself basic networking, and started dabbling in programming. I found I had a knack and real love for programming and went to a 2 year school and got my Assoc. in it. After applying to over 400 different...
  9. ousoonerjoe

    VS 2012 versus VS 2013 Thoughts?

    I think this is the correct forum. If not, please let me know, and I'll repost appropriately. We are currently using VB.Net 2010. The discussion came up about upgrading to either VS 2012 or VS 2013. We have talked about integrating Windows phone capabilities for the sales guys (Contact...
  10. ousoonerjoe

    Odd Deadlock Issue

    Thanks for the reply. We can systematically recreate deadlocks and timeouts with Updates, etc. The problem we're having is that everything we know about the Deadlock rules states that they should not be in effect here. Procedure1 INSERT 1 record into TableA. Procedure2 INSERT 1 record into...
  11. ousoonerjoe

    Help with an update query from 1 table to another...

    Close.... BEGIN TRANSACTION; UPDATE coilspec.dbo.coilspec SET wire1 = ws.coil FROM coilspec.dbo.wirespec ws WHERE coilspec.dbo.coilspec.coil = ws.coil; ... wrote freehand, so check it before committing. -------------------------------------------------- “Crash programs fail because they are...
  12. ousoonerjoe

    Odd Deadlock Issue

    haha... That's exactly how I found out that it was the source of the deadlock. The dump shows both the Offender and the Victim were dbo.Audit. There are no triggers. Three indexes (possibility?) that get rebuilt every weekend with the back up process, and do not have Page Locks enabled, only Row...
  13. ousoonerjoe

    Odd Deadlock Issue

    Using SQL Server 2008 R2 I have an intermittent deadlock that happens on one of our audit tables. From what I understand of Row Locking, it shouldn't be happening at all here. All our stored procedures have the following layout (trimmed for ease of debugging). Now with all things being equal...
  14. ousoonerjoe

    Run script on DB Startup

    Well, they (NetAdmins) have that locked out. So I used the sp_procoption you mentioned previously until they decide to get around to doing it. George, thank you greatly for the assist. -------------------------------------------------- “Crash programs fail because they are based on the theory...
  15. ousoonerjoe

    Run script on DB Startup

    George, Thank you. That's close enough for what I need. DBCC TRACEON (3605,1204,1222,-1) It's a simple little setting that enables the DeadLock information to be reported. I then have a job that dumps that info to an email and sends it to us. In fact, I got it from SqlServerCentral.com here...
  16. ousoonerjoe

    Run script on DB Startup

    I must not be putting in the right key words to Google. I have a simple DBCC command I want to run every time the server/service is restarted. The Maintenance Plans do not support an "On Start Up" option for execution times. Does anyone know how to accomplish this? Is it possible? I appreciate...
  17. ousoonerjoe

    Deadlock occurs with INSERT VALUES

    Agreed, George. I wish there was more I could do, but it does seem that I am at my limits there. I'm open to a better way of auditing actions. These entries have been a major source of CYA over the last couple of years to the point it is not going away now. It could be replaced, but not...
  18. ousoonerjoe

    Deadlock occurs with INSERT VALUES

    Apologies for the delay in response. After a couple of discussions with the powers that be, it would appear that we are going to be migrating to a VM Ware solution for our servers. Meaning, there will be no other discs to put things on. According to the test results that were given to me, "it...
  19. ousoonerjoe

    Deadlock occurs with INSERT VALUES

    After further discussions with the Hardware guys. They are convinced that the RAID designs already give the same benefits as splitting the Logs and Data files. However, I can migrate tempdb off C: and get it over to the RAID area. That would be the biggest improvement I can make at this time...
  20. ousoonerjoe

    Deadlock occurs with INSERT VALUES

    Thanks for the feedback, George. Currently the Logs and Data are on the same drive, but the drive is part of a RAID setup. Does that not negate a great deal of the drive IO issues? EXEC sp_helptrigger 'Audit'; = No Records Found EXEC sp_helpindex 'Audit'; = PK_Audit clustered, unique, primary...

Part and Inventory Search

Back
Top