Write Article

Category

Scope and Department
    Biological (1)
    Computer (43)
    Art (2)
    Social (4)
    Education (1)
    Language (3)
    Business (2)
    Law (1)

Content Type

 Restaurant(7)
 Shop(2)
 Blog(48816)
 News(568)
 Photo Blog(262)
 Video Blog(295)
 Music Blog(86)
 Travel(18)
 Announcement(118)
 Daily Notes(154)
 Study Notes(124)
 Work Notes(84)
 Writing(54)
 Game Blog(5)
 Bookmark(54)
 Online File(229)
 Food(12)
 Research(33)
 HOWTOs&DIY(23)
 Regular Article(257)

Popular Section

 MS SQL Server DBA (cherry)
 春种一粒粟秋收万颗子 (newman1)
 教養秘笈 (雲天)
 洛杉矶移民法律中心 (LAChineseService)
 文档(Document) (gcjpxdt)
 美国房产 (Hainayufu)

Latest Section

 美国房产 (Hainayufu)
 MS SQL Server DBA (cherry)
 洛杉矶移民法律中心 (LAChineseService)
 教養秘笈 (雲天)
 文档(Document) (gcjpxdt)
 春种一粒粟秋收万颗子 (newman1)
Display: 1 - 15 of 43, Total Pages: 3
1 2 3 > >>
[Work Notes] How to detect a SQL Server database's read only status [Original] 2014-7-30 5:19pm, cherry
Query 1SELECT name, is_read_only FROM sys.databases GOQuery 2SELECT name, is_read_only FROM sys.databases WHERE name = 'MyDBName'GOQuery 3EXEC sp_dboption "MyDBName", "read only"

Read Full Article...

Section:MS SQL Server DBA | Read:935 | Comment:0 | Rating:0%

[Work Notes] How to find SQL instance name, server name, DB status [Original] 2014-7-30 4:31pm, cherry
1. find instance name and server nameSELECT            SERVERPROPERTY('MachineName') AS [ServerName],         SERVE..

Read Full Article...

Section:MS SQL Server DBA | Read:597 | Comment:0 | Rating:0%

[Work Notes] How to find SQL Server Cluster Nodes and Shared Drives [Original] 2014-7-30 4:19pm, cherry
1. Find name of the Node on which SQL Server Instance is Currently running   SELECT SERVERPROPERTY('ComputerNamePhysicalNetBIOS') AS [CurrentNodeName] ++ If the server is not cluster, then t..

Read Full Article...

Section:MS SQL Server DBA | Read:457 | Comment:0 | Rating:0%

[Work Notes] How to check SQL DB backup history [Original] 2014-7-30 4:15pm, cherry
Query 1SELECT s.database_name, s.server_name, s.machine_name,max(s.backup_start_date) as dateFROM msdb.dbo.backupset sgroup by s.database_name,s.server_name, s.machine_nameorder by dateQuery 2SELECT s..

Read Full Article...

Section:MS SQL Server DBA | Read:838 | Comment:0 | Rating:0%

[Work Notes] find fragments in indexes and optimize the indexes [Original] 2014-6-16 2:45pm, cherry
-- Be careful of executing it against large production system without detailed filteringUSE wwdev03;GOSELECT OBJECT_NAME(ips.object_id) AS Objectname,    i.name AS IndexName,  ..

Read Full Article...

Section:MS SQL Server DBA | Read:450 | Comment:0 | Rating:0%

[Work Notes] Server and database roles [Original] 2014-6-2 3:33pm, cherry
-- ADD a login to the serveradmin roleEXEC sp_addsrvrolemember mylogin, serveradmin;GO-- view the members of the server rolesuse master;GOSELECT r.name AS RoleName, p.name AS PrincipalNameFROM sys.ser..

Read Full Article...

Section:MS SQL Server DBA | Read:440 | Comment:0 | Rating:0%

[Work Notes] restore a DB STOPAT Option [Original] 2014-5-29 11:42am, cherry
Restore a db by following the following restore sequence:RESTORE DATABASE database_name FROM full_backupWITH NORECOVERY;RESTORE DATABASE database_name FROM differential_backupWITH NORECOVERY;RESTORE L..

Read Full Article...

Section:MS SQL Server DBA | Read:454 | Comment:0 | Rating:0%

[Work Notes] Change a SQL DB to read-only / read-write [Original] 2014-5-29 11:29am, cherry
-- Make Database Read OnlyUSE [master]GOALTER DATABASE [DBNAME] SET READ_ONLY WITH NO_WAITGO-- Make Database Read/WriteUSE [master]GOALTER DATABASE [DBNAME] SET READ_WRITE WITH NO_WAITGO -- Make Data..

Read Full Article...

Section:MS SQL Server DBA | Read:544 | Comment:0 | Rating:0%

[Work Notes] Recovering an offline database step by step [Original] 2014-5-28 4:57pm, cherry
Recovering an offline database step by step-- check the database state to see RECOVERY_PENDING;    SELECT name, state_desc     FROM sys.databases WHERE name='Marketdev';&..

Read Full Article...

Section:MS SQL Server DBA | Read:470 | Comment:0 | Rating:0%

[Work Notes] Backup tips [Original] 2014-5-28 11:28am, cherry
· --  Review databases and their state SELECT database_id, name, state_desc FROM sys.databases; Go · --  Review files that are used by a dev DB USE wwdev01 go SELEC..

Read Full Article...

Section:MS SQL Server DBA | Read:350 | Comment:0 | Rating:0%

[Work Notes] Set recovery model [Original] 2014-5-23 1:50pm, cherry
·         Set recovery model ALTER DATABASE Market SET RECOVERY SIMPLE; GO ALTER DATABASE Market SET RECOVERY FULL; GO ·   ..

Read Full Article...

Section:MS SQL Server DBA | Read:413 | Comment:0 | Rating:0%

[Work Notes] Check reasons of Inability to Truncate a Log [Original] 2014-5-23 1:37pm, cherry
-- Check size for a DB and LOGSELECT name AS Name,     size * 8 / 1024. as SizeinMB,    FILEPROPERTY(name, 'SpaceUsed') * 8 /1024. as SpaceUsedInMB,    CAS..

Read Full Article...

Section:MS SQL Server DBA | Read:314 | Comment:0 | Rating:0%

[Work Notes] Check backup history [Original] 2014-5-21 5:17pm, cherry
-- Check backup historyUSE msdb;GOSELECT    bs.media_set_id,    bs.backup_finish_date,    bs.backup_size,    bs.compressed_backup_size, ..

Read Full Article...

Section:MS SQL Server DBA | Read:497 | Comment:0 | Rating:0%

[Work Notes] Restore a SQL server DB by using command lines [Original] 2014-5-21 5:12pm, cherry
USE master;GOIF EXIST (SELECT 1 FROM sys.databases WHERE name = 'N'Market')    DROP DATABASE Market;GORESTORE DATABASE MarketFROM DISK = 'D:\...\Market.mdf',WITH MOVE 'MarketDev' TO 'D:..

Read Full Article...

Section:MS SQL Server DBA | Read:430 | Comment:0 | Rating:0%

[Work Notes] DBA tips: check size, log full, etc [Original] 2014-5-21 5:08pm, cherry
==check all databases' log file sizesDBCC SQLPERF(LOGSPACE);GO==check a table sizeUSE mbprod2;GOEXEC sp_spaceused N'dbo.htf43t_onstand_status';GO==check a database sizeUSE dbprod;GOEXEC sp_spaceused @..

Read Full Article...

Section:MS SQL Server DBA | Read:315 | Comment:0 | Rating:0%

1 2 3 > >>

Hottest Tags:

17  顧曉軍  history  Justice  學習  民主运动  郭旭東將軍  段海山 段海紅 趙衛華 盜採砂石 段海春 木林鎮 大韓莊  國際戰爭  北京奧運會示威區抗議A demonstration in the designated protest venues during Beijing Olimpic Games 2008  人體實驗  旅游  宗教信仰  法輪大法好falundafa's perfect  politics  腦控  詩歌    精神控制  法輪功  中國人權  修煉  新聞  SomeCustomInjectedHeader:injected_by_wvs  評論  雨風  中共  彌勒  洗腦  教育  江澤民  【分享大觀園】  政治  趙衛華  段海春  大韓莊  段海紅  盜採砂石  木林鎮  人生  段海山  人權  中國政府  addcontentsave  宗教迫害Belief Persecution  朋友  set|set&set  神韻  生活  經濟  懷孕  生命  純善純美神韻  上帝  【禁歌禁片】  貴金屬  外匯  共產黨  人权  思維隱形超限  電腦  安徽王焰  財經  彌勒佛  《何健語錄》  法輪大法  freedom  投資  健康  歐元對美元  音樂  democracy  王焰  波士頓  【辛灝年-袁騰飛專輯】  中共江蘇省委?  毛澤東  毒藥  【 地震《掩埋》的真象】  國家安全部  心的祝福  王海松  王剛  真相  慢性毒藥  武術  精神控制實驗  趙寧臣 江蘇省委 葛秀蘭  心靈之窗  李健  盧映川  【世界廣角】  搞笑  心情  【中國良心律師高智晟】  奇聞  ';print(md5(acunetix_wvs_security_test));$a='  ..%2F..%2F..%2F..%2F..%2F..%2F..%2F..%2F..%2F..%2Fetc%2Fpasswd%00.jpg  1'"  "set|set&set" 

Latest Comments:

Partners:  Dealone