If scripting your objects a particular way is really that important to you, I guess you can check to see what scripting options are available to you with the smo...

Nevertheless, it's a term I've seen used by some authors to explain the concepts of Indexes.

I guess only the OP knows...

I can only imagine a writer using the term "secondary indexes" to refer to any indexes other than one on a Primary Key? In that case, such indexes are...

This does kinda look like homework.

Look up Row_Number in BOL. It should go some ways to resolving your problem.

Sorry to possibly add to your troubles but you may have more than one problem with your View.

The "Select Top 100 Percent" method was commonly used in previous versions of...

In some ways, your question is outside the scope of the Sql Forums here and you will be better off posing

the question "How can I call a sql stored...

You can always download a trial version of Sql 2012 and check it out before you commit money to a developer edition. It ran for 180 days, last time I...

This maybe:

SELECT PARSENAME(REPLACE('HEYE-B RFE-IPA 70940',' ','.'),2);

The problem with the "why is my server running slow" question is that it could just be way too many things.

Some suggestions have already been made such as statistics, blocking,...

WolfgangE (11/30/2012)

---

This really sounds familiar to me 😀

WolfgangE (11/30/2012)

---

I know this behaviour and I think it's a little bit strange. It seems the identity insert can only be set to...

http://msdn.microsoft.com/en-us/library/ms187016.aspx

There may, of course, be specific reasons for your choice though do bear in mind that...

A Differential...

Abu Dina (10/26/2012)

---

Good morning,

I thought that the only way to create a differential backup is to have a FULL backup exist in the first place. But I have a database...

There's nothing wrong with Oracle... It's an RDBMS as any other 🙂