a2zwd (10/6/2008)

---

Hi,

I am writing a query to display records from a table between 2 dates.

When I write the query with static dates, its executing in 1 second....

arjun.tewari (10/6/2008)

---

Hi Guys,

Does any body have any idea about the below error:

The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the...

Niyala (10/6/2008)

---

Hi all,

I got the following message which is related to SQL Server. I was wondering if anyone could explain to me what they mean?

DBSPI-3266.1: # of transaction log expansions...

jeremiah.peschka (10/3/2008)

---

Essentially, I'm curious if the position of an FK column matters for performance.

That is, is:

CREATE TABLE User (

UserId INT IDENTITY(1,1) PRIMARY KEY,

UserTypeId INT REFERENCES UserType(UserTypeId),

-- 50 columns

);

any faster to...

Jeff Moden (10/3/2008)

---

This is what happens when an OP doesn't post the correct requirements.

Sam... please read and heed the article at the link in my signature. I'm pretty...

samsql (10/3/2008)

---

Nope this not the Query saby and ken has given me the exact query which i want but the issue in actualy senario image col contains datatype image ......

samsql (9/30/2008)

---

Actaul table contains diffrent datatype for image1 to image10 it is image datatype bcoz it contains images

CREATE TABLE dbo.table2

(

...

Jim Russell (10/2/2008)

---

Before everyone jumps on the "never SELECT *" bandwagon, I'd argue that there are cases where * is both useful and appropriate. One example is a view that...

I wouldn’t set rowcount...

samsql (9/30/2008)

---

Its urgent...

Hi i want make a query such like there is a there is a 3 not null value between column img1 to img10 the query shud give me...

Any reason that you refuse to answer the questions that asked you? In any case...

tt (9/29/2008)

---

I am trying to write a script that would notify me if a table has inserted 400 rows, I am not sure if it is an insert trigger or...

If you are using Managemant studio, you can just type GO 20 after the insert statement:

INSERT INTO #test DEFAULT VALUES

go 20

This will cause the insert statement to run 20...

If the log file isn’t set to auto shrink, then someone is shrinking it. Check it you have a job that shrinks...

I think that today’s question wasn’t a good one. Since the answer is number of 8KB pages there was no correct choice given to us. Bytes much more...