Viewing 15 posts - 32,761 through 32,775 (of 39,818 total)
select * from ..sysusers. See if it's there
January 2, 2007 at 9:10 am
Nigel,
Is this SQL Server Standard or Enterprise? If it's standard, you won't get the memory higher than it is. If it's not, then you need more memory. The cache hit...
January 2, 2007 at 9:07 am
Maybe I should expand a little. You can't be ignorant of technology, but you don't have to be able to write SQL queries to manage SQL Server DBAs.
You get explanations...
January 2, 2007 at 8:48 am
There are always little bugs and things that they include for tuning. I see a couple hot fixes a month, but most don't apply to me. However it would be...
January 2, 2007 at 8:36 am
Haven't tried, but if you post some DDL And code and explain where you're having issues, maybe we can help.
January 1, 2007 at 12:36 pm
No logging for SELECTs, you are correct in that.
For the continuous selects, likely the data will remain in cache in memory, if it's the same or similar data, and you...
January 1, 2007 at 12:35 pm
I'd also get rid of the t1.* and t2.*. If you're looking for matches, just get the PKs in the select list and then use that list to get the...
January 1, 2007 at 12:33 pm
I'd recommend you try it with a regular login, maybe db_writer/reader in the db and see what happens. I've had a few of these applications "require" SA, but only one...
January 1, 2007 at 12:32 pm
I wish. Unfortunately, too often people don't read the sticky things. I have to admit that on other sites I've missed them as well and restorted to asking an question...
January 1, 2007 at 12:30 pm
Thanks and good post as well. And I hope your daughter is right.
January 1, 2007 at 12:28 pm
If you don't have an idea of what is "normal" for your system, then there's no way of knowing if this is a good number or not. I wouldn't worry...
December 29, 2006 at 11:21 am
Has the server been rebooted?
I've used multiple NICs and IPs several times and it's worked fine. I don't think I've changed the server network utility, but can't remember.
December 29, 2006 at 11:18 am
I'm not sure a RAM disk is supported for Tempdb, but I know some people have done it. It should definitely help your queries since lots of temp operations in...
December 29, 2006 at 10:14 am
Viewing 15 posts - 32,761 through 32,775 (of 39,818 total)