searching for strings is often best accomplished by using Full Text Search. I note that the 2008+ versions are much better than the 2005 one.

jamessdba (5/19/2011)

---

Hi,

My manager asked me to track the Backend db correction

Ho to track the changes in the Db

example

suppose if i did not go to the office...

Partitioning is a VERY complex scenario with MANY ways you can screw it up. ...

Robert Pepin (5/18/2011)

---

We have been working with the Red Gate Data compare product for several weeks now and is the product that we are having issues with. We are...

sqlapprentice (5/18/2011)

---

TheSQLGuru (5/18/2011)

---

Extra space is also required for the intermediate sorting during index build unless you specify the SORT_IN_TEMPDB option. IIRC rebuiding an index requires something like 1.3X size...

Extra space is also required for the intermediate sorting during index build unless you specify the SORT_IN_TEMPDB option. IIRC rebuiding an index requires something like 1.3X size for the...

Hope you are aware that when you defrag your indexes the size of your database will expand back out some.

Robert Davis (5/18/2011)

---

Was that a typo? Does your server really have only 4 GB of RAM? Do you have the 3 GB parameter set or using AWE?

My minimum reccommendation for...

sqlapprentice (5/17/2011)

---

I finally solved this issue...

SQL 2008 R2 release was almost all about either extreme scale stuff or BI stuff. Not much at all for us relational engine types. 🙁

1) Federated databases, where you have data spread across different physical servers, was NEVER a fully functional and useful thing in SQL Server. If you need to be able...

LutzM (5/15/2011)

---

Like I said before: I recommend to get a consultant in for a day or two. It'll be much more efficient than using a forum. Based on the information...

There are a number of causes for what you are seeing. If you need to QUICKLY get this resolved, find a good performance tuning consultant and get them on...

Jeff Moden (5/15/2011)

---

Unless you count the fact that there is no split function, no function to generate sequential numbers...

That is the third time in a week I have seen this CRITICAL flaw in trigger code. Scary how common this is...