Each primary key and each unique constraints are implemented with unique index. This is done for performance. Imagine that you have a table that has more then 10000000...

baabhu (3/16/2012)

---

The database will not shrink well beyond its initial file size created. if the database is created with 200 GB initially. And later on you have 150 GB free...

From what I see each record is unique, which brings up the question – how do you decide which records are unique and which records are not unique?

Adi

You can use profiler or server side trace to get the data when it runs.

Adi

You can use the default trace to find out about file growth. Bellow there is a code, that I've once found on the net (sorry, I just don't remember...

Money data type is working with 4 digits after the decimal point. If this is not enough for you, you should use a different data type.

Adi

You can have join clause on an update statement. BOL (Books On Line) has an article about it with example. Look for the article that is called "Changing...

I have to admit that I don’t understand why both queries use the same path in nodes method, but different path in value method. I would have thought that...

Users that don't have permissions to work with the view, won't be able to see the columns from sys.all_collumns, but if you can see it in sys.all_objects, you do have...

Do you know what went wrong and why you didn't get the expected results? In my opinion your query should have shown the columns of the...

Most chances are that the line and a.name like '%_vv%' is the one that filters your results. What is the name of the view that you are trying to...

I never use percentage for autogrow. I only use whole numbers. Most of the times I use something between 200MB and 500MB, depending on what I think...

One way of doing it is to use a recursive CTE that creates the list of dates and use the CTE in select into statement. Here is an example:

declare...

The quoted_identifier set option of a procedure is set during the time that it is created and not according to the session that uses the procedure. If what you...

Any reason that TDE is not...