Which is exactly the order my query returns them in. Did you try it?

Bear in mind that datetimes are just that. Dates and Times.

If a user passes 2008/08/18 to your procedure,...

Smalldatetimes have full day, month, year and time included in them. When you pass 2008 to the procedure, it gets interpreted as '2008-01-01 00:00', and so when you do the...

They are sorted, they're just sorted as strings which is what the column is by the point the order by is evaluated. Perhaps something like this:

Select CAST(CAST(BaseColumn*100 AS numeric(10,2)) AS...

SQL Server always uses the transaction log, and the recovery model doesn't change how much is logged (except for bulk operations). What the recovery model changes is how long the...

The cache refreshes automatically from time to time. I have no idea how often. I'll do some investigation and see if I can work it out.

If you go in to the properies of the job step and go to the second tab, there's an option to write out the job's output to a file. If...

You're not the first to think of this. 🙂

http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=331220

http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=351043

There's some underlying network problem that's preventing the principle from seeing the mirror and vis versa. Before you can fail back, you are going to have to fix the connectivity...

Dunno about configuring, but you can update the intellisense cache to include new objects. Ctr-Shift-R (or Edit->Intellisense->Refresh Local Cache)

Do all of the instances use the same service account? What accounts have the lock pages priviledge?

I would suggest you reduce the max memory for some of the instances. With...

Could you please post table creation scripts, sample data and expected output?

See - http://www.sqlservercentral.com/articles/Best+Practices/61537/

You could start with Books Online (the SQL 'help' file). There's a lot of info in there on the architecture of SQL Server. If you have questions after reading through...

Duplicate post.

Direct replies to the following thread please: http://www.sqlservercentral.com/Forums/Topic558664-146-1.aspx

Can you explain in more detail what you're trying to do? I'm sure someone will come up with a non-cursor approach.