Hi Yin,

Start a new trace for SP:Completed. Select ApplicationName, HostName, LoginName, ObjectName, StartTime, and TextData. Filter based on your criteria, i.e. stored procedures, database name, and/or login names....

I think the obvious question here is: why are you selecting the same column more than one time?

That aside, you're getting the error because you're ordering by the duplicate column....

Thank you for sharing the results! I think it'd be great if more people did that... it would make the forum a better resource for people who may have...

I'd probably start with CPU and duration. Happy profiling! 🙂

Silly question, but does your variable data type match col2? Are you using CHECK constraints?

It'd be helpful if you could post a code sample of your table and view.

Is it possible to just add another column to the table with the value you want displayed? Or perhaps create another table and perform a join in your view?

Maybe this can help you, too...

Select p.name As 'publication'

, p.description

, s.srvname As 'subscriber'

, s.dest_db As 'suscriber_db'

...

Hi there! I have a script that will answer your latency question. You can find that here:

http://sqlfool.com/2008/11/checking-replication-latency-with-t-sql/[/url]

HTH!

Hi there! In general, the answer is "yes," but it really depends on what options you specified during your index rebuild. Can you post a sample of your...

Christopher is correct. Add your partitioning key, always. Without the partitioning key, the query will basically end up scanning all partitions (unless you have a non-partitioned index).

If you're...

To the best of my knowledge, no, the query optimizer does not take into account index fragmentation when determining the best query plan available.

Good question. 🙂

Here's a...

The partitioning key must be included in the primary key on a partitioned table. Try using something like this:

Alter Table dbo.yourTableName

Add Constraint PK_yourTableName

...

Without understanding your database, I can only give you generalities.

- Take the process one step at a time. Filter your data as much as possible, and eliminate...

Okay, I understand what you're trying to do... what's your question?

There's a couple of different ways you can handle this. Here's one way:

WITH myCTE

AS

(

SELECT empid

...