236 reputation
213
bio website
location Plano, TX
age 32
visits member for 3 years, 1 month
seen Nov 4 '13 at 6:50

I thought I was wrong once, but I was mistaken.


May
30
comment Maintaining SQL Log Files
Possibly so. The database stores a lot of pos data, however it's not realtime. We receive files from various retailers and load a days worth of data at a time for each retail chain. So I wonder if doing log backups more frequently would make a difference with that in mind?
May
24
comment Maintaining SQL Log Files
This was my first thought too, but then I found out we are actually doing full backups and backing up the log weekly.
May
24
comment Maintaining SQL Log Files
From our network admin: "Full backups run every Saturday morning and the log run after the data run on Saturday then written to tape upon completion. Differential backups are ran as well during the week." I just emailed to ask him if he's verified that recent log backups have been successful but I'm pretty sure he's already checked that.
May
24
asked Maintaining SQL Log Files
May
10
asked Accessing network files from asp.net. What permissions do I need?
May
9
accepted Running asp.net targeting .net framework 4 on Win Server 2003
May
9
comment Running asp.net targeting .net framework 4 on Win Server 2003
I switched it to use the default asp 4.0 app pool and it's working now. Not sure why I can't create my own app pool that targets 4.0 though?
May
9
comment Running asp.net targeting .net framework 4 on Win Server 2003
Okay, I actually found out there's a 2008 server I could use. I installed the framework and ran the above command lines. The application pool for my website still doesn't show an option for 4, although the Default Pool is set to 4. Not sure what's up with that?
May
9
asked Running asp.net targeting .net framework 4 on Win Server 2003
May
3
accepted What should I consider to secure SVN on Windows?
Apr
23
asked How to see when what processes have accessed certain files
Mar
28
comment How to make a huge ram drive?
This db is used to create reports for a relatively small number of decision makers. They get their reports on time so there is no big push from them to upgrade. But they do realize that upgrading it will allow me to be more productive... but I'm not gonna be seeing a 32 core server anytime soon :)
Mar
28
comment How to make a huge ram drive?
Tom, you think more CPUs will move data from the hard drive into RAM faster? The queries I have to run are not exactly that complex, so unless it can do that I don't think it will make any significant difference.
Mar
28
comment How to make a huge ram drive?
I see. I don't think that's a bottleneck for us though. At any given time there's generally not more than one query hitting the db so it's not like SQL would ever make use of that many cores if we had them. I think a whole lotta more RAM has got to be our first priority.
Mar
28
comment How to make a huge ram drive?
Only 25ish rows, mostly numbers, and text fields are titles of books or stores so never that large. But... for some reason I was thinking that VM's were not limited by CPU except that other VM's on the same machine may be competing for resources. In the case of Microsofts VM's, do you know if that's the case?
Mar
24
comment How to make a huge ram drive?
Yes it's on a 12gb VM now, and the idea is to upgrade that situation first. But even with 12gb... that should be more than enough memory to handle a 1,000,000 row table just fine so it leads me to believe there are other bottlenecks besides just the server RAM.
Mar
24
comment How to make a huge ram drive?
Ha, see what? You were emphasizing the need to analyze the db and 'I' was pointing out it was a hardware issue (though I don't know the best solution). But at least we're in agreement :)
Mar
23
awarded  Scholar
Mar
23
accepted How to make a huge ram drive?
Mar
23
comment How to make a huge ram drive?
Just because it's a text field doesn't mean it's not normalized. Unless you're speaking of normalizing past the 3rd form which can become counterproductive depending on the application, but that's another conversation. Anyway, I was assuming you had the ability to find out what the actual query run time was. Sounds like you don't even have access to see an execution plan though?