OK, I definitely missed out. Need to go watch this on the PASS site.

Or other issues.

Sorry for the delay

http://www.sqlservercentral.com/articles/Editorial/64933/

To become and expert, you need experience. You need to do things and work on them.

You might be able to get experience at some place like Rent-a-coder, or volunteer for...

What you might want to do is build a table that includes this logic somehow, header before sub, etc. and then use that to join with this and order things...

If you have an exact match query, you use a nonclustered index that includes that column. If it makes sense, which is dependent on percentage of queries, space, etc., you...

Do you know how to write a trigger?

If you do, then an audit trigger just inserts changed data into some table. There are articles here on the site (search audit)...

Is this a named instance? If so, you connect to the browser service on 1433 and it lets you know which port the named instance is on. You need to...

That's strange. You should have had issues with this in 2000 as well.

I haven't specifically seen this, but I suspect that loopholes that might not have been well enforced...

Why not schedule the package and then take that command line?

Does this help?

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

It sounds like memory to me as well.

84k lines? How useful a report can that be. It would seem to me that it's been designed inappropriately in the first place....

Actually you roll on your shoulder, no neck involved. You learn early to tuck and I've never had neck issues, and I HAVE neck issues.

What typically happens is when someone...

ORDER BY gets you ordering.

SUM() gets you a sum.

the WHERE clause can filter things for you.

We'd be happy to help, but we'd like to see more info, as mentioned above,...

you should be able to use a trigger to log this information and the data should be available in there.

However, be sure you log the encrypted text or you...

I think the nomenclature here is confusing people.

The database is the schema+data+physical files. You wouldn't put this into VCS. You would put in the scripts to recreate the schema and...