You'll need to define an XML...

You can dump it into 1 row as a single blob and then use select for xml to manipulate it.

create table docs (pk int primary key, xcol xml not null)

insert...

i think (not 100% sure) the closest you'll ever come with extended events is using the sqlos.wait with sqlos.cpu_id and sqlos.node_affinity.

below code was not tested:

CREATE EVENT SESSION [Check CPUusage] ON...

You should start reading Paul's article first:

http://technet.microsoft.com/en-us/magazine/2009.01.sql2008.aspx

Then from SSC Extended Events QA:

http://www.sqlservercentral.com/blogs/vinaythakur/2011/12/23/basics-qa-on-extended-event/%5B/url%5D

Then try some examples from SSC:

http://www.sqlservercentral.com/articles/deadlock/65658/%5B/url%5D

BOL:

http://msdn.microsoft.com/en-US/library/bb630355%28v=sql.100%29

http://msdn.microsoft.com/en-US/library/bb677357%28v=sql.100%29

Then download the add-in and create your own.

http://extendedeventmanager.codeplex.com/releases/view/35325

try this http://www.sqlservercentral.com/blogs/robert_davis/2008/08/13/How-do-I-grant-access-permissions-for-SSIS-to-users/%5B/url%5D

on s2 there is more data then on s1 so chances are some kind of an aggregate function in your sp could slow it down.

No i meant your SAN/VM configurations depend on what kind of database system will be running on that VM like OLTP, 3rd party Application databases like payroll or salesforce or...

DONT FORGET ALTER LOGIN [DOMAIN1\USER] with name=[DOMAIN2\USER]

Sergei Zarembo (2/6/2013)

Alex,

By *copying rdl* you really mean...

Can you delete S2 report and copy S1 .rdl file to S2 and relink it to the data source and run it?

Yes there is but of course it all depends on your environment.

VMWARE BEST PRACTICES

Do you realize you're sending the whole tbladmin in your email?

Triggers use inserted and deleted tables and your query is not specifying any of them

select adminname,resposibility1,mailid from customer.dbo.tblAdmin

you should change...

dont forget to use

dateadd(s, 875996580, '1/1/1970') for from_unixtime.

convert_tz function does not exist in sql server so best bet is using aux table or datetimeoffset datatype.

Those little locks just mean that the files have limited access.

for moving system databases follow these steps

http://www.sqlservercentral.com/blogs/basits-sql-server-tips/2012/07/29/how-to-move-master-and-resource-system-databases/%5B/url%5D

Shouldn't be any problems but tested in Dev first.