Viewing 15 posts - 42,811 through 42,825 (of 49,552 total)
The error message would be really useful in trying to help you. Can you post it please?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 29, 2008 at 4:11 am
The Best practice advisor has given you recommendations. Are you looking for a second opinion, independent confirmation, or something else?
Recommandation: Apply the latest cumulative update package or cumulative update package...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 29, 2008 at 4:10 am
Asked and answered
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=115347
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 29, 2008 at 4:08 am
Jeff Moden (11/28/2008)
BWAAA-HAAA! New candidate for the Pork Chop Award... look at the question and then look at the certs this guy boasts in his signature...
Though, if you look,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 29, 2008 at 4:01 am
Oksana March (11/29/2008)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 29, 2008 at 3:38 am
Adi Cohn (11/28/2008)
Might be wrong here but it seems that those 2 statements caused the deadlock:UPDATE SS.SECTIONS WITH(ROWLOCK) SET SECTNO=160 WHERE ROOMNO=401
UPDATE SS.SECTIONS WITH(ROWLOCK) SET SECTNO=101 WHERE ROOMNO=601
If you look...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 28, 2008 at 2:29 pm
From what I can see, this is what happened.
spid 60, running from Microsoft SQL Server 2005 JDBC Driver in a user-defined transaction takes out an exclusive lock on the table...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 28, 2008 at 2:15 pm
How fast is data changing in that table? What's the table schema?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 28, 2008 at 1:54 pm
Don't use the profiler gui at all. Use profiler only to create a script. The profiler gui doesn't directly write to a file. It pulls the trace events into memory...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 28, 2008 at 1:52 pm
Lee From Bangalore (11/28/2008)
I need exact what will stored in LDF and its purpose?
The ldf is the log of all changes that are made to the database. A change has...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 28, 2008 at 1:42 pm
Here's another
SELECT e.EmployeeID,
e.FirstName + ' ' + e.LastName AS Employee,
s.FirstName + ' ' + s.LastName as Supervisor,
e.SiteID,
...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 28, 2008 at 1:07 pm
rbarryyoung (11/28/2008)
(see Phil Factor's excellent description of these dangerous mimics here).
Where? Link goes to Phil's list of articles. Not sure which one you're referring to.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 28, 2008 at 12:57 pm
herbiechin (11/28/2008)
You don't and as far as I am aware, the backup will happen disregard if any error/corruption were found in the database. Not sure if there is an easy...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 28, 2008 at 12:56 pm
barb.wendling (11/28/2008)
I am writing the data to a remote server, not the server having the sluggish performance.
Don't! The trace should write to a fast local drive on the server that...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 28, 2008 at 12:44 pm
Oksana March (11/28/2008)
I am surprise to so negative reaction to the question of Venkat.
It wasn't so much what he asked, as how he asked it and how he responded...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 28, 2008 at 12:30 pm
Viewing 15 posts - 42,811 through 42,825 (of 49,552 total)