ColdCoffee (5/18/2012)

---

Suresh B. (5/18/2012)

---

Prasad.N (5/18/2012)

---

hi all,

i have doubt regarding select statement, i have one table with 46 columns , i want select only 42 columns.but iam not like to write...

Prasad.N (5/18/2012)

---

hi all,

i have doubt regarding select statement, i have one table with 46 columns , i want select only 42 columns.but iam not like to write

select col1,col2...........col42 from...

There a pre-requisite. Go to SQL Agent properties Alert System tab and enable "Replace tokens...

I guess your name is not in the DL (distribution list)

The issue is the login 'DOMAIN\Login' has granted one or more permission(s) to some other login.

Run this query for more details:

select * from sys.server_permissions

where grantor_principal_id =

(select principal_id from sys.server_principals where...

The order in which data is stored is not important.

While SELECTing you have to specify ORDER BY clause and retrieve the data in the required order.

Try this:

select ItemID from reportserver..catalog

where name = 'Your Report Name'

select top 10 * from reportserver..ExecutionLogStorage

where ReportId = '86501BA5-5343-4669-A54E-F6A129E02BA5'

and Status <> 'rsSuccess'

order by TimeStart desc

By rebuild has no effect, do you mean fragmentation is still there?

How big is your table (in pages)?

Is it a heap?

Answer:

1) Yes, you can...

No. Not execution plan. Use Profiler as suggested by Gail.

GilaMonster (5/12/2012)...My preferred way is to run both queries multiple times (10...

sysprocess is the old method. DMV is the better and recommended method.

Using DMVs it is possible detect blocking sessions with the application name, user name, host name, IP, SQL...

DMVs such as sys.dm_exec_requests, sys.dm_tran_locks are the right tools for tracing blocking issues.

But how will you fix it? Better to report this to your ERP and CRM application vendors.

Just moving the data to a different SAN should not impact replication.

Stopping the SQL Server should be enough for it to pick up where it left off.

Remember that replication has...

What is "temporary log information"?

Never heard of it.

differences between seek and scan in sql server