sehgalnamit (7/31/2013)

---

Can you suggest me a tool for User administration like create user, assgn roles, permmissions for sql server.

My goal is to assign these activites to my level 1 team...

some of the best material you can use for training for the exams is not in a book per se. You would be amazed at how much more prepared...

:-D:hehe:

Please provide the actual execution plan with this query so we can offer better advice.

select *

from tempdb.sys.objects

that will list all of the objects in tempdb.

If you have restarted sql server since creating those tables then those tables are gone now.

You would...

Here is an article that can help you find those growths

http://www.sqlservercentral.com/articles/Log+growth/69476/

Thanks Steve

If you restored a backup over the database without having performed a backup to save that important data, you have lost the data.

This might be of use for you.

http://technet.microsoft.com/en-us/library/ms345359(v=sql.100).aspx

do you currently have copies of your system databases in multiple locations?

Grant Fritchey (7/30/2013)

---

SQLRNNR (7/30/2013)

---

Koen Verbeeck (7/30/2013)

---

SQLRNNR (7/29/2013)

---

L' Eomot Inversé (7/29/2013)

---

WayneS (7/29/2013)

---

Just curious - how many like that new tile look on the home page?

FWIW: I prefer the older images over...

Erland Sommarskog (7/30/2013)

---

DesmoShane (7/30/2013)

---

You say that the view is created in tempdb and it can have a heavy impact ,so each time the view is accessed how is the view...

Ventilate

L' Eomot Inversé (7/30/2013)

---

SQLRNNR (7/29/2013)

---

Jeff Moden (7/29/2013)

---

I just took a look at the home page for the first time this morning. Why in the hell do people think that...