Sourav Mukherjee (7/1/2009)

---

Hello SQL Experts

One of my friends had to update the changeid of one user(userid =1000) to 100. But while updating he forgot to include

"begin tran .....

I dont think you can control individual log files. log files are written in a round-robin fashion. when one file gets full, sql server moves to another file for logging...

Right, In Bulk logged mode, bulk logged transactions are minimally logged. all pages which are modified by bulk logged operations are marked. During log backup all extents containing such pages...

yep, they do but in oracle val1 can be used by table1, val1+1 can be used by table2, val1+3 can be used by table3 and so on...

I think he is referring to sequence in oracle which is an object at a database level to generate sequence numbers and is used just like our identity(which is used...

not sequential numbers but may be guid can be used which is unique every time it's generated. but they look weird:w00t:

do you want something like this?

declare @nam varchar(30)

set @nam='pradeep singh'

select left(@nam, charindex(' ',@nam)-1)

select right(@nam, len(@nam)-charindex(' ',@nam))

OUTPUT

------------

------------------------------

pradeep

(1 row(s) affected)

------------------------------

singh

(1 row(s) affected)

These articles should help you out in finding the culprits:

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

I'd got similar issue once and resolved it by changing the authentication mode to windows negotiate.

See if that works for you case.

Thanks Gail for providing deep insight into the issue.

I did go through the article you mentioned and another one

http://www.sqlskills.com/BLOGS/PAUL/post/CHECKDB-From-Every-Angle-Consistency-Checking-Options-for-a-VLDB.aspx

which did provide very useful information on how to reduce...

may be the package tries to backup transaction logs of the databases which are in simple recovery mode...

We use dbspi along with hp openview(OVSD/OVSC) and we do get timely notifications of any issues(which is good enough), however for this one, we didnot get any ticket as the...

and yes, you should also have a login id and password to login to the target server with appropriate rights.:-P

Edit :- Oops, Grant already mentioned abt privilages...:hehe:

Thanks Gail.

Yes, we had discussions with the SAN team and they confirmed there is no such issue at the moment.

I also told them to notify such issues to the database...

Andrew Collins (7/1/2009)

---

I have a client that wishes to restore databases on sql, he owns the data so im ok with that. But what permissions should i give. ...