Your understanding is correct, I think.  As Grant noted, since tables, views, etc., exist only within a database, and not at the instance level, you can't grant permissions to them...

1) You need another table with just ID and NAME.  Repeating the same name in multiple rows is a 1NF violation.

2) The clustering key to this table should be (ID,...

For example, please provide us the table structure in code and sample data in code form, as INSERT statements:

IF OBJECT_ID('tempdb.dbo.#Employee') IS NOT NULL
    DROP...

Yes, I also thought about it, but the following example shows it doesn't matter - SQL Server implicitly converts NULL to the correct type, no?

DECLARE...

It's completely dependent on the indexes. I know Minion lets you pick lists of indexes & break up the process. I suppose Ola's script must too. Do that....

And you never want the log to autogrow during index maintenance because it's such a slow process.

Instead, pre-grow the log to the total size you'll need.  If you really must,...

1. Use a SQL start up proc to create the table.  You could consider a regular table name in tempdb to make sure the table doesn't get dropped even if...

Perhaps a synonym would work for you here.

Why do the created tables have to have the same name?  Presumably it's because some common code needs to run against the tables?  If...

I've never seen a time system that didn't use separate system entries to record check in / check out.  If fact, I don't see how else they could work, for...

Btw, I too would process the rules tables with a cursor to create / generate the final code.  I think a cursor gives you much better control and more flexibility...

I suggest that the results of the dynamic SQL should be to create a view.  Your manager can then SELECT from the view.

Likely the view name would be the same...

I would like your opinion on this solution

First, you really need to go back and do logical modeling, aka normalization, before you create tables (you have a table but it...

• This reply was modified 5 years, 2 months ago by ScottPletcher.
• This reply was modified 5 years, 2 months ago by ScottPletcher.

SELECT 
    path AS original_path,
    LEFT(path, LEN(path) - CHARINDEX('/', REVERSE(path)) + 1) + 'this.bat'
FROM
(
    VALUES ('temp/a/g.txt')
  ...

It's better to put all conditions related to the LEFT table directly in the LEFT JOIN, i.e.:

SELECT
Names.productName
,NameProperty.Value
,NameProperty.Property
FROM Names

LEFT OUTER JOIN NameProperty
ON Names.productName = NameProperty.productName 
AND NameProperty.Property =...

Oracle dbms treats an empty string as NULL.  Don't ask me why, it's totally bogus to me, but it does.