Gary Varga (3/31/2014)

---

I think that these groups are great as long as their long term task is to make their own existence redundant (even if we believe that this may...

skeleton567 (3/31/2014)

---

Separate minority groups by definition tend to separate further instead of aiding acceptance. Especially in technology, get in there and prove your competency instead of emphasizing differences. ...

betty_bakke (3/29/2014)

---

Hello,

Through a manual solution you can restore data from your corrupted .mdf database. It can be done by executing DBCC CHECKDB and DBCC DBREPAIR statements in MS SQL...

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....