|
|
|
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 SQL Profiler v.s. Execution Plan Posted by Samuel at 3/10/2007 11:13:08 PM Hi,
I am writing a stored procedure and have come up with three different ways
to accomplish the same thing. I wanted to test the performance of each and
pick the best performing one (tested with roughly 1,5000 records).
I tried using Execution Plan and SQL profiler as reference, and found...more >>
Table Partitioning Posted by msnews.microsoft.com at 3/10/2007 7:41:51 PM I understand that table partitioning in sql server 2005 requires a native
datatype to direct data to the applicable filegroup, however, is it possible
to partitiondata based on a function like datepart(yyyy, columnname)=2007,
(or 2006, etc.)? That way all data based on the year in columnname ...more >>
SQL Mail Help Posted by Skip at 3/10/2007 11:28:09 AM Hi All,
I just upgraded to a new server and then reinstalled sql server 2005.
Everything seems to be going smoothly except SQL mail. I am using the
legacy Sql Mail. Problem is that when I try to execute XP_SendMail I
get the following error.
Msg 17930, Level 16, State 1, Line 0
xp_sendma...more >>
Group By Query Posted by Ranjit kurian at 3/10/2007 7:29:00 AM Hi,
I have a table as shown below
Account Date Balances
OTC 01-Jan-07 1000
OTC 02-Jan-07 6000
OTC 03-Jan-07 3000
OTC 04-Jan-07 4000
OTC 05-Jan-07 5000
ICT 01-Feb-07 2500
ICT 02-Feb-07 3000
I want to extract the row which has the latest date with corresponding
balance in both OTC an...more >>
How do I connect to a SQL 2K table in VS05 with Crystal rpts VS E Posted by Gordon at 3/10/2007 6:19:00 AM Hi;
How do I connect to a SQL 2K table in Visual Studio 2005 with the
Crystal Reports VS05 edition ?
I tried using VS help.
I followed the instructions to the letter I am able to grad coluumns to the
detail line from the fields tab. But when I tried previewing the report
instead of da...more >>
set certain fields to caps Posted by nexikan at 3/10/2007 6:17:53 AM Hi all,
If I have a case-insensitive database running on SQL Server 2000, is
there any way to set certain fields to be able to record data in upper
case only? And if yes, are there any differences for SQL Server 2005?
Thank you,
Alex
...more >>
|
Don't see what you're looking for? Search DevelopmentNow.com.
| home · blog · groups | Questions? Comments? Contact the dn |