Look up a couple of posts. 😉

How about something like this?

SET TRANSACTION ISOLATION LEVEL SERIALIZABLE

BEGIN TRAN

update table_num_schema set

@nextvalue = next_value = next_value + 1;

where

name...

GDI Lord (11/12/2009)

---

And the complex answer? 😉

Actually, X5 only has two values, 'A' and 'B'. Unless using only those two values is better for this specific query, although it goes...

How about showing us what you have written so far? This way we can see what you are trying to do and provide you with some constructive feedback.

Mark Harr (11/12/2009)

---

I second Ed Vassie's question on the supposed JCL limitation.

I got the answer right, only because the category was SSIS and I figured that one of those two...

Okay, learned something new this morning about SSIS and multiple flat files.

Good question!

GDI Lord (11/12/2009)

---

Hey guys

Current index definition:

CREATE NONCLUSTERED INDEX [IX_tblX_X1X2X3X4X5] ON [dbo].[tblX]

(

X1 ASC, -- VARCHAR(8)

X2 ASC, -- VARCHAR(6)

X3 ASC, -- VARCHAR(3)

X4 ASC, -- VARCHAR(6)

X5 ASC -- VARCHAR(2)

)

INCLUDE (X6, X7,...

First, in the Object Explorer window of SSMS, look for tempdb under System Databases. Right click on tempdb and select Reports, then Standard Reports, then Disk Usage. If...

andre_quitta (11/11/2009)

---

I have a table with an INT identity, Company and Type, among other columns. I need to match a row with the previous instance of that row for that...

seandeyoung-1145978 (11/11/2009)

---

Pretty good assumption based on that I was asking how I could find the information in the metadata of the instance of the server. I should have rephrased my...

Jim-720070 (11/2/2009)

---

Apologies for adding to what seems to be a resolved thread.. BUT! I was having a very, very similar issue.

My sp looked something like this:

CREATE sp_blahblah @month INTEGER (YYYYMM)...

mpeters-878100 (11/11/2009)

---

I had a similar problem with one of my queries, what i did is hard coded the date time values into the where clause and ran the query, then...

I agree with Sergiy, especially if you have numerous queries that make use of the eventDueDate column in the WHERE clause of queries or if this is a frequent path...

Is this actually being run from within a stored procedure?

If so, may I suggest that you read the second article I reference in my signature block below regarding performance issues?...

If I may, if you have room on the database server to complete your backup locally, I'd do that and THEN move the backup file to the other server. ...