Yes, Enterprise Edition only

http://technet.microsoft.com/en-us/library/cc645993.aspx#Scalability

Typically when you do this, you want to build a date for today. Keep in mind that 20140328 is 1200am, midnight last night. 11:59pm is the last part of the...

Trace is easy. Start Profiler, pick the options you want and then save as a trace script file. Then execute that on the server to run trace.

Not likely. If you are deleting data, the clustered index needs to reflect that.

Good luck and hope it works out well.

I managed some DB2 people years ago and I found it to be more work and more cumbersome than SQL Server, but a...

First, don't use NOLOCK. It's a poor practice.

Second, an index scan occurs when the query optimizer thinks that this is the fastest way to find data. Without an index that...

Apologies and hope things are working for you.

Are you trying to get everything not equal to today in terms of the date?

It's a little confusing what you're saying.

If today is 20140328 and I have this data:

ActiveFromDate

--------------------

20140301 14:45

20140327...

You have six months, Santa

What am I?

semantics. They're both the same thing. Most of...

Fair points, but typically those are larger scale results that affect many people, not a single DBA....

8GB is tough, but it depends on what you run. I have a VM that really needs 6-8GB to run well, so I went with a larger machine that got...

quackhandle1975 (3/27/2014)

Can I ask you what memory make/type...

For your Thur entertainment: http://www.red-gate.com/products/dba/dba-bundle/entrypage/about-the-dba-team?utm_source=ssc&utm_medium=displayad&utm_campaign=sqldbabundle&utm_term=steve_video