I use this stuff:

http://vyaskn.tripod.com/server_side_tracing_in_sql_server.htm

Nope, and I believe it will...

Executable code rather than screenshots would be much more useful too.

sqlbuddy123 (9/17/2010)

---

Fill Factor of an index indicates 'how much percent of a page SQL Server can Fill'. For example, if the Fill Factor is 100% then SQL Server will fill...

You can do this in SQL, but SQL is not designed to produce this sort of output (lots of reasons, interesting if you like relational theory) and the code can...

Lowell (9/17/2010)

---

So if there are no joins to other tables, then the clustered index provides SQL with the fastest way to get the data...and thus would determine be the...

Out of curiosity, why do you expect Gail to write something off the cuff that would be better than the articles she referenced? She is very good (I know her...

IF LEN(@string) - LEN(REPLACE(@string, '*', '')) >= 2

BEGIN

RETURN LEN(@string) - CHARINDEX('*', REVERSE(@string)) + 1

END

It is the SQL Server Bitwise OR operator.

http://msdn.microsoft.com/en-us/library/ms176122.aspx

And here it is. Nasty, eh?

SELECT TOP 6

the_output = CASE

...

How come you don't want to use UNION? It is possible to write a query that does this as a set without UNION but it is very contorted.

Is a variable...

By a complete coincidence the next thing I read after posting was this:

http://blogs.msdn.com/b/craigfr/archive/2006/07/26/679319.aspx

Nested loops don't support ROJs. So there's a reason right there not to use them.

I only ever use left outer joins, never right.

The only exception I know of that I might use a right outer join (and this is theoretical only, I've never...

I don't about the specifics of your scenario, but in general terms set based is superior to a cursor for this: SELECT score ...

I agree with Steve - I'm not sure you have paid full attention to the SQL in the article. He is not suggesting removing order by, but creating indexes to...