Viewing 15 posts - 4,786 through 4,800 (of 5,843 total)
I too have used ERStudio for years now. Good tool. It can get expensive, especially if you get cross-platform licenses. If you are sql server only they...
February 2, 2009 at 12:40 pm
checkai (1/30/2009)
RAM: 3.25GB
CPU: Intel Xeon 5150, 2.66GHz
Windows Server 2006 Std Edition
SQL Server 2005...
January 30, 2009 at 2:05 pm
I will take the opposite end of the spectrum and say that DTA should be avoided at all costs by anyone without significant knowledge of SQL Server and indexing strategies...
January 27, 2009 at 1:31 pm
>>As was mentioned earlier, SQL Server will allocate as much RAM as it can. This can often cause problems because SQL neither knows nor cares about other processes on...
January 27, 2009 at 1:29 pm
>>Ditto ISO standard data. If there is an international standard use it.
If there is no international standard conform to an industry standard
>>
I will take the contrary position here. ...
January 23, 2009 at 2:48 pm
Peso (1/22/2009)
With SQL Server 2008CREATE NONCLUSTERED INDEX IX_MyBitField ON MyTable (MyBitField)
WHERE MyBitField = 1
I was wondering if someone would bring up filtered indexes for this scenario. It certainly seems...
January 23, 2009 at 6:05 am
Joe Celko (1/22/2009)
January 22, 2009 at 5:18 pm
Charles Kincaid (1/22/2009)
TheSQLGuru (1/22/2009)
No, he said and meant getdate() because this is a MICROSOFT SQL SERVER ONLY FORUM!
That's why my FoxPro can't Access the Oracle. How can I make...
January 22, 2009 at 5:01 pm
>>Any DBA who thinks an index on a bit field is a good idea.
You have a billion row table, with from 0 to 100 rows at any one time having...
January 22, 2009 at 2:45 pm
Joe Celko (1/22/2009)
January 22, 2009 at 2:42 pm
25-50 pages/sec isn't bad. As long as avg disk sec/read and avg disk sec/write aren't troublesome your IO is probably doing OK.
January 21, 2009 at 9:44 am
GSquared, I think you are off-base on many fronts.
1) Again, just because someone can't or won't design/write optimal software does not mean he/she should not be working in...
January 20, 2009 at 4:47 pm
So, please avoid the ad hominem. If you have an example, from your "real world", where customers are perfectly happy with web pages that don't work, where poorly researched,...
January 20, 2009 at 10:38 am
>>Which regular expression system? grep(), sgrep(), xgrep(), POSIX, et al? Now, if I had Standard SQL there would be the SIMILAR TO predicate which is based on the POSIX...
January 19, 2009 at 2:48 pm
1) some one said this "Your point is to design it for 6 MILLION products right from the start. And I agree. ". Meanwhile, while your group is...
January 19, 2009 at 2:42 pm
Viewing 15 posts - 4,786 through 4,800 (of 5,843 total)