Viewing 15 posts - 42,826 through 42,840 (of 49,566 total)
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...
November 29, 2008 at 4:10 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,...
November 29, 2008 at 4:01 am
Oksana March (11/29/2008)
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...
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...
November 28, 2008 at 2:15 pm
How fast is data changing in that table? What's the table schema?
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...
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...
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,
...
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.
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...
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...
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...
November 28, 2008 at 12:30 pm
It could be anything. That's almost the database equivalent of asking "Why's my car making a strange noise?"
Probably you have some badly performing queries. Run profiler for a while and...
November 28, 2008 at 12:24 pm
Viewing 15 posts - 42,826 through 42,840 (of 49,566 total)