Viewing 15 posts - 20,071 through 20,085 (of 26,490 total)
skjoldtc (7/1/2009)
Lynn Pettis (7/1/2009)
I need you to give me a script that will automagically determine what records to delete from unspecified tables.I mean really, you want fries with that too?
The...
July 1, 2009 at 3:35 pm
I mean really, you want fries with that too?
July 1, 2009 at 2:41 pm
Without seeing the structure of the tables and some sample data, we can't really help you. There are no internal columns on the tables that will tell you when...
July 1, 2009 at 2:37 pm
Yes, you can leave it in compatibility mode 80, but once the database is attached to SQL Server 2005, you won't be able to take it back to a SQL...
July 1, 2009 at 2:32 pm
Using Processor Affinity they may be able to configure SQL Server to use only the cores in one physical processor which should keep them legal.
July 1, 2009 at 2:30 pm
ld (eL De) is the alias for the derived table in the FROM clause. If you look at the SQL Server 2005 version, it is the CTE declared before...
July 1, 2009 at 2:12 pm
jason brimhall (7/1/2009)
July 1, 2009 at 2:00 pm
You may want to look at SNAP SHOT ISOLATION on your database. Enabling this feature in SQL Server 2005 should help you keep Readers from blocking Writers.
July 1, 2009 at 1:42 pm
John Paul (7/1/2009)
hi ,need a Script that
delete any records which has a timestamp .
Extremely vague request, extremely vague response:
delete from ATable where TimeStamp = 'somedatetime';
If you want a...
July 1, 2009 at 1:01 pm
Opps! Forgot this was a SQL Server 7, 2000 forum. The code above is for SQL Server 2005. I have modified the code to work with SQL...
July 1, 2009 at 12:56 pm
Of course, while waiting, I came up this. Does it meet your requirements?
with LastDeployment (
Asset_ID,
Change_Date
) as (
select
Asset_ID,
...
July 1, 2009 at 12:54 pm
As I look at what you have provided, there does seem to be one thing missing that would really help. Based on the sample data provided, what SHOULD be...
July 1, 2009 at 12:44 pm
Would help to see the actual error message that you found.
July 1, 2009 at 12:27 pm
jagat.patel (7/1/2009)
ItemA1 INT,
ItemB1 INT,
ItemA2 INT,
ItemB2 INT,
Point Int
)
INSERT MATRIX
VALUES(1,1,1,2,1)
INSERT MATRIX
VALUES(1,2,2,3,1)
INSERT MATRIX
VALUES(1,1,2,2,1)
ITEMA + ITEMB represent 1 axis in the matrix and combination of all 4 should be...
July 1, 2009 at 11:58 am
Viewing 15 posts - 20,071 through 20,085 (of 26,490 total)