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

The danger in using acronymns like "OMG" and "TTYL" in your business correspondence is that your clients and coworkers will stop taking you seriously and laugh at you behind your...

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 needs to be done,...

In addition to expressions, you can reference user defined functions or non-deterministic functions for a column default.

However, a default can't reference other columns in the table, you would need...

Some these commonly used acronyms (like FUBAR) are vulgar. There is a potential for a text-to-speech or language translation software to sound out the root words literally, which is something...