Select * from table where column like '%word%'

The DBV's offer a wealth of insight, more than is available to discuss here. I suggest you take some time.

Here is a complete list of DMVs, you would do...

Data and backup compression eleviate space concerns on the servers. Policy management provides an easy way to determine is a server is compliant with organizational policies. On the...

Access would probably pay no more than 60% of what SQL pays. Myself, and many DBA's like me would not consider Access to be a database and a person...

Tom.Thomson (8/1/2011)

---

Kenneth Fisher-475792 (7/29/2011)

---

Same goes for 1 processor working. Technically I should have said "RTM installs fail on an odd number of logical or physical processers, unless its a...

Meet George Jetson (7/29/2011)

---

Not to nitpick, but even the article referenced stated - "On a computer that has a multicore processor, you may be unable to install SQL Server 2005"

The...

This has bit me numerous times (including last week), now I make a habbit of changing the boot.ini file to one processor before all SQL 2005 installs on machine with...

two year old thread, but one of only 5 hit's in google.

I found it in profiler, thanks

It is activity monitor, for the wait resources. However, does anyone know what goes into the SP #am_generate_waitstats?

I only get a couple of hits on Google for the SP...

There is included an option for a full rescan if update stats is a selected option

An interesting note, I just found this error. I will look at how to address it.

Msg 2725, Level 16, State 2, Line 1

An online operation cannot be performed for...

That was it, when I dud down into the data pump, I found that the person set it up with an Active-X script to verify the existance of the file....

Props on the STUFF, in 12 years of doing SQL, that's the first time I have ever seen...

MeltonDBA (5/7/2010)

---

Use GMAIL. you will just need to create an account. Their outgoing server requires user authentication so you'll need the account. You can forward to any...

Bron Tamulis (5/7/2010)

---

Okay - I am an independent consultant that uses a hotmail account for my email purposes. I read where in SQL2005 you do not need an outlook/MAPI account...