SUPER SQL STAR (2/22/2011)

---

GOOD MORNING ..MORNING I LEARNED NEW TOPIC THANKS..

The directories for the default data files, log files and backups are stored in the system registry. ...

Hugo,

first of all thanks for your explanation in your...

Koen Verbeeck (2/15/2011)

There are a lot of identifiers and some of them could make actually logic table/column names (I don't say they make good table or column names), such as:

key,...

Thanks for the question--as already stated nice and easy :-).

One word on the distraction, though.

Apparently BOL is not quite consistent in this matter.

While the explanation on QUOTED_IDENTIFIER (http://msdn.microsoft.com/en-us/library/ms174393.aspx) states:

SET QUOTED_IDENTIFIER...

Thanks for the question--had to guess as well :w00t: (and was wrong).

Learned something new.

And thanks to Chris for the additional link.

Regards,

Michael

Thank you very much for this question and scenario--and for the update regarding the sp_change_users_login stored procedure.

Regards,

Michael

The information found on the following blog might be interesting in regards to this VLF question:

http://ochoco.blogspot.com/2009/03/shrinking-transaction-log-files-in-sql.html

Thanks for the QoTD,

Michael

Hello Hugo,

as it's obvious, I haven't had too many chances using variables (except for variables carrying exactly one distinct value)--hence I was under the impression the contents of the variable...

Hugo Kornelis (1/19/2011)

Michael, the reason for this is in the message right above yours. Steve awarded points back to people who had already replid. That means that at that moment,...

Thanks for the question--got it wrong as I missed the indexes on computed columns will not be used.

However, I'm baffled about the statistics, as only 25 % of the responders...

Thanks for the question.

It may sound stupid to the more experienced users, but I don't understand why the following code is not working (using SQL Server 2005; pasted just my...

Thanks for the question, Rahul.

But personally I find the explanation somewhat confusing, specifically the last paragraph where it reads:

It is '*' because when we convert character or binary expressions to...

That depends:

If you install SQL Server running under the SYSTEM (machine) account, it...

UMG Developer (9/29/2010)

---

I think you need to check the answer key for this question. It lists "Column references can pull data from multiple rows." as one of the options you...

Michael Riemer (8/19/2010)

---

Interesting question!

I don't quite see how the first answer doesn't also qualify if the group is within the sequence container? Depending on the nesting you have in...