Windows has built-in ability to compress files. 7-z or others may have command line ability too.

You could stop using Comm Vault. Also, are you 100% certain it cannot...

Bunny786 (1/22/2015)

---

Thanks a lot for reply.

SQL Server not Shutting down or not crashing ,We have 15-20 developers to access the 30 TB database,Some of the developers are able to connect...

The ABSOLUTE BEST course of action (by far) is to hire a competent consultant to help you a) tune your hardware, b) fix poor settings (windows, sql server, storage, etc),...

The good news is that you are on SQL 2012 and the new Windowing Function enhancements there will make this quite doable and with good performance. The bad news...

pkapas (1/22/2015)

---

I'm a one man team for the whole company, taking care of System Administration, Database Administration, Development, Networking, Implementations, End-User support, etc. Basically everything IT. A jack of all...

pkapas (1/22/2015)

---

I have a stored procedure that calls several views that rely on each other. In the past these views used to go parallel and use up all 100% of...

DUH!! Copy and paste...

Did you search for help online?? You should do that first before asking for help.

A Google search of these terms:...

Messed up percentages are not uncommon and can pretty much be ignored.

check what account the sqlserver.exe service is logged in under and make sure that account has permission to write to the folder you are trying to back up to.

http://www.red-gate.com/community/books/dynamic-management-views

Meatloaf (1/18/2015)

---

Thanks guys! I have it working in SQL. However, when I try to run it in my .Net app, I get a message saying "Error: Must declare...

Jeff Moden (1/18/2015)

---

Meatloaf (1/18/2015)

---

Is it possible to have an Insert Statement with an IF?

For example I want to check the value of a field upon insert. If the value...

Jeff, that is SOOO over the top!! 😛

Just wanted to make sure I wasn't having a brain cloud!! 🙂