[Show all top banners]

JayNir
Replies to this thread:

More by JayNir
What people are reading
Subscribers
:: Subscribe
Back to: Computer/IT Refresh page to view new replies
 SQL DBAs

[Please view other pages to see the rest of the postings. Total posts: 60]
PAGE: <<  1 2 3  
[VIEWED 17729 TIMES]
SAVE! for ease of future access.
The postings in this thread span 3 pages, go to PAGE 1.

This page is only showing last 20 replies
Posted on 11-11-08 10:00 PM     Reply [Subscribe]
Login in to Rate this Post:     1       ?     Liked by
 

Any SQL DBAs here??!!



 
The postings in this thread span 3 pages, go to PAGE 1.

This page is only showing last 20 replies
Posted on 11-21-08 10:02 AM     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

hey you guys have already climbed the everest I am just starting. I have one question. How can we transfer data from SQL server to excel file in SSIS. Just give me some info.
 
Posted on 11-21-08 10:09 AM     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

ohio,

Go to Data Flow task

Choose Oledb source and configure it and Excel Destination and transfer data. You can use Export/Import Wizard, Linked Server, Opendata source , bcp to do same stuff?

 


 
Posted on 11-21-08 11:02 AM     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

while I am trying to do the character mapping from the data imported from sql its giving me the error message "The last row in the data grid does not contain all necessay fields." What is this issue about?

 
Posted on 11-21-08 1:39 PM     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

ohio,

as for ur problem with ssis....transfering SQL Server table data into excel file, u need to do the following tasks:

1) first u need to drag and drop dataflow task in control flow panel and double click the data flow task.

2) double clicking will lead u to dataflow panel, over there drag and drop the source OLEDB for SQL task and configure the connection manager.

3) drag and drop the destination for excel task and link those two tasks.

4) do the column mapping

thats it,

just look around, u will surely be able to do this.


 
Posted on 11-21-08 1:58 PM     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

good to see sql ppl in sajha....

Ohio ji, if it is still not working check out link below. will definetly  help you..

http://searchsqlserver.techtarget.com/generic/0,295582,sid87_gci1306800,00.html


 
Posted on 11-21-08 3:19 PM     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

thanks for the instant help. I did it. It takes little bit time to get familar with these tools since there are so many tools there tauko nai khanae.
 
Posted on 11-23-08 1:04 PM     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

hey everybody,

can u guys can throw a light on partitioning the table and how it affect the performacne? what are the issues likely to face while implementing partition? if any ideas, please let the knowledge be shared.

 


 
Posted on 11-24-08 3:07 PM     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

Hi

I am doing data transfer from an SQL Server 2005 database to a Microsoft Access Database. I have used Data Reader Source and OLEDB Destination. I made connection with them. When I execute the package it gives me the following error message.  

"Warning 1 Validation warning. Data Flow Task: OLE DB Destination [482]: Truncation may occur due to inserting data from data flow column "AddressLine2" with a length of 60 to database column "AddressLine2" with a length of 50"

I have created the access table with the necessary columns before executing the package. My screenshot is here. Do I need to match the data type of the table I have created or while mapping in the OLEDB Destination provider will fix that.

 

 


 

Last edited: 24-Nov-08 03:08 PM


 
Posted on 11-24-08 4:51 PM     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

Yes, you must match the datatype and they should have same datalength

 
Posted on 11-24-08 5:09 PM     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

thanks for the help virusno1. There is a tool there in oledb connection that will automatically create the query, so we dont have to worry for the datatype.

 
Posted on 11-24-08 5:47 PM     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

Partitioning is basically physically arranging data in one single table across multiple physical database files so that only a subset of data is read for most of the queries. It normally requires a Partition key and partition function. It also requires the use SQL Server Enterprise Edition 2005 or above. First a little background - if you have huge amount of data - say a billion row or above, it is very expensive to have them in one file. In this case you partition them into multiple physical database files and SQL Server will try to read the data - based on your query - from certain partitions only. This is called partition elimination. Auto increment columns by the way make for very poor partitioned column. To give a concrete example . Say you have a fact table of sales data for last two years, based on your need you might want to consider it to partition based on every month - so your table will consist of 24 partition. When a new month comes in you simply slide it in and swap out the oldest partition (it is called a sliding Window). I manage 4 SQL Server enterprise Databases from 3 TB to 13 TB (yes that's Tera byte) with the largest one containing 4.1 billion rows in the biggest fact table with 18 partition for last 18 months (partitioned by a day serial key ). The performance is OK. We are though next year migrating these database either to Vertica, Netezza or TeraData(most probably Vertica if it meets the data load times). My 13 experience of working with TeraData, Oracle and then SQL Server suggests that you will need partitioned tables only for massive data warehouse applications - and seldom in a OLTP application. Also generally you will see it in traditional big names databases (shared everything database in tech parlance) grafted over the traditional file access mechanism (which hinders parallel data loads by the way) . If you need to support really huge BI/Data Warehouses with huge dataload and brief windows of loading time - you are better served if you look at something else - for example Vertica, Netezaa or Teradata. You will save yourself a lot of grief. And at that kind of data volume, the price you will pay - work out to be cheaper for Netezaa than for SQL Server (100,000 /TB for Netezaa - hardware/software inclusive - compared to about 50 K for SQL Server EE licences, OS, Server and Storage ) Cheers Brat.
 
Posted on 11-27-08 4:21 AM     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

I am one dba

 

hehe

how are you jay bro.If you are looking to provide a job, please let me know.

 

 


 
Posted on 11-29-08 8:47 AM     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

Nishant322,

good bro!!! So another RHCE joins the group!!

gettin' job has never been so difficult!!

 


 
Posted on 11-29-08 12:03 PM     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

 

HI,

I am looking for SQL developer/DBA training consultancy. Can you guys suggest me any good consulting company that would provide me instructor based training and would also file H1 B for me.


 
Posted on 12-16-08 1:34 PM     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

What is the Best efficient tool to migrate 2005 database to Sql server 2008?
 
Posted on 12-16-08 3:29 PM     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

Are you asking a trick question or perhaps I misunderstood? You can either simply run the DVD for SQL Server 2008 and choose the upgrade option. I personally usually detach the existing production databases before doing the upgrades. Doing the updates in the cluster can be tricky, I though have always rebuilt the clusters when I update from one version to another. But I guess it is not what you are looking for.
 
Posted on 12-17-08 5:52 PM     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

i cann't really run dvd to existing 2005.

 

I have a few servers in test environment. I need to fresh install 2008 wherer i could migrate 2005 database including logins and all!!

 

 


 
Posted on 12-18-08 4:53 AM     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

1. Install SQL Server 2008 in a new box. 2. Either backup existing database from 2005 and restore back on on 2008 -it works fine. 3. Either detach existing databases, copy them over to 2008 box and attach them. This also works fine. 4. Use SQL Server data transfer to transfer the database. 5. Generate the script for the existing database, and recreate it on 2008, BCP out the data from old one and pump it back to new one. So take your pick. Personally I will use either 2 or 3. Note that once you have upgraded the database to 2008, it cannot be attached or restored back to 2005.
 
Posted on 12-18-08 1:32 PM     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 
 
Posted on 12-21-08 9:27 PM     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

do anybody have knowledge on what are the parameters that get changed during refresin the transaction replication?


 



PAGE: <<  1 2 3  
Please Log in! to be able to reply! If you don't have a login, please register here.

YOU CAN ALSO



IN ORDER TO POST!




Within last 200 days
Recommended Popular Threads Controvertial Threads
शीर्षक जे पनि हुन सक्छ।
NRN card pros and cons?
What are your first memories of when Nepal Television Began?
TPS Re-registration
Democrats are so sure Trump will win
Basnet or Basnyat ??
nrn citizenship
Sajha has turned into MAGATs nest
Nas and The Bokas: Coming to a Night Club near you
ChatSansar.com Naya Nepal Chat
डीभी परेन भने खुसि हुनु होस् ! अमेरिकामाधेरै का श्रीमती अर्कैसँग पोइला गएका छन् !
3 most corrupt politicians in the world
if you are in USA illegally and ask for asylum it is legal
Returning to Nepal with us citizenship. Property ownership
Top 10 Anti-vaxxers Who Got Owned by COVID
आज बाट तिहारको सेल सकियो
निगुरो थाहा छ ??
Do nepalese really need TPS?
सुवास नेम्वाङको निधन कोविद भ्याक्सीन को कारण हृदयघात
Travelling to Nepal - TPS AP- PASSPORT
Nas and The Bokas: Coming to a Night Club near you
Mr. Dipak Gyawali-ji Talk is Cheap. US sends $ 200 million to Nepal every year.
Harvard Nepali Students Association Blame Israel for hamas terrorist attacks
TPS Update : Jajarkot earthquake
NOTE: The opinions here represent the opinions of the individual posters, and not of Sajha.com. It is not possible for sajha.com to monitor all the postings, since sajha.com merely seeks to provide a cyber location for discussing ideas and concerns related to Nepal and the Nepalis. Please send an email to admin@sajha.com using a valid email address if you want any posting to be considered for deletion. Your request will be handled on a one to one basis. Sajha.com is a service please don't abuse it. - Thanks.

Sajha.com Privacy Policy

Like us in Facebook!

↑ Back to Top
free counters