NM!

http://www.youtube.com/watch?v=RZ4YTg4S7HI&feature=plpp_video

http://www.youtube.com/watch?v=Kcnj5bQghjY&feature=plpp_video

http://www.youtube.com/watch?v=XmE_Utp8CY0&feature=plpp_video

Eswin (12/15/2011)

---

Hi Gail/Ninja's_RGR'us

Im running rebuild index using the maintenance task against the entire databases and not a single index.

from sp_spaceused i get

index_size is 254032088 KB

and each file is having...

It never will free log space unless autoshrink is own (awful idea), or you run shrink. It marks log space as...

MasterDB (12/15/2011)

---

Your database might be in full recovery model,

Try to change your database into simple recovery model with the below query:

Alter database [Your database Name] set recovery simple

and now try...

You need to learn the basics, I can't walk you through all those steps.

I know this series is amazing and you should be able to get on your way.

http://www.sqlservercentral.com/stairway/72382/

Ya and you can always take a backup to another drive or anywhere else on the network for that matter.

Then the shrink will work. Going to simple is realllllllllllly...

In your connection, just point to the correct server and you'll have the correct data.

Yes it can. You just need to separate the logic of monthname & monthvalue.

This code assumes that you always need the same amount of months. This also works...

Not sure what you...

Little pound :

http://sqlblog.com/blogs/andrew_kelly/archive/2009/04/10/how-dirty-are-your-reads.aspx

I think it's time to make our own little version and post it here! 😉

savethytrees (12/14/2011)

---

In the missing index report there is a column called 'user_seeks' from the view sys.dm_db_missing_index_group_stats.

I have seen significant improvement only if the number of user_seeks is also high. Check...

What error does it return?

Why do you do html formatting in a sp? It should be done client side, not server (sql server) side.

Unless there's a version matching your sql install then no.

Helps to know who to trust and there use there names in the SE. 😛