adb2303 (8/2/2013)

---

Each differential will be all the changes since the last full backup, i.e. they're not incremental. They can get quite big if not managed properly - even bigger...

Erland Sommarskog (8/2/2013)

---

The most important thing is that you and your team understands the recovery procedures, so that in case of a disaster you can meet your RPO and RTO....

ChrisM@Work (7/26/2013)

---

IT researcher (7/26/2013)

---

ChrisM@Work (7/23/2013)

---

-- why cast [Phone no] AS VARCHAR(MAX)?

-- why use CHARINDEX? You don't need the character position, you only need to know if

-- one string...

ChrisM@Work (7/26/2013)

---

IT researcher (7/26/2013)

---

ChrisM@Work (7/23/2013)

---

-- why cast [Phone no] AS VARCHAR(MAX)?

-- why use CHARINDEX? You don't need the character position, you only need to know if

-- one string...

ChrisM@Work (7/26/2013)

---

IT researcher (7/26/2013)

---

ChrisM@Work (7/23/2013)

---

-- why cast [Phone no] AS VARCHAR(MAX)?

-- why use CHARINDEX? You don't need the character position, you only need to know if

-- one string...

ChrisM@Work (7/23/2013)

---

-- why cast [Phone no] AS VARCHAR(MAX)?

-- why use CHARINDEX? You don't need the character position, you only need to know if

-- one string exists inside the other.

SELECT...

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