Scheduling legacy DTS packages in SQL 2008 SP1
Tue, 9 Mar 2010 13:27:16 -0800 (PST)
I have hundreds of DTS packages that I brought over from SQL2000 into
a SQL 2008 Enterprise SP1 64 bit environment, on Windows 2008 R2 64
Bit. Our plan is to bring everything over as is, and convert to SSIS
as time permits. I've run into a bit of a stumbling block hopefully
someone out there can assist me with ...
|
Forums versus newsgroups - can you indulge a SBS MVP by answering
some questions?
Tue, 09 Mar 2010 12:56:57 -0800
As an SBSer since I have SQL on my server I feel like SQL is family so
if you'll indulge me in a fishing expedition on forums versus newsgroups.
I need to pick your brain a bit if you don't mind? Can I ask some
fishing expedition questions because I want to see if my thoughts are on
track with others. Jus ...
|
space in log file cannot be reused
Tue, 9 Mar 2010 11:09:01 -0800
Im a GP tech and I recently ran a GP company DB upgrade on SQL05 - 5
companies made it - one did not. I tried 2 more times and ran into this
error each time:
transaction log for company ID full. To find out why the space in the log
cannot be re-used see the log_reuse_wait_desc column in the sys.databases? ...
|
Supporting Oracle as well as SQL Server
Tue, 9 Mar 2010 10:36:49 -0800 (PST)
Hi all,
I have just been asked if we can support Oracle as well as SQL Server.
And what the implications are.
A bit about our setup. Basically we deal in data - there is an app,
but it is secondary to the data. Lots of data migrations etc. We have
a complicated database schema with loads of constraints and ...
|
Capture Bulk Insert Duplicate Rowcount
Tue, 9 Mar 2010 09:50:01 -0800
SQL Server 2008 Std, SP1, Windows 2008
I am using bulk insert to load a large amount of data into my database. The
tables have a primary key with the ignore duplicate values turned on.
Everything works just fine, but I would like to track the number of rows from
the input file that do NOT get loaded due to ...
|
Default Degree of Parallelism on SQL Server 2005
Tue, 9 Mar 2010 09:40:01 -0800
Is there guidelines, suggestion or could somebody point me to articles which
discuss how to determine the optimum degree of parallelism?
I suppose the biggest factor is going to be cxpacket waits. My problem is
how do I determine when cxpacket waits exceed the treshold.
Thanks in advance ...
|
SQL SERVER 2005 Database Engine Tuning Advisor Error "Statement does
not reference any tables"
Tue, 9 Mar 2010 09:23:04 -0800 (PST)
hi guys,
I had a trace file from production (almost all stored proc execution
events) and I'm using it to tune agaist the exact copy of production
database. After running an hour, the progress shows in the Reason
column almost all "Statement does not reference any tables" and
there's no recommendation at all. ...
|
|
|
Attunity with SQL Server
Tue, 9 Mar 2010 07:55:01 -0800
Hello everyone,
I just wonder if there's anyone who uses\used Attunity with their SQL Server
environment?
I would appreciate if you have any experience, suggestion or tips to share
with me.
Thanks,
Ekrem Ã?nsoy - SQL Server MVP ...
|
SQL Server 2008 - Performance Alert Recommendations
Tue, 9 Mar 2010 07:47:01 -0800
Hello,
I have just completed a migration from SQL Server 2000 to 2008 and am in the
process of applying the finishing touches on the SQL 2008 server. I am
currently creating Alerts and was looking for recommendations on what
performance alerts to add. I have added a few obvious ones like Deadlocks =
1 ...
|
Index on a Timestamp Column
Tue, 9 Mar 2010 05:34:07 -0800
I have been asked to index the Timestamp column on our main source system
database (1.3TB). The proposed index's are to help decrease the load time of
our datawarehouse. My question is, are timestamp columns good candidates for
indexes. (The warehouse selects between two timestamp values) considering the
con ...
|
