|
|
|
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 August 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 inner sql performance on paging operation Posted by John Mott at 4/14/2007 11:11:19 PM Hi all,
I've implemented the generalized paging code discussed in various places
that gets the top 'startrow+rowcount' records, then retrieves the 'rowcount'
records from that, etc. Its listed at the end of the message.
Its working well in general but as the starting row gets high in one ...more >>
Calc and sort an import to a database Posted by staffan at 4/14/2007 11:00:44 PM Hi
I am a beginner in SQLsrv!
I have a SQLSrv2000 database with tables with up to 200000 rows in several
tables. Must of the times I am just reading some data and thats no problem.
But now I whant to build an importfunction where I am reading up to 25000
rows from a Excelfile and then I am...more >>
this simple query returns too much records Posted by Oscar at 4/14/2007 9:47:15 PM I want to find out which Employees have a contract and whether they've
worked and if so, the last work day
the tables concerned are :
tblEmployee : table holding all records of Employees
tblContracts : table holding all contract of Employees (not every employee
has a contract)
tblWorkDays ...more >>
How to get 2005 NORTHWIND SAMPLE DATABASE onto my system??? Posted by Alan Mailer at 4/14/2007 8:50:52 PM Ok, please keep me from going out of my skull here.
I'm trying to practice using Visual Studio and the examples I'm using
require that Microsoft's Northwind database be available on my system.
I have now installed SQL Server Express 3 times and it is not adding
this sample database to my com...more >>
newbie: error in simple T-SQL code Posted by R.A.M. at 4/14/2007 7:51:33 PM Hello,
I am learning T-SQL (SQL Server 2005). I have written such trigger:
SET ANSI_NULLS ON;
GO
SET QUOTED_IDENTIFIER ON;
GO
CREATE TRIGGER InsteadOfInsertPositions
ON Positions
INSTEAD OF INSERT
AS
BEGIN
SET NOCOUNT ON;
DECLARE Received CURSOR FORWARD_ONLY READ_O...more >>
Êý¾Ý·Ö×é Çóƽ¾ù Posted by naonux NO[at]SPAM gmail.com at 4/14/2007 7:31:21 PM ztLV/dTaseDQtNK7uPazzNDyCrPM0PK5ubPJCiAgIMO/vOS49LnMtqjKsbzkvdPK3Mr9vt0KxL+x
6gogICCwtMqxvOS1xLzNwrzLs9DyvMbL47nMtqi1xLTOyv21xMa9vvnWtQrRsNXSusO1xL3ivva3
vbeoCgrO0rXEt723qMrHttTSqsfztcS5zLaotM7K/cq508PSu8r00NTWxrHqvMcgt9bX6SDH88a9
vvkKCrHIyOcKse3D+7PGKMr9vt0pCgqxu8fztcTGvb75tcTB0M6qIKOowffBv6OpIL...more >>
Optimization jobs Posted by FARRUKH at 4/14/2007 5:22:01 PM is there any advantage to run the database optimization and integrity
mainteance jobs separately?
previous DBA set the both optimization and integrity job n one maintanance
job but run n different timings. I am wondering if i make separate
maintenance plan for both jobs...more >>
How to disable the query cache? Posted by Oscar at 4/14/2007 5:19:32 PM I'm trying to improve the performance of my queries by measuring the process
time. Since SQL Server also improves the performance by the query cache, I
am not always shure whether the performance is due to the recoding or the
query caching. How can I ocassionaly disable the query cache ?
Os...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
newbie: error in T-SQL code Posted by R.A.M. at 4/14/2007 1:29:45 PM Hello,
I am learning T-SQL (SQL Server 2005). I have written such trigger:
SET ANSI_NULLS ON;
GO
SET QUOTED_IDENTIFIER ON;
GO
CREATE TRIGGER InsteadOfInsertPositions
ON Positions
INSTEAD OF INSERT
AS
BEGIN
SET NOCOUNT ON;
DECLARE Received CURSOR FORWARD_ONLY READ_O...more >>
Defrag. The Drive that contains Databases Posted by sriram at 4/14/2007 1:17:24 PM HI,
What would happen if i defrag the Drives taht contain my SQL
Databases. Would there be any problem?
Please advice as i want to Defrag the Drive that contains my
databases?
Thanks,
Sriram
...more >>
displaying a single months field as 12 fields Posted by Chris G. at 4/14/2007 12:20:01 PM Hey all,
I've got a table withthe filed "PayMonth" which is an interger representing
months, 1 thru 12. What I'd like to do is parse them out as "Jan"
"Feb"..."Dec" so it looks like
year Jan feb... Dec Total
2006 $50 $60... $30 $140
2005 $60 $60... $50 $170
Here's wh...more >>
Moderately Challenging select question Posted by roy. NO[at]SPAM nderson NO[at]SPAM gm NO[at]SPAM il.com at 4/14/2007 9:09:45 AM Hey all, I have a legacy db here that's flat in nature. Short of a
complete rebuild, is there any way to accomplish the following
concept:
SELECT
(select max(t1.event_date) from table1 t1 inner join tableX x on
t1.num = x.num where t1.event = 'event1') AS 'max_event1',
(select max(t1.event_d...more >>
newbie: error in simple T-SQL code Posted by R.A.M. at 4/14/2007 8:15:45 AM Hello,
I am learning T-SQL (SQL Server 2005). I have written such trigger:
SET ANSI_NULLS ON;
GO
SET QUOTED_IDENTIFIER ON;
GO
CREATE TRIGGER InsteadOfInsertPositions
ON Positions
INSTEAD OF INSERT
AS
BEGIN
SET NOCOUNT ON;
DECLARE Received CURSOR FORWARD_ONLY READ_O...more >>
Which File LOADS SQL SERVER EXPRESS??? Posted by Alan Mailer at 4/14/2007 6:46:29 AM I guess it doesn't get any more basic than this:
I just loaded MS Visual Studio 2005 to my computer. I want to start
using it to practice writing some VB.net code...
The code I'm going to practice with utilizes SQL Server Express's
Northwind database. Though I know development in Visual St...more >>
Error when migrating table across databases Posted by loadquo NO[at]SPAM gmail.com at 4/14/2007 3:47:33 AM I'm getting the following error
The following error occured while executing the query:
Server: Msg 170, Level 15, State 1, Line 24
Line 24: Incorrect syntax near '('.
When trying to execute a query created in sqlserver 2005 (using script
table as CREATE) on myserverworld.net (I only have a ...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |