|
Hello All;
I have a SQL db that collects environmental data. As it gets larger the performance of the server suffers. So I think that I would like to copy the "working" db to a new db then purge the working db. The be able to run querrys that span the databases.
I don't know just enough about SQL server to be dangerous so I would like to do this using VB.net
As an example.
If we backed up the db monthly and renamed them. then would it later be possible to run querry's that spanned the db's.
1. Is this a doable concept?
2. Would I?
"Drop" the working db
Copy all the data from the working db to a new db
Purge the tables in the working db
Just looking for some conceptual help here to make a plan to do this. Any help or guidence you could give be would be greatly appreciated.
tia
Rafone
Statistics are like bikini's...
What they reveal is astonishing ...
But what they hide is vital ...
modified on Tuesday, August 26, 2008 10:35 AM
|
|
|
|
|
If you are using SQL Server 2005 (or 2008) have a read about partitioned tables, this may be the answer to your performance problems.
Whatever you decide, DON'T try and do it in VB.net, you could well end up losing all your data!
Bob
Ashfield Consultants Ltd
|
|
|
|
|
You could use Replication to copy your working DB to another server and use that for all querying. SQL Server offers good replication capabilities for offline processing.
|
|
|
|
|
Helo,
Can anybody help me!
I have 3 tables
first 1 have a header table with one row
the second table are all the data records
and the third is a trailer table!
So now i want to create 1 file
with all the fields of the header table separated through ;
then new line, the data table with the fields separated through ;
and finally the trailer table with fields separated through ;
i think i can do this with Bcp utility or something like this,
but i don't know how!
Please help!
Thank you
|
|
|
|
|
You can create a SQL statement giving you correct result set and then save the result to a file.
Use UNION and concatenate all fields from a table to a single field using desired separator
Mika
|
|
|
|
|
Ok, thank you but i want to put this in a stored Procedure...
So i can call it from out of a program!
A.
|
|
|
|
|
Well, you have several options
You can use BCP (with a stored proc or a select) and a format file to create an output file, but this relies on ALL rows having the same number of fields
You can use the idea of concatonating the fields together with your delimiter and use this query in your bcp with effectively a single field per rocord
You can just read the data into your program and write the file yourself.
Try Goggling for format files in bcp
There are probably other ways too, but I can't be bothered to do your job any more...
Bob
Ashfield Consultants Ltd
|
|
|
|
|
It doesn't matter. You can return the result set from procedure almost like you can return it from SELECT statement so wrapping the statement into procedure is ok.
|
|
|
|
|
What is the difference between Sql Server 2000 and Sql Server 2005
Thnx
|
|
|
|
|
One was released in 2000 and the other in 2005.
On a serious note, there are thousands of articles dedicated to this on the internet. All it needs is a simple search.
|
|
|
|
|
HI,
For this question please refer google because so many difference are there and i can't tell them on this forum then also i ll tell you from programmers point of view.
Error Handling:
In sqlserver 2005:
Addition of TRY/CATCH allows more mature error handling. More error_xx functions can gather additional information about errors.
In sql server 2000:
Limited to checking @@error, no much flexibility.
Language:
in sql server 2005:
All the power of SQL Server 2000 with the addition of CTEs for complex, recursive problems, enhanced TOP capabilities, PIVOT/APPLY/Ranking functions, and ROW_NUMBER.
in sql server 2000:
SQL Language enhanced from previous versions providing strong data manipulation capabilities
Hope this will help you
Reasons are not Important but Results are Important.
Swati Tripathi
|
|
|
|
|
For starters:
SSRS
SSMS
SSIS
“If we are all in agreement on the decision - then I propose we postpone further discussion of this matter until our next meeting to give ourselves time to develop disagreement and perhaps gain some understanding of what the decision is all about.”-Alfred P. Sloan
|
|
|
|
|
|
Are you seriously that dumb that you cannot use Google? I suggest getting away from any career using computers right now.
Blog link to be reinstated at a later date.
|
|
|
|
|
U r the dumb who is completely dependent on google. May god just close the google for one day then dumbo how would find the solutions to ur probs
|
|
|
|
|
You ask a question to which there are many available sources of information, not least the Microsoft site which actually gives you a summary of the differences. You then complain when people suggest you look for yourself, and then further insult them when they suggest using Google.
Time you got some manners and a career change - if you cannot perform simple reasearch for yourself you will never make a decent programmer.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
And what would you do without CP to do your work for you rather than buying a book or doing some basic research? Based on your attitude, good luck getting ANY help from CP again.
Blog link to be reinstated at a later date.
|
|
|
|
|
Hi guys =D
im having a trouble in finding median (in a monthly basis) with sql with microsoft sql server...
can someone kindly help me =D
because im stuck with this part =(
below are my tables
NSWVIC TABLE
Region
DateNum
day_id
month_id
yearNum
time_id
TotalDemand
RRP
PeriodType
Month Table
Month_ID
MonthName
Thanks for the help =D
Regards
Jo
|
|
|
|
|
Ridiculous...What are we supposed to do with your table names? 
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|
|
|
Hi,
I'm having problems finding out how to delete a field in a jet (Access) database via SQL code (using OleDbCommand in C# code). This field is set to Indexed=Yes (no dups).
From my research, it looks like I have to change the Indexed to 'No' before deleting the field?
I found this on the net, but if the field was created with MS Access app, I don't know the idxName to use in my SQL code.
DROP INDEX idxName ON tblCustomers
thanks for any help you can give,
Ron
|
|
|
|
|
 I need to replicate my database in SQL Server.
So how can I do it?
Nasrin
|
|
|
|
|
Try looking in BOL for replication - its a large subject
Bob
Ashfield Consultants Ltd
|
|
|
|
|
I suggest you read BOL or get a book on SQL server management as this is not answerable in a forum post. Its the same as asking how do I set up SQL Server, answer, install it.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
In crystal report, you can select the printing direction in Layout tab between "Across then Down" and "Down then Across."
For Ex:
I have a dataset with 2 column:
id Name
1 Jim
2 Jess
3 John
4 Jane
5 Joey
I want the result to print like this:
id name id name
1 Jim 2 Jess
3 John 4 Jane
5 Joey
How can i do this in local RDLC report or is it even possible?
Please help/advice. I'm really stuck on this. Thanks in advance!!!!
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
