Viewing 15 posts - 16 through 30 (of 109 total)
In SQL Server 2005 and later version, you can use sys.dm_db_index_physical_stats to query size and fragmentation information for the data and indexes. http://msdn.microsoft.com/zh-cn/library/ms188917.aspx
In SQL Server 2000, you could use DBCC...
September 19, 2012 at 8:00 pm
You need to know workload characteristics when deciding which tables to compress, please could read following article.It provides some guidelines to assist in deciding what to compress.
Data Compression: Strategy, Capacity...
September 18, 2012 at 9:49 pm
found one article about error "Access to the remote server is denied because no login-mapping exists", please check whether it is the same scenario with yours.
September 18, 2012 at 9:33 pm
You can use Foreach Loop Container enumerate these files and save file path to Variable then deal with these file. Remember to move these files to other...
September 18, 2012 at 9:19 pm
Microsoft SQL Server distributed queries can be used to query data from the Exchange Web Store through OLE DB Provider for Exchange and can be joined to tables in...
September 18, 2012 at 9:12 pm
check the restore job history and there should be some useful information.
September 13, 2012 at 7:57 am
you can write a sql script to backup and clear backup files, then in schedule task, use sqlcmd to call this script.
August 29, 2012 at 2:56 am
Can you post a demo how did you run the exe or application, then i could simulate on my server.
August 2, 2012 at 6:58 pm
Have you tried DTCPing tool, the log could show more DTC info:
By the way, could you query each other successfully with Linked server?
August 2, 2012 at 8:10 am
SELECT ps.name AS PSName,
dds.destination_id AS PartitionNumber,
fg.name AS FileGroupName,fg.name,
t.name,
f.name as...
August 2, 2012 at 7:55 am
SELECT ps.name AS PSName,
dds.destination_id AS PartitionNumber,
fg.name AS FileGroupName,fg.name,
t.name
FROM (((sys.tables...
August 2, 2012 at 7:28 am
Oracle has a SYSOPER privilege allows opration such as:
instance startup,mount & database open;
alter database backup archive log and restore
This privilege allows the user to perform basic operational tasks without the...
August 2, 2012 at 7:02 am
Never used peer to peer replication before, but found this article, hope it helps.
August 2, 2012 at 3:10 am
If you don't want your DBA to view data, you could restrict his permission, not grant sysadmin or database role.
If couldn't then use encryption and audit tools.
August 2, 2012 at 3:04 am
Have you configured the DTC in OS? refer to this article:
http://technet.microsoft.com/en-us/library/cc753620(v=ws.10).aspx
SQL Server use MS DTC to control coordination of transactions .
August 2, 2012 at 2:55 am
Viewing 15 posts - 16 through 30 (of 109 total)