Don't you have a piggy around? I do.

He's got a very good ear and can give you ideas or fix some bad code, when you can't see...

Simplistically, I like SSC for that.

I force myself to answer the Question of the day everyday. I spend few minutes, sometimes seconds, to find the answer, searching around...

If I'm not mistaken, does this only apply to auto-growth, right?

I like the "mofified". Still have to figure-out how SETSPN can do this.

I never looked at this very deeply but I believe that scheduled report executions (for subscriptions, for example) create a SQL Agent task to program the execution at the specified...

Looks like I found an answer. The documentation shows an example where APPLY is used to provide an argument to a table-function that require a parameter. It looks like it...

I just don't get what to do with this APPLY keyword.

The query can be redone using a LEFT OUTER JOIN, which results in the same output and the same plan.

Is...

That reminds me of a Microsoft Article and Hotfix:

[font="Times New Roman"]Windows Server 2008 R2 cannot be installed or started on a computer that has 1 TB or more of RAM[/font]

Strangely,...

Just for fun if others read this thread:

There is a difference between

[font="Courier New"]SELECT 8[/font]

and

[font="Courier New"]SELECT 8 FROM Table1[/font]

The first query may be what one may expect.

Just in case... don't forget to cleanup after you executed the query. This is not a temporary table.