Database

Mycroft has given you some good advice. In terms of your original question, yes this will be reliable if you serialize the transactions. Incidentally, this will reset before 1000, not after. I assume that is what you want, so you are generating your business numbers in the range 1001... to 1999...

Nor do I. :thumbsup:

adilsardar wrote: The database contains approx 260 tables and what we need is the data from appox 150 tables. That's over 50%. How much data would that be, in megabytes? And how often will you run this query? adilsardar wrote: Is ssis packages are good solution if we use separate db's and then sych them.? I don't have personal experience with SSIS, but replication sounds good. I are Troll :suss:

More reason not to use stored procedures. Try a table-valued function instead.

I was getting the same error. Ur soultion worked. Thanks a lot. Meenal Ronghe.

Yes, I took part. I prefer outer join -- because of portability and such.

If this is production AND you have a backup, you may not want to restore over the top of a production database. you can instead restore to a new database, then add the column allowing nulls, use an update query to put the data back leaving anything in the other columns unchanged. depends on the nature of your data and environment.

http://www.sql-articles.com/scripts/enabling-remote-connections-via-dos-or-t-sql[^] the actual link! THANK YOU :laugh:

We use code version tool. We also include the version number as comments in stored procedures and functions. Out versioning tool automatically applies the versioning comments.

Thanks for the reply, but your suggestion did not work. I have now resolved the problem, and my final SELECT query now looks like this :- SELECT * FROM ( SELECT * FROM vuWeighTicketReport WHERE [TicketDate] >= '2010-09-10' ) AS Tickets PIVOT ( SUM(ProductWeight) FOR ProductCode IN ( [Blood],[Bonecake],[Carcass],[CFat],[Desiel],[DMeal],[Feather], [FMeal],[Greaves],[Head],[Misc],[Offal],[PBlend],[PFB],[PMeal], [Skin],[Slurry],[Tail],[Tallow],[TBottom],[Thigh],[TMeal],[Wash] ) ) AS TicketProductWeights The only difference to the original is that I have added AS TicketProductWeights to the end. Typically, the problem was stiring me in the face, and I couldn't see it. :doh: Thanks again. Steve Jowett ------------------------- Real Programmers don't need comments -- the code is obvious.

thanks. I used nvarchar(max). just trying to know which one holds large data like 2-3 pages. i haven't worked with large data before. suchita

I worked at a teaching hospital for about 18 months and the db licenses there were dirt cheap. (Less than 1/3 the retail price) I assume because it was attched to a University. This applied to Oracle and SQL Server (and yes, I am talking about a production license in both cases). YMMV - A lot has changed in seven years, so this may be completely irrelevant. HTH, -Chris C.

SQL Express is totally free, and has no requirement for CALs or any other form of license. Other editions of SQL Server can be licensed per processor or by CAL as per SQL Server 2008: SQL Server 2008 Licensing[^] If you have knowledge, let others light their candles at it. Margaret Fuller (1810 - 1850) [My Articles]  [My Website]

I agree with Mycroft (second time today) this is more of an art than a "do it this way" type thing. There are so many variables that there is no easy answer. Some things to look into (learn about) would be Data Base Tuning Advisor and audit trace for a start. These may or may not help. There are also several third party programs that might help, again Google may help. You might look at Idera as one provider.

Look into replication (publication) or log shipping. Depending on your usage and resources the type you use may very. You can replicate to the same SQL server.

Partitioning a table is NOT what you want to do, that is dealing with VERY large tables and requires DBA skills. You are after a data structure. You have 3 tables crammed into 1. Employee EmployeeID EmployeeName StateID Country CountryID CountryName State StateID CountryID StateName Employee View Select * From Employee E Inner Join State S on S.StateID = E.StateID Inner Join Country C on C.CountryID = S.CountryID Never underestimate the power of human stupidity RAH

Could you pls tell me how you are created backup database. where i am using only single database to keep my 10000 record of info. if something goes wrong what to do... ************ S G KORE *******************

Sylv33 wrote: loops through all rows in a table The engine should do that; you shouldn't.