From Books Online:

Security

In Windows Authentication mode, the user account that runs SQL Server Profiler must have permission to connect to an instance of SQL Server.

To perform tracing with SQL Server...

Bhuvnesh (9/22/2010)

No , view has same exec plan as it has for inner incorporated query.sql optmizer treats both view and query same while analyzing...

GilaMonster (9/22/2010)

I have this one hanging above mine (at home)

http://www.despair.com/despair.html

I bought this one for...

Ha! I have that hanging at my desk.

Chris Morris-439714 (9/22/2010)

Alvin Ramard (9/21/2010)

A query walks into a bar, sees two tables and...

GilaMonster (9/21/2010)

One of the editors? The only editor here is Steve. The rest of us...

I guess it depends on what's being looked for. The Default Trace doesn't store DML,...

Do you mean you want to know what database was most recently queried from (or to)?

In that case, you could do something like this:

SELECT TOP 10

...

If you supply a value through OPTIMIZE FOR, it's going to use that value. It won't help it arrive at a better plan, just the one that it can arrive...

You can use DMV's, or server side traces and Gail's articles are a great place to start. If you're running 2008 you can also look at using the Data Collection...

You can backup out to a UNC path, but, it's usually not a good idea because then you're dependent on the network to handle the backup and that can sometimes...

The LIKE statement with a % in the front of the string will result in table or index scans, no options. That is likely why things are running slowly.

I'll take the field. Probably a sucker bet, but...

I'm not aware of anyone specifically consulting on this issue, but there is a book available that might help you narrow down your options if you're feeling overwhelmed.

I agree with Jack.

But to talk about option 2 for a minute (becuase there will be times you have to go that way), simply adding the nullable column will not...