Viewing 15 posts - 42,826 through 42,840 (of 49,571 total)
Jack Corbett (11/22/2008)
GilaMonster (11/22/2008)
November 29, 2008 at 4:45 am
That's a pretty open question.
On the hardware side, make sure that you have planned for the new users and have capacity. eg if your CPUs are currently running on average...
November 29, 2008 at 4:20 am
Duplicate post. No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic610667-357-1.aspx?
November 29, 2008 at 4:14 am
You could write the code in notepad and compile with the command-line C# or VB compilers (which are included with the .net framework). It's a lot of work though.
Does anyone...
November 29, 2008 at 4:13 am
The error message would be really useful in trying to help you. Can you post it please?
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...
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
Viewing 15 posts - 42,826 through 42,840 (of 49,571 total)