Thanks for replies

I am using workgroup

I did run this query on server

SELECT session_id AS SessionID,

wait_duration_ms AS Wait_Time_In_Milliseconds,

resource_description AS Type_of_Allocation_Contention

FROM sys.dm_os_waiting_tasks

WHERE wait_type LIKE 'PAGELATCH_%'

AND (resource_description LIKE '2:%:1'

OR resource_description LIKE '2:%:2'

OR resource_description LIKE '2:%:3')

I got no rows....

GilaMonster (4/6/2013)

---

Monitor for allocation contention. That's all that multiple files and traceflag 1118 are for, if you don't have allocation contention then there's no point in adding the traceflag.

Ed's right,...

actually i needed the way to check performance after creating 2 tempdb files or 4 temp db files to know which is efficient..please suggest me way to check it..

TheSQLGuru (3/27/2013)

---

There are at least 2 things you should do before even considering that trace flag.

1) look for unnecessary temp object creations. There could be lots of...

e4d4 (4/2/2013)

---

winmansoft (4/2/2013)

---

Just interested to know some details about encryption. If i have admin access to the sql server then i can access anything in it,even databases which are encrypted...

I got answer for my own question

To skip the reboot check:

SkipRules=RebootRequiredCheck

To hide the console window(which is shown in image in the post above):

use /HIDECONSOLE in command line ot HIDECONSOLE="True" in...

Will suggested query work for MS access database?

Thanks for replies

I think we will use identity property only

anthony.green (3/26/2013)

---

As your not incrementing @root your inserting the same value every time.

You would want to row_number the table then add the max ID value to it so that it...

No not yet. I want to know if it has disadvantages before enabling

Thanks for reply

"SELECT [DBChanges].* FROM [Checklists].dbo.[DBChanges] WHERE [Permited_by].exist('/Root/Row/User/.[fn:upper-case(.)= ("SHW","SKT","PRS")]')>0" will work very well

But then I thought i should use IN in query.After searching sometimes i found this query

select *

from...

Hi Lowel..

You are correct. Everyone looks for an easy method. Now in my case i should give admin for almost all databases and restrict for only some tables in few...

Hi Lowell

Thank you for replying. Your method of giving permissions to tables works fine.But if in server roles if i set sysadmin(I did it in SSMS) for that user then...