jocampo (11/9/2009)

---

Everything inside MS-SQL cache, should and must be actual execution plans or not? if s there, means it ran or it is running now. Or ... did someone change...

Lots of joins, grouping, and aggregates?

Sounds like indexed views territory.

I look forward to seeing the execution plans too.

jocampo (11/9/2009)

---

The recompile option will force SQL to forget about the query plan and generates a new one each time the store procedure is gonna run. How that can improve...

Another way...

SELECT

[user_name] = USER_NAME(CAST(OBJECTPROPERTYEX(T.[object_id], 'OwnerId') AS INTEGER)),

[name]

FROM

sys.tables T

ORDER BY

...

http://msdn.microsoft.com/en-us/library/system.io.directory.getdirectories.aspx

Guys,

There's a huge clue right there...

Grant,

86? :w00t:

Paul

TheSQLGuru (11/9/2009)

---

You can determine this by set statistics IO on and running a single-row-hit select on the indexed column (that doesn't have to hit the base table). whatever you...

ramadesai108 (11/9/2009)

---

Thanks Paul and Gail for taking time. In this case what I will have to do is to insert the records into a temp table and thru a cursor...

Good to see you back!

No worries. 'NOTHING' is good - be double sure it was listed as that for the database in question thoiugh. Under some circumstances, two log backups are required...

While we're all chipping in with tips and tricks...

If you only expect to update one row, say so: UPDATE TOP (1)

Yes, wrapping things in a transaction and rolling back as...

SET TRANSACTION ISOLATION LEVEL READ COMMITTED; -- Default

BEGIN TRANSACTION;

INSERT dbo.Table1 (A, B)

SELECT 1, 2

WHERE NOT EXISTS (SELECT * FROM dbo.Table1 WITH (UPDLOCK) WHERE A=1 AND B=2);

IF @@ROWCOUNT = 0

BEGIN

UPDATE ......

gdraghetti (11/9/2009)

---

I need to write a trigger to write in a table the LogonId of windows user responsible for a SQL operation.

(Note that LogonId is the same value returned, for...

Absolutely. ...