syslockinfo, dm_tran_locks, sp_lock - performance SQL 2008
Mon, 1 Mar 2010 11:44:01 -0800
Has anyone else noticed performance issues with querying syslockinfo,
dm_tran_locks and sp_lock since upgrading to SQL 2008?
It seems they perform the worst on named instances.
SQL 2008 Server 2008 named instance - 4 seconds
SQL 2008 Server 2003 named instance - 1 second
SQL 2008 Server 2008 default instance ...
|
'Property Owner not available' error
Mon, 1 Mar 2010 07:44:01 -0800
Using SQL Server 2005. I am unable to open the Properties window for my
database. When I right-click and select Properties, I get the following
message:
Property Owner is not available for Database '[my database]'. This property
may not exist for this object, or may not be retrievable due to insufficient
...
|
FTS: can I find texts not containing a specified word?
Mon, 1 Mar 2010 07:01:01 -0800
Hi everybody,
Is there a way to find all records except the ones containing the specified
word, for example, "research''?
Unfortunately, texts don't have a common word that could be used as the
first operand for operation &!
I tried to use in CONTAINSTABLE() such combinations as "*" &! "research",
"a" & ...
|
Database detach problem
Mon, 1 Mar 2010 17:00:36 +0200
Hi group,
I need to write a script which automatically restores latest backup to test
DB.
In case that test DB is in use I first have to detach it. I write these
scripts:
USE master;
ALTER DATABASE TestDB
SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
GO
USE master
GO
sp_detach_db 'TestDB'
GO
And here ...
|
Comparing two databases.
Mon, 1 Mar 2010 15:45:59 +0100
Hello readers,
We have two databases.
Database A which holds our production data. (2 Gig)
Based on a old release.
Database B which is fresh and new and only holds initial data. (200 Mb)
This is a new release.
We want to look at the inital data and was is new (and changed) in B.
Offcourse all (or most?) ...
|
Can we backup database with batch file ?
Mon, 01 Mar 2010 20:42:30 +1100
There is a request to create a batch file to backup a database in SQL
Server 2005 (In addition to database backup in maintenance plan).
Besides, in database maintenance plan, we have set up a clean up task to
clear database backup older than 1 week. If we would like to keep the
manual (batch file) backup, ...
|
Moving Resource Databases
Sun, 28 Feb 2010 23:16:01 -0800
Hi
I have tried moving all system databases (and Resource DB) on a 2005
(9.00.3301.00) 64 bit instance to another Drive following the steps outlined
in:
http://msdn.microsoft.com/en-us/library/ms345408(SQL.90).aspx
All visible system databases were moved successfully, but the system still
looks for the ...
|
|
|
Logshipping from SQL2000
Mon, 1 Mar 2010 12:01:36 +0530
Hello,
I have ServerA which is SQL2000 Enterprise Edition(latest sp) and ServerB
which is SQL2008 Developer edition(latest sp). Can I set up Log Shipping
from ServerA to ServerB?
tia,
AbbA
...
|
Repair SQL Corrupt database
Sun, 28 Feb 2010 22:22:23 -0800 (PST)
Hi,
I have a corrupt MS SQL Server 2005 database which I
am trying to repair using:
DBCC CHECKDB ('MYDB', REPAIR_ALLOW_DATA_LOSS)
Unfortunately this does not seem to fix anything.
After running the repair multiple times, I ran
DBCC CHECKDB ('MYDB') WITH NO_INFOMSGS
to see if it fixed the corruption, ...
|
problem with select
Sun, 28 Feb 2010 13:59:01 +0100
Hi,
we have some tables with name begins with figures( like 98765_order).
This causes a syntax error when doing a select (select * from 98765_order).
Anyway to solve this easily?
Thanks
Luc
...
|