shreekanth.kavali (2/22/2015)

---

you received an alert "disk drive is almost full " for c drive "abc" server .what action will take and what all information you will provide for further action...

Srl832 (2/3/2015)

---

That's what I have been doing right now, but my manager wants me to centralize everything with regular restore jobs in place. I have been asked to come up...

I worked at a place where consultants came up with a design for a high volume OLTP application that would completely replace SQL Server with XML flat files to store...

When you rebuild indexes, it generates a lot of transaction log records.

How often are your transaction log backups running? If you don't run them often enough, the transaction logs...

Luis Cazares (1/27/2015)

---

The primary key is usually the same as the clustered index but that's not a rule. They're both independent as the process to define them is different. The...

Does it have the option of generating and displaying the rebuild or reorg commands without actually executing them? I guess I would call this a preview option. It...

On thing you should not forget it the effort required by developers to change all the applications to point at the new instance name/database name.

Developers and administrators usually are not...

I haven't seen much improvement in compression using third party backup tools compared to the native SQL Server 2008R2 backup compression.

Some of the third party backup tools have features you...

severnj (1/25/2015)

---

Hi,

Thank you all for the help on this. I tried the below listed steps but maybe I am doing something wrong? ...

You will have to re-index before you can shrink the databases, and then again afterwards to remove index fragmentation.

Although there is a lot of space available in the database, is...

This is probably a variation of a Bill of Materials design. There a usually many layers of parts for each sub-assembly, and the same part can occur in many...

Alvin Ramard (1/20/2015)

---

kabaari (1/19/2015)

---

Alvin and Andrew,

Those both achieved my goal. I was having difficulty with querying against a getDate() Inserted value. The time is also captured at insert which had...

You have two impossible combinations in your selection criteria:

MONTH(c.dateentered) >= 11 and (MONTH(c.dateentered) <= 01

DAY(c.dateentered) >= 23 and DAY(c.dateentered) <= 19

It appears you are looking for data from...

As other people have mentioned, convert it to a date or datetime value first, and then convert it back to a string using the CONVERT, date, and string functions.

Here are...

No, there isn't. It's a connection setting, not a database...