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.


Apr
15
comment Sql Database Mirroring in a workgroup
Thanks, I just now saw your last comment but that's exactly what I ended up doing.
Apr
8
comment Sql Database Mirroring in a workgroup
I just noticed he put the principal account in the witness box and vice versa, explaining that this would create the endpoints so that they granted rights to account from the opposite machine. I'm not sure how that works out when there are 3 machines involved (with the witness) though.
Jan
31
comment Deploying SharePoint for testing purposes
@BretFisher Thanks, someone else didn't think so apparently though. I guess they saw the word "home" in my question and decided it was off topic 6 months after I'd already answered it myself, haha.
Jun
6
comment How to see when stored procedures have last run
No, just thought sql server might keep stats on this info. See my edit.
Jun
5
comment How to see when stored procedures have last run
Thanks. I guess I just assumed that since you can see that kind of information on tables that you'd be able to get it for sp's too.
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
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?
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
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?
Mar
23
comment How to make a huge ram drive?
Aaaah, I see where the miscommunication is now. The hope was to somehow run the db on some kind of ram drive, but NOT with the intention that the ram for this drive would be coming from the ram the server itself is running on. I.e. FusionIO is exactly the answer I was looking for, because I previously didn't know if something like it existed or not.
Mar
23
comment How to make a huge ram drive?
Also, 80 numeric fields can easily be less than even 20 text fields. We have a mix of text, numeric, and datetime.
Mar
23
comment How to make a huge ram drive?
I just did a test 3 times on "select id from customers" versus "select sum(id) from customers". The latter query averaged out to be about 5 times faster. So back to my question, would it be possible for you to actually try that test and let me know a real result?