muthukkumaran Kaliyamoorthy

Forum Replies Created

Viewing 15 posts - 226 through 240 (of 860 total)

RE: Regarding comparing Indexes

MsSqlNew (9/23/2011)
Thanks For responding moorthy,
I tried it but it is not showing correct results..Are you sure that it works...?
I just showed the way. You may modify it as you want.

September 23, 2011 at 5:35 am

#1385628
RE: Regarding comparing Indexes

MsSqlNew (9/22/2011)
can someone help me in comparing the indexes from two database. I have a db Adventureworks, i migrated some table and data(some records from all the tables) to a...

September 23, 2011 at 1:17 am

#1385548
RE: sql server memory leak.

dm_tapas (9/22/2011)
See, My question is why SQL Server is using 21 GB of memory? Server looks fine .. but , memory consumption is too high.
Tell me : How...

September 23, 2011 at 12:38 am

#1385540
RE: How to resolve deadlock for MSSQL 2008

nhphuong76 (9/21/2011)
I ran the script "DBCC TRACEON(1222,-1)" but deadlock still appear
Can resolve finish ?
This trace flag will not resolve the deadlock prob. It'll write a graph in your error log....

September 21, 2011 at 2:51 am

#1384367
RE: Logshipping

http://msdn.microsoft.com/en-us/library/ms187103.aspx

September 21, 2011 at 1:52 am

#1384352
RE: My day is bad today.

crazy4sql (9/15/2011)
no matter the number of reply you will get here......if you not going to learn today then many more bad days are coming
Liked this.

September 15, 2011 at 7:45 am

#1381964
RE: Need unused indexes stats

I suspect that you are too busy to have had any opportunity to read any of the numerous blog posts on this subject that litter the internet.
:laugh:

September 13, 2011 at 10:49 am

#1380819
RE: Need unused indexes stats

espanolanthony (9/13/2011)
If I knew I would not have posted here. I would very much appreciate if someone shed some light on it please.
Have a look :
http://www.google.co.in/#sclient=psy-ab&hl=en&safe=active&source=hp&q=sql+server+Need+unused+indexes+stats&pbx=1&oq=sql+server+Need+unused+indexes+stats&aq=f&aqi=&aql=&gs_sm=e&gs_upl=7562l10421l1l11702l4l4l2l0l0l0l312l469l0.1.0.1l2l0&bav=on.2,or.r_gc.r_pw.&fp=5c559f15b00493e1&biw=1024&bih=537

September 13, 2011 at 7:56 am

#1380649
RE: Need unused indexes stats

espanolanthony (9/13/2011)
Hi,
I use SQL Server 2005 and SQL 2008 and I need a script that will tell you which indexes are not at all used on a table level...

September 13, 2011 at 7:45 am

#1380633
RE: Issue with Database Mail

(: Hakuna Matata 🙂 (9/7/2011)
Hi,
I have scheduled multiple jobs using Database Mail on our production server. From 2nd of September we have not received any mails. I did check the...

September 7, 2011 at 3:18 am

#1377846
RE: Backup compression

vino5786 (9/7/2011)
Hi Friends,
Just wondering how do we uncompress the backup taken with "WITH COMPRESSION " option in SQL Server 2008
Also how do we restore the compressed full backup to...

September 7, 2011 at 2:45 am

#1377837
RE: Database Maintenance Jobs Fail

dm_tapas (9/7/2011)
I got this message in Database mail log
Message
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2011-09-07T12:30:14). Exception...

September 7, 2011 at 2:25 am

#1377830
RE: DR type

It's nearly 1 year old thread.

September 6, 2011 at 9:27 am

#1377505
RE: Database Maintenance Jobs Fail

dm_tapas (9/6/2011)
I have added one extra zero to that. not through T-SQL
and I don't know what is the attachment size.
That was a error message. that has not mentioned about...

September 6, 2011 at 7:29 am

#1377401
RE: Database Maintenance Jobs Fail

dm_tapas (9/6/2011)
I have changed default parameters By Clicking on Database Mail -> Select Configure DB Mail -> Next -> Select the radio button "View or Change System Parameters".
Still it is...

September 6, 2011 at 7:03 am

#1377372

Viewing 15 posts - 226 through 240 (of 860 total)