Yes. It will fail with EXECUTE permission denied on < Procedure name >

If you've granted the user the appropriate execute permissions then the insert will succeed. It's the concept...

sql guy (9/15/2008)

---

they are on the same server and this is what i tried. i am getting a result but its gibberish!! i am just starting off sql so may...

From object explorer, expand out security (under the server), right click, choose new login. Make sure windows authentication is selected. Under login name enter the domain and user name -...

Can you post what you've tried please?

You can monitor the transaction/sec via perfmon (SQL Server: Databases (tempDB)), then you can look a the IO throughput with the sys.dm_io_virtual_file_stats DMV. It's cumulative since SQL last started, so...

Depends highly on the queries. It could be that your indexes aren't covering and that with the number of rows been returned, SQL decided that a scan of the cluster...

Absolutely, because the separate...

The explanation for that counter is:

So it's (cpu time/elapsed time)*100

How...

You could also look at moving the clustered indexes onto columns that don't fragment as fast. It needs a lot of thought and analysis, but may help.

Richard McSharry (9/15/2008)

---

But so many comments I see say that clustering is just a DR solution...which I don't really believe. It is a DR solution, certainly, but surely it is...

Ah. That's reinitialising the backup file, removing (overwriting) any backups that were present in the file before. It's not touching the database's log itself.

Personally I'm not fond of writing multiple...

Just one.

There would probably be only one for the following three queries

Select columns from tables where id = 3

Select columns from tables where id = 7

Select columns from tables...

I still don't understand what you mean by initialising the log. It's not a general SQL term for anything associated with the log. LSNs (Log sequence numbers) are used internally...

SELECT DISTINCT FromLocation, ToLocation FROM ...

will get you all of the unique combinations of the two. Is that what you want, or are you looking for just the values of...

james.easton (9/15/2008)

---

My databases are in FULL recovery mode and I have a Log shipping job running from 8.00am to 19.30 during the day. Then at 8.00pm I have the nightly...