problem slow queries after installing sp4 on sql 2000
Thu, 25 Feb 2010 16:21:01 -0800
hi, we have a sql server 2000 sp3 on a w2003 and some days ago we installed
sp4 to that sql instance. We are having some big problems with queries really
slow down, taking to much long to complete or locking to themselves, ie. spid
105 locked by spid 105 if you throw a sp_who2.
i've read that this was a commo ...
|
Row Versioning
Thu, 25 Feb 2010 13:04:09 -0800
I'm looking at tables that have both high insert/update activity and high
select activity and according to some information, are frequently getting
page level locks when being modified. This is increasing the time the
selects are taking.
To address this I'm considering either Row Versioning Snapshots, or
...
|
Linking/attaching access tables
Thu, 25 Feb 2010 20:55:06 -0000
Hi
Is it possible to link access tables to a sql server 2005 db? I can't seem
to find any option in Management Studio.
Thanks
Regards
...
|
Index support for PK/FK
Thu, 25 Feb 2010 12:30:39 -0800
Finding that SQL Server automatically created an index for a PK was no
surprise, in fact, it was expected - how else can uniqueness be enforced in
a system that only provides b-tree indexes.
However, finding that a FK does NOT get an index by default and that it must
be explicitly created was a huge surpris ...
|
sql server agent won't start
Thu, 25 Feb 2010 11:59:15 -0800 (PST)
hi guys
After I moved my sysdatabases and error log to another drive, I
restarted the sql server services. The databases look fine but sql
server agent won't start.
In the error log/windows event log, there's no error message except
saying "sql server agent shut down successfully" sth like that. I
checked ...
|
Disappearing Databases?
Thu, 25 Feb 2010 11:35:01 -0800
Has anyone ever seen the datafiles for a database just disappear? I saw this
on my development box the other day and just thought I messed something up.
Now, I see it again on another box. In MSS Mgmt Studio I see the icon for
the database in question, but it will not expand. I goto to look for the
dat ...
|
SQL can't calculate!
Thu, 25 Feb 2010 08:47:29 -0800 (PST)
Please someone tell me this is possible! I am trying to get the
correct calculation from a very simple division: 630/60 which is
10.5. SQL 2008 only displays 10.0. I tried every which way I can
think of. Here is all my code:
select 630/60 -- should be 10.5
select CAST( 630/60 AS decimal(10,2)) -- should b ...
|
|
|
Can you restore a backup from newer version of SQL Server to older
version, if in compatibility mode?
Thu, 25 Feb 2010 08:35:11 -0800 (PST)
Can you restore a backup from newer version of SQL Server to older
version if in compatbility mode?
i.e. there is a db on SQL2005 running in SQL2000 compatibility mode.
Can you restore a backup of this db onto SQL 2000?
I'm pretty sure the answer is no - I just want an authoratitive
answer.
Cheers,
Ja ...
|
perfmon counter
Thu, 25 Feb 2010 07:23:03 -0800
Is there a perfmon counter that reports task CPU usage similar to
sys.dm_os_tasks, or sys.dm_exec_requests?
I don't think so and in looking, I don't see any. But I thought I would
check.
...
|
SSIS Help
Wed, 24 Feb 2010 19:20:07 -0800 (PST)
I have an SSIS package that runs multiple times a day. The package
pulls all data from an AS400 table (F55EZIVD) and imports it to a SQL
table (chatt_INVOICE_ITEM_TEMP).
Now I would like to write back to the AS400 table and update a field
if the record has already pulled into our SQL DB.
Can this be done ...
|
