A lot of the advise here is appropriate for a production database (don't shrink the files, etc.) where the goal is to preserve restore history and optimize performance.

However,...

ranganathleo (11/29/2012)

---

Have been asked by a customer to reduce the database size to latest 10% of its data. Not sure how to achieve this. Any help regarding this would be...

When we submit change orders...

If an application is loosely coupled (if the term is appropriate here) with the database using stored procedures, web services, and meta-data configuration, then even significant changes to the database...

David.Poole (11/21/2012)

---

Anyone have a view...

SQL Server has actually had NoSQL data storage and analysis products bundled with it for over a decade. Take for example, Analysis Services. People don't generally think about OLAP products...

poratips (11/13/2012)

---

Hi,

I have few more questions too.

I have also few Databases coming from one DB server and other one DB coming from other DB server so I will...

poratips (11/13/2012)

---

I will be building brand new test enviornments ans need to restrict user for security purpose so need to create Group for each Role

anad assign user to each Role...

Practically all of the really large databases I've worked with in the past could have benefitted from better normalization and data type usage. For the most part, I think that...

poratips (11/6/2012)

---

Thanks So much.

I have another situation that my developer wants some tables from Prodction DB server to their desktop m/c.

We have already sql express installed and Database and tables...

Eric M Russell (11/7/2012)

---

When it comes to data quality in large enterprise organizations, what's essential is that the rules be formally documented (before development begins).

For example:

- If Col1 = 'A'...

When it comes to data quality in large enterprise organizations, what's essential is that the rules be formally documented (before development begins).

For example:

- If Col1 = 'A' then Col2 must...

Here is what I've done in the past for supplying complex multi-values parameters to a reporting stored procedure.

The user specifies various options for ad-hoc reporting into a form. The...

CELKO (8/12/2010)

---

jhood (8/10/2010)

---

I see what you are saying Jeff, but would you want to do validation if the application did not allow the end user to send invalid data? perhaps...

haiao2000 (10/29/2012)

---

Eric M Russell (10/29/2012)

---

Instead of calling the job explicitly, you could have a job that runs every five minutes or so, polls a table to see if any works...