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...

>>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...

>>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. ...

I was wondering if someone would bring up filtered indexes for this scenario. It certainly seems...

Joe Celko (1/22/2009)

---

Did you know that CURRENT_TIMESTAMP has worked in SQL Server for several release now? The only excuse for talking like a hillbilly is "job security programming" or...

Charles Kincaid (1/22/2009)

---

That's why my FoxPro can't Access the Oracle. How can I make...

>>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...

Joe Celko (1/22/2009)

---

getdate()?? Didn't you mean to say CURRENT_TIMESTAMP? We want to use all the ANSI/ISO stuff that Microsoft will give us instead of UNIX dialect museum exhibits....

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.

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...

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,...

>>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...

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...

Joe Celko (1/19/2009)

---

>>I'm also somewhat wary of CLR stuff. Its fine for simple stuff and scalar functions but for more complex stuff such as the new geographic types in...

Again... I just don't understand what you're trying to tell me and why I should "drop the set based mantra for 30 seconds". The cursor is slower than...