I missed this one too. I was under the impression that SET SHOWPLAN ALL gave you the actual (not estimated) execution plan without executing the query and returning results.

From...

Look up xp_cmdshell in BOL. Be cautious how you implement this as it has security issues.

Well, their perception is that it is the same. They could be doing a great job at parameterization and getting the SQL optimizer to reuse the query plans similar...

You'll get better help if you post your table DDL along with some sample data and your desired results.

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

Make sure you are NOT running profiler on your database server. Run it on a workstation that has SQL Server client tools installed on it. Have you configured...

Thanks for the details Steve. I will not have time to go through your linked material until next week, but I will read it and then re-read your bullet...

I cringe at using EM for backup/restore operations. I always use T-SQL. I have found that many posters have a very low comfort level with using T-SQL for...

Steve,

That is why David wrote the article; so we can have a professional debate on the topic. I for one don't know much about it but I'm being...

Great read David. Your article offers me some comfort for a huge project that I have just been allocated to. Your garage building analogy hits the nail on...

I think it is used as a general term Jeff. In my previous job, I was an application developer for about 6 years. I showed some savvy with...

Ah. So you are only going to use this in a SELECT to diplay the values. I had thought that you were going to create a new column...

What are you trying to accomplish? Storing dates in any other form than a datetime column causes problems down the road.

Since the data is already in the table, it seems a bit much to store it another time but in a different format. How about using a view or...

Also, bracket your database name in the RESTORE DATABASE statement. SQL Server does not like your database name. Use [015] instead.

Darren,

SQL Server reads the original file locations from the header in the backup file and it attempts to restore the database to it's original location. What SQL Server...