Posts Made By: -TheGame-

thanks for the reply, i'm leaning towards most of the cursors are probably being closed because i think we would see locking issues, i have found some that are not being deallocated though and need to dig into that more.

But on the bright side i found the major part of bottle neck for ...

Hi guys, I'm working on improving performance in a billing database and am trying to find out if all cursors that are open eventually get closed and de-allocated.

The one of the processes that i'm working to improve loops on 90000-ish records.. which then loops on data usually using ...

forgive me if I'm wrong, I'm not super familier with DOS and relitively new to C# :P

Couldn't I use the command line to select my files by date range then loop through that list to find the files without the _MSMQ?

and the syntax for the dir /t:c 07-03-2008:07-07-2008 ??

This is part of an existing project, but using the console might help in getting my file list within the date range quicker.... then find the specific files after that.

This is going to an app that not so technical people are going to be using so the simpler the better :P thanks for ...

crap! thats what i was afriad of!! lol thanks for the reply

Or if anyone could tell me how to do a directory search where the filename doesn't contain "_MSMQ" that would work to by cutting down on the search time.

Hi guys, I'm trying to write a method that will return a list of files based off the of the CreationDate.

The directory i am searching contains 20 to 30 thousand XML files....

is there anyway i can narrow down my file list to just the ones with the CreationDate range I ...

thanks for the replies!

I did read that it doesnt carry sound, which is fine, my plan was to get a 5 or 7.1 set of PC speakers to use.

I have been reading that some videocards do HDMI output so i may just do HDMI to HDMI, my main concern with my setup is if HDCP was going ...

wow that is wicked funny! thanks for that!!

So.... I'm looking to build a new box in the next couple months, I haven't built a system in the past 5 years or so and trying to read up on HDCP and crap like that is making it kinda difficult to know what to buy!

my basic goal is to be able to have a DVD backup server ( couple of ...

So trying to find a receiver that would be good for me... but not too expensive (looking in the few hundred dollar range). But I have no idea what is good or if I can go a different route instead of a receiver. My main goal was to be able to create a DVD backup server and be able to stream those to

Thanks guys! I did the sub query to get the first count, then the total count, Then just did a bunch of UNIONs for each different transaction... lol

Might not be the most efficiant.... but it works thanks again!

sorry i thought it was pretty confusing, lol

I need to count the rows in the screenshot below as 1 and dont count the rows rows that the CustomInfo01 numbers are all the same.

They wont always be 1 and 2, they could be 2 and 3, or 3 and 4. ect ect.

This ...

Hey Guys.... been trying to wrap my brain around this one.... but i'm not the best at SQL so here it goes :P

we have a transaction database in our insurance company and i need to manually reconsile the number of transaction vs the number of documents we produce to make sure nothing ...

So I've been looking around and I really haven't found a decent way to search through files on a network drive. What I'm looking for is a way to exclude certain text in a file name. At work we have a folder I search for errors on based on if there is missing text in a name... anyone ever seen ...

Yeah i find her very attractive.... but i have a thing for redheads anwyays, lol

Anyone know the name of the song that goes with that video??? lol

there is a program that is called Remote Administrator, but my eval has expired and that as worked for me, but i wanted too impressed iwth the program and i think there has got to be something better, lol i didnt know if any of you guys had heard of anything though. thanks for the replies ...

Hey guys, i was just curious if anyone knew of a way to Enable Direct 3D through windows remote desktop... im running XP Pro SP2 and my setup is my main PC and then another PC that i just have connected to the network without a KB, mouse, or monitor that i use to play games as well.
...

lol, oh well i tried :P