Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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