I will try using index.Before that i want to know how can i find the reason for slow running of query.(It may be due to network latency,table in high usage...

Hi Koen Verbeeck and ChrisM@Work

I know that indexing may help in reducing the time required to run the query.

But we want to know for which query is slower and requires...

Thank you hanshi..

By using your query i was able to rewrite my query.

DECLARE @trcfilename VARCHAR(1000);

SELECT @trcfilename = path FROM sys.traces WHERE is_default = 1

SELECT COUNT(*)as no_of_autogrowths,

sum(duration/(1000*60)) as time_in_min,FileName,DatabaseName

FROM ::fn_trace_gettable(@trcfilename, default)

WHERE...

Hi Gail Shaw..

Thank you for clarifying all my doubts.

I am not using differential backup in my environment. i use full backup and transaction log backup.So in this case taking full backup and copy only full backup are...

Yes. I saw that article.

But in my case all database are set to autoclose OFF.

Also the user exist and has sysadmin permission.

Also KB #92574 is for sql server 2005...

error log has so many errors.I filtered only login errors.

06/25/2013 19:04:29,Logon,Unknown,Login failed for user 'user'. Reason: Failed to open the explicitly specified database. [CLIENT: 192.168.1.69]

06/25/2013 19:04:29,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State:...

Password is not changed.Also this error will not come always. Only sometimes it comes,so no particular sequence which can repeat the error.

I got the answer from here.

http://dba.stackexchange.com/questions/45081/xml-queries-with-exist-and-contains-giving-unexpected-results/45085?noredirect=1#45085

Thanks for reply

So i have to update statistics regularly for large tables right?

hi kapil

In the link you have mentioned there i found below queries

DECLARE @tbl TABLE

(

id INT,

col XML

)

INSERT INTO @tbl

VALUES

(1,'<name><name1>5</name1></name>'),(2,'<name>6</name>')

DECLARE @id int

SELECT @id = 6

SELECT ...

Hi Lowell

You are correct.If i select in options then it works.

But there is an exception.If i am using "script entire database and all database objects" while generating script then...

Lynn Pettis (5/3/2013)

---

Your database isn't really that big compared to others. Another choice you could make if you have the maintenace window do it is this:

1. Script the database...

Allow null is allowed for these column. I also checked that for which column this difference comes? For about columns with datatype int NULL was replaced with 0. For another...

In edit option there is no option for it.When i checked there was only 3 options Drop and recreate the destination table,Delete rows in destination table,Enable identity insert. So i...