PiMané (11/3/2009)

---

ok,

Thanks and sorry for the confusion..

But since these databases aren't very used, they are important but not read/write intensive, there's no need to move the log file to the...

TempDB...

After running the ALTER DATABASE command and shutting down SQL Server, did you move the mdf and ldf files to their new locations before starting SQL Server again?

Whic actually means we aren't in a position to know what is best for them. We have asked for clarification and now we need to sit back and wait.

It would also help if you provided the DDL (CREATE TABLE statement(s)) for the table(s), sample data (as INSERT statements). What you have provided so far really isn't enough.

For...

However, it would also help if the OP would elaborate as to what the problem or issue is. Several questions have been asked seeking clarification which has not been...

Gianluca Sartori (11/3/2009)

---

If my calculations are correct this is post # 9000.

I set 7 posts per page, took the page number, multiplied for PI and divided it by the distance...

Curious,you looking for something along these lines?

create table dbo.Ticket (

TicketId int identity(1,1),

UserAssigned varchar(32),

UserData varchar(512) null,

...

Another thing you may consider. If you want to capture the data causing the error, you can insert that data into a table variable defined for that function, then...

My take on table aliases is simple, use them even in single table queries. Two reasons for this, first, you never know when an additional table may be added...

You can also start here[/url] and make appropriate changes to move the data instead of just deleting it. One way in SQL Server 2005 is to use the OUTPUT...

As this is not a SQL Server error, you may want to start here or here (as the error message suggested.

malli.chitturi (11/2/2009)

---

Its not about memorizing the Q&A. Its about SQL is easy to Learn but hard to master. So Its just helping what part of SQL they have to concentrate...

Sorry? What seems to be the problem?

Alvin Ramard (11/2/2009)

---

First interview question: What would you do if I told you that I go by the nickname of GilaMonster...