To be honest, I wouldn't trust some of MS's recommendations. You cannot make a blanket statement as...

Bhuvnesh (9/20/2013)

---

Preethi S Raj (9/20/2013)

---

SQL Server automatically adds the partition column to a secondary nonunique index as an included column if the CREATE INDEX statement does not already contain the...

Preethi S Raj (9/24/2013)

---

My goal is to compare the tree traversal cost

when the column is (a) an included column and (b) the last indexed column in a partition...

No where near enough information to make anything other than a wild guess.

I very seldom use table variables. In functions because that's the only thing allowed, but then I avoid functions as far as possible. Only really useful when the lack of...

The built-in system function POWER. If you're not familiar with it, look it up...

You don't get at the tables. They're hidden system tables, you can't even see them let alone query them. Use the catalog views, that's what they are there for.

If you...

Functions are poor in joins for the same reason they're poor in where. It's non-SARGable and the functions are executed once per row. Horrid combo.

Table variables inhibit parallelism. Put one...

In SQL, ^ is a bitwise exclusive OR. You'll be wanting the POWER function.

SELECT POWER(2,3) -- 8

SELECT POWER(5,2) -- 25

I said it won't necessarily cause slow queries, not that it won't ever cause slow queries, and you really don't need to quote from a book I helped write.

Slow queries...

Please post table definition, index definitions and execution plan as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/. At absolute minimum, we need the execution plan. There's no way to guess query performance without. Those 'indexes...

Configuration information is in sys.configurations.

Logins are in sys.server_principals (sys.syslogins is deprecated, should not be used)

Database users are in sys.database_principals (sys.sysusers is deprecated, should not be used)

Permissions are in sys.server_permissions and...

I'd recommend this be done in the client app, not in SQL. SQL's string handling is very weak compared to what the .net framework has.

Also consider what happens when people...

And now that the paperwork has been signed....

November it's good bye consulting, back to full time grind. Starting at a software development house as a technical lead. Focusing on SQL...

No....