I would love to see from you

How to become an MVP?

How to Prepare for MCM?

Do Microsoft recongnizes at some point if we are active or do we have to apply or register some where?

Like me many of the people don't know about this information(B'coz I asked so many people about this),

if you post in this thread that will be help to people...

you can do it that way. no problem

But is better know

Do you really need to do Integrity check every week , what if you can do for a month?---Depends...

Even if is clustered or not if you restart the server the services should...

yes, there is security control over the linked servers at both from where you are accessing and the remote server

If you right click on the properties of the linkedserver...

Thanks

That is what I expected too..but I was asked to tune this query .ha.haa.What to do ?

If you are using backup with compression then yes, when you started the backup the backup file shows you the actual size of the database but on its completion it...

I don't...

Can you be more descriptive...

Check out the default trace [/url]for that particular peak time to find what exactly are running on server.

2. Check if there is open transaction that running long DBCC Opentran

3....

GSquared (8/1/2011)

---

Regularly shrinking the database files is usually just a good way to slow the whole server down. It causes file fragmentation, locks during auto-growth, and a host of...

sqlbee19 (8/1/2011)

---

1)

Lately I noticed our company developers are hampering the tempdb and every time they run process it is going up to 200 GB which is causing drives out of...

sravnmaganti (8/1/2011)

---

hi need to assign this value DATEADD(S,-59, DATEADD(s,-1,DATEADD(M,1, DATEADD(D, 1 - DATEPART(D, GETDATE()), DATEDIFF(D, 0, GETDATE())))) ) to the parameter in execute sql task...