|
|
|
January 2003 March 2003 April 2003 May 2003 June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 April 2008 |
Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 deadlock on tempdb..sysindexes Posted by Saxon at 10/16/2005 11:50:03 PM Greetings,
I have stored procedure dumping resultset into created temporary table.
Every 15-30 minutes we have deadlock and always on sysindexes in tempdb.
Problem is I that can not change stored procedure and not sure how to stop
locking sysindexes since stored proc will take between 5-15...more >>
How to compact & repair database in SQL Server 2000? Posted by Harshad Phadnis at 10/16/2005 11:40:02 PM Hi All,
You must be knowing that we can compact & repair database in
ACCESS. Is there any way / utility to do the same in SQL Server 2000? (Server
CE does provide this facility)
Regards,
Harshad...more >>
locate static data in xml file vs db table Posted by John A Grandy at 10/16/2005 7:31:08 PM How do people see the security of locating static data (such as config
settings) in an XML file (a copy is located on each web-server, or a single
copy is located on a specific server) , versus locating this data inside the
db ?
An XML file that contains all app config settings is much easi...more >>
just wondering Posted by rodchar at 10/16/2005 7:31:01 PM hey all,
is it important to tie a payment to an inovice number ( or is it ok to just
tie it to the customer id )?
thanks,
rodchar...more >>
primary key Posted by rodchar at 10/16/2005 10:00:05 AM hey all,
i have an invoice table where the customerID/invoiceNo uniquely identify a
record, also i have just a tableID (if I'm not mistaken, is a good practice
to do). which one should be my primary key?
thanks,
rodchar...more >>
Triggering a SQL Server Trace Posted by A. Robinson at 10/16/2005 8:28:03 AM I'm looking to run a particular SQL Trace. I've already scripted the trace.
What I would like to accomplish is to have this trace start when a certain
system condition occurs. For example, at certain points throughout the day,
SQL Server causes the cpu to run very hot. So hot, in fact, that i...more >>
Top 10 Longest Running Stored Procedures and Queries Posted by Joe K. at 10/16/2005 7:16:02 AM
Like to obtain a script that will give me the top 10 longest running stored
procedures
and queries and the numerous of times these stored procedures are executed
daily.
This script would be helpful.
Thanks,...more >>
sql batch vs stored proc Posted by ari at 10/16/2005 7:03:01 AM hey all,
i'm not sure if i'm comparing apples and oranges but is one of these better
than the other in performance? or in any other way?
thanks,
ari...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
How to delete the whole sub tree? Posted by Roger at 10/16/2005 5:56:02 AM Please see also the problem at:
http://blog.joycode.com/mvm/articles/63479.aspx...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |