I was reading the Stairway to SQL Server Indexes - Level 4 I believe.

However, I think you may have explained the apparent discrepancy in what I think I'm seeing.

If you...

Yes, I do remember reading that somewhere.

However, this wasn't aluded to in the article I mentioned. In fact, the article showed an example of how using a CLUSTERED key will...

jcb (2/3/2012)

---

If you migrated from a 2005 enviroment maybe something is still missing.

I tryed to set compability level and

Tools > Options > SQL Server Object Explorer > Scripting for...

I see what you mean with regards to using "Master".

Am I correct in thinking that using schemas can be useful because you can grant users access at the schema level...

jcb (2/3/2012)

---

I think the problem lies in:

"Column Finish_Time in object Results contains type Time, which is not supported in the target server version, SQL Server 2005"

Try to install SSMS 2008...

GilaMonster (2/3/2012)

---

Cardinality (in SQL) is used with regards to a query operator in a query. It it simply the measure of how many rows that query operator processes.

So if an...

Thanks for the descriptions.

The schema one was particularly helpful.

I habve used schemas in my own little test DB's for learning purposes, but I think I need to have someone either...

Thanks for the descriptions.

The schema one was particularly helpful.

I habve used schemas in my own little test DB's for learning purposes, but I think I need to have someone either...

Cadavre (2/3/2012)

---

raotor (2/3/2012)

---

Hello,

I am using SQL Server 2008R2 SP1 and have a problem when it comes to getting SSMS to script certain tables.

If I right-click on a table within SSMS...

Hello Derek,

Please do not apologise for your answer. You were kind enough to respond and that's much appreciated.

I do understand what you're saying and realize that perhaps certain books might...

Hi,

Hmmm ... given the examples you've provided, I can see a compelling reason to use the BEGIN/END block to wrap stored procedures in. Personally, I am quite fussy about code...

I think it should've worked now. There should be a .rar format attachment on this post with the Result_1 and Result_2 report files.

I believe I'm pretty up to date as I'm using SS2008R2 SP1.

Did you get the actual attachments?...

John Mitchell-245523 (1/18/2012)

---

You need to use it, for example, if you have a code block longer than one line to be executed (or not executed) in an IF construction. ...

baabhu (1/18/2012)

---

raotor (1/18/2012)

---

Hello,

Just a simple but puzzling question; When I execute the following T-SQL the @MaxLen variable appears to hold the desired value, but when used within the LEFT clause...