Viewing 15 posts - 20,071 through 20,085 (of 26,484 total)
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
What you are going to need to look into is dynamic sql. I suggest that your start first with looking it up in BOL (Books Online, the SQL Server...
July 1, 2009 at 11:41 am
They do, each table can have a single column defined as an IDENTITY column.
July 1, 2009 at 11:12 am
Unfortunately, without further explaination from the OP regarding what he is looking for, all we can do is offer up guesses.
July 1, 2009 at 11:03 am
Nope, you can't mark a thread as answered. Reason being some one may look at your solution and provide you with another alternative (note, I didn't necessarily say better)...
July 1, 2009 at 10:48 am
When you talk sequence number all I can think of are identity columns in tables. can you explain in greater detail what your looking for?
July 1, 2009 at 10:44 am
Viewing 15 posts - 20,071 through 20,085 (of 26,484 total)