196 reputation
4
bio website
location
age
visits member for 2 years, 1 month
seen Dec 12 at 0:15

Incredibly handsome, AND I got a retrospective badge for telling you this.


Dec
12
comment How can you tell if a SQL Server instance max'ed out bottleneck is CPU or Memory?
There are many many articles on performance tuning. SELECT INTO is performing two actions: a select and an insert. So split them out - how long does the SELECT take on it's own? I don't know if disk queues are considered useful anymore with SAN's etc. in the picture. Perhaps take a look at this: mssqltips.com/sqlservertip/2329/…
Nov
18
comment Protect SQL Server Express data file
Remove the trailing dot from the link. Basic troubleshooting.
Oct
9
comment Why different users from same login group can not access the database objects?
Are you certain the .Net app is connecting as that user? I suggest that you use SQL Profiler to be certain.
Sep
24
awarded  Autobiographer
Sep
21
comment sql server linked server does not consider indexes
Is this two SQL Server databases? the term 'listener' generally mean oracle. You also need to upgrade the word 'seems' to be something certain. Does it or doesn't it consider the index?
Sep
8
comment Best practice to shrink Tempdb in a production environment
Sorry I can't help you there.
Sep
8
comment Best practice to shrink Tempdb in a production environment
Best practice is to work out what is making it grow, and address that. If you shrink it it just has to grow again and that takes time and IO
Aug
25
comment How to divide data per client from a single database?
Are these different databases on the same server? or are they on different servers?
Aug
24
comment How do I determine if a SSIS transform is non-blocking, partially blocking, or fully blocking?
Does anyone have any ideas about how this could be tested? I guess performance or informational logs could be used to find this out for sure but I'm not exactly sure which.
Aug
24
answered Can set unique constraint in table have data not unique SQL Server?
Jul
24
awarded  Commentator
Jul
24
comment Copying a table in SQL Server database to Oracle database
The "t_database_link_sql_server_oracle.htm" link you referred to deals with setting up a link from Oracle to SQL Server and is irrelevant for this approach. In this approach you define the connection to Oracle in the destination step.
Jul
24
comment Copying a table in SQL Server database to Oracle database
For a thousand records there will be no performance issues no matter how you do it. The real challenge in your case is making something reliable that you can maintain yourself. Why don't you follow through the answer proposed below and ask any specific questions.
Jul
24
comment Copying a table in SQL Server database to Oracle database
OK, so you need to be on the server to do this. This will create a SSIS package which you should be able to schedule in a job. You will also need to install the Oracle client on the SQL Server in order to connect to Oracle.
Jul
24
comment Copying a table in SQL Server database to Oracle database
Very handy. What version of SQL Server is that? I can't see the export option in SSMS 2008 R2.
Jul
24
comment Copying a table in SQL Server database to Oracle database
If there is unlikely to be more than thousands of record then a TRUNCATE/INSERT solution should be fine rather than a more complicated CDC one. Do you want to 'push' the data from SQL Server or pull the data from Oracle? If you want to push from SQL Server you need to install the Oracle driver on the SQL Server.
Jul
24
comment Copying a table in SQL Server database to Oracle database
I assume the second time this is run duplicate data will be pushed over. Or does this process automatically clear the target table beforehand? You will also need to install the Oracle driver to do this.
Jul
24
comment Copying a table in SQL Server database to Oracle database
oh ,and exactly which version of SQL Server and Oracle?
Jul
24
comment Copying a table in SQL Server database to Oracle database
The data can never be synchronised in real time, there will always be some kind of latency. How big are the tables, how often are they changed, what is the volume of changes. Is it mainly inserts, updates or a mix of both? You first need to decide on a TRUNCATE/INSERT approach or a CDC (change data capture). You need to decide on a tool to transfer the data. If you are a beginner at this I suggest MS tools, not oracle ones. One MS tool to transfer data like this is `SSIS, though this is not necessarily the best option for real time replication, and is not the only option.
Apr
30
comment SQL Server agent job scripts
"Cannot run these packages until the source is closed." ? Is that an error you get? From where? SQL Agent? You should open a new question and explain in detail what you want to do, what you did and any errors that occurred. I assume from your response that your packages are saved in SQL Server, not in the file system.