Blogs about: 3 Ms Sql Server
Featured Blog
SQL Server 2008 Cluster installation on Windows 2008 Enterprise Server
SQL Server 2008 Cluster installation on Windows 2008 Enterprise Server By Jeff Han 2009.09.30 1. Windows 2008 cluster ring installation When you are trying to create windows 2008 cluster ring, you wil… more →
DBA Sensation
SQL Server 2008 Cluster installation on Windows 2008 Enterprise Server
zhefeng wrote 1 month ago: SQL Server 2008 Cluster installation on Windows 2008 Enterprise Server By Jeff Han 2009.09.30 1. Win … more →
enable a disabled sql agent service
zhefeng wrote 1 month ago: When SQL Server 2005 Management Studio’s Object Browser shows the SQL Server Agent service wit … more →
table usages for ms sql database
zhefeng wrote 2 months ago: This STP help us find usage for any objects (includes table) sp_spaceused [object_name] By combining … more →
MS SQL Server 2005 alias doesn't work on 64bit platform
zhefeng wrote 4 months ago: we recently upgraded our 1 cluster from 32bit platform to 64bit platform. In order to launch the rep … more →
How to make user to view they jobs in sql 2005
zhefeng wrote 6 months ago: i tried to make user able to see their own jobs in sql 2005. First thing you need to assign job owne … more →
How to connection sql server named instance SSIS service
zhefeng wrote 7 months ago: I’ve occasionally run into the following error when attempting to connect to SSIS from Managem … more →
sql server cluster re-ip best practise
zhefeng wrote 9 months ago: Changing IP addresses for sql server 2005/2000 cluster basically bases on two steps: 1. changing vir … more →
error for dynamic sql on sql server
zhefeng wrote 9 months ago: i made a Stored procedure for dropping tables older than 6 months, it was running ok by failed recen … more →
How to Run a DTS Package as a Scheduled Job
zhefeng wrote 11 months ago: SUMMARY A problem that you might frequently encounter with a Data Transformation Servic… A pro … more →
Find Long running queries in SQL2005
zhefeng wrote 11 months ago: The following query shows you the long running queries in the database by combination of few dynamic … more →
Change Schema Name or owner on Tables and Stored Procedures in SQL Server 2005
zhefeng wrote 12 months ago: i found a useful doc from http://www.orcsweb.com/articles/change_schema_name.aspx “Change Sche … more →
Comparing SQL Server 2005 High Availability technologies
zhefeng wrote 1 year ago: i found a good chart to compare all sql server HA options (http://www.microsoft.com/technet/prodtech … more →
Mapping of Fixed Database Roles to Permissions
zhefeng wrote 1 year ago: db_accessadmin Granted: ALTER ANY USER, CREATE SCHEMA Granted: VIEW ANY DATABASE db_accessadmin Gran … more →
Fix orphaned users in SQL Server
zhefeng wrote 1 year ago: Every time I restore a database, I forget how to fix the orphaned users. So I google, trying to fin … more →
ms sql 2005 memory usage investigation
zhefeng wrote 1 year ago: one of the production sql2005 is consuming large memory. Try to investigate which process is eating … more →
