1、ISO文件解压到硬盘安装，CD目录必须是server和tool，否则安装无法成功。 2、索引提高性能仅企业版有效 3、针对IBM X3850 X5或HP DL580 G7等采用最新XEON E7的六核CPU，SQLServer2005企业版必须首先MSCONFIG中奖NUMPROC设置为1或2，重启机器，安装SQLServe
1、ISO文件解压到硬盘安装，CD目录必须是server和tool，否则安装无法成功。
2、索引提高性能仅企业版有效
3、针对IBM X3850 X5或HP DL580 G7等采用最新XEON E7的六核CPU，SQLServer2005企业版必须首先MSCONFIG中奖NUMPROC设置为1或2，重启机器，安装SQLServer，下载SP3以上补丁，然后取消NUMPROC，重启机器，否则无法成功使用6核
4、由于许多SQL应用基于了共享文件的前端调用，要求在组策略中选择启用经典模式，并打上安全补丁：WindowsServer2003.WindowsXP-KB958644-x64-CHS
5、如果系统为Windows 2003 X64/X32,将网卡的高级特性TOE和RSS禁用。然后打上系统补丁：WindowsServer2003.WindowsXP-KB948496-x64-CHS，MicrosoftFixit50051，然后重启机器
6、实例安装请使用安装程序进行配置并安装。
7、当遇到SQL服务无法启动的时候，可以检查data下的库文件是否被压缩了，取消压缩
8、可以修复master系统数据库，采用start /wait setup.exe /qb INSTANCENAME=MSSQLSERVER REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=123 和 setup.exe /qb INSTANCENAME=MSSQLSERVER REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=123
sqlservr.exe -c -m
在SQLCMD下，Restore database master from disk=’ C:/Program Files/Microsoft SQL Server/MSSQL.1/MSSQL/Backup/master.bak
9、在SQLcluster下打补丁需在当前资源owner下
10、SQLcluster名字作为虚拟服务器名称，对应的群集资源名，对应的IP为群集IP,该IP和真实cluster1和cluster2在同一个public网段。需要配置应用外围配置，远程选择sqlcluter或者10.1.1.15，远程方式选择TCP和NAMES
11、SQL Studio 2008 R2无法正常显示2005的摘要以及报表
12、AD宕机会导致MSCS无效，最终导致即使SQL服务正常，但是使用SQLCLuster\test连接失败
13、MSCS资源的切换不影响SQL群集
14、可以建立多个datafile资源，每个实例使用一个datafile空间
15、SQL Server 命名实例的重命名计算机
sp_dropserver GO sp_addserver , local GO16、SQL2012的alwayson 可用性组不支持 AD域控，在SQL2005中，cluster1可以同时是AD，而SQL2012则必须使用独立的AD
17、当遇到安装过程中报错，COM+目录要求，说明DTC服务没有正确启动，设置登录NTServices密码为空，然后DOS下执行MSDTC -UNINSTALL和MSDTC -INSTALL
18、共享磁盘资源的顺序很重要，下图是配置集群的时候所注意的顺序
19、当磁盘发生无法读写的 时候，未必是磁盘的问题，更多的可能性是群集问题，群集使用磁盘的原则是每次只有1个节点使用磁盘，所以启动cluster service后可以对磁盘进行读写。
20、当SQLcluster出现 node1和2都对磁盘进行了误操作后，建议删除DNS记录，关掉1，在2上进行本机登录，初始仲裁盘和数据盘。
AUTOMOUNT
AUTOMOUNT ENABLE
AUTOMOUNT DISABLE
DISKPART>
21、多路径问题，当出现类似天佑的问题的话，重装PowerPath 5.5 SP1 64bit即可
22、群集新建失效，由于原来有已经被破坏的群集和节点失败，所以，需要以下步骤
cluster node /forcecleanup
regedit Localmachine/cluster 删除
F3在注册表中寻找cluster全字匹配，找到以前的历史记录，删除注册表内容
重新启动计算机
23、每个lun对应一个磁盘，MSCS不对磁盘号负责，对分区盘符和卷标负责，而RoseHA对ID负责。
24、当仲裁盘导致群集服务启动失败的话，可以在服务启动参数中 -ResetQuotumLogging 或者NOQuotumLog
25、对于SQLServer2000至2008R2版本来说，目前最新的JDBC驱动是sqljdbc_4.0.2206.100_chs，这里4.0是版本，chs是中文，注意了，由于字符集的问题，建议应用是英文就选择驱动是英文，应用是中文则驱动是中文，另外内含2个JAR，一个有sqljdbc4,一个没有4，这里的4是指type 4驱动，建议JDK1.4环境以上使用带4的JAR，老环境可以使用不带4的版本。
26、我们连接并测试SQLServer2008的JAVA程序如下：这个程序我单独写了一个帖子：点击打开链接
27、如果现有的SQL群集，出现了网卡硬件故障，你需要更换网卡，怎么办？ 首先，关机节点1，等资源切换到节点2后，安装节点1的网卡，配置和安装网卡驱动，配置然后配置IP地址，并禁用原来的PUBLIC网卡，将新网卡配置为和原网卡IP一致，然后重启操作系统。再将资源切换到节点1，然后再节点2上配置相同的操作，最后启动集群资源即可。启用原来的故障网卡后禁用。
What Are the Limitations of Using Views in MySQL?May 14, 2025 am 12:10 AMMySQLviewshavelimitations:1)Theydon'tsupportallSQLoperations,restrictingdatamanipulationthroughviewswithjoinsorsubqueries.2)Theycanimpactperformance,especiallywithcomplexqueriesorlargedatasets.3)Viewsdon'tstoredata,potentiallyleadingtooutdatedinforma
Securing Your MySQL Database: Adding Users and Granting PrivilegesMay 14, 2025 am 12:09 AMProperusermanagementinMySQLiscrucialforenhancingsecurityandensuringefficientdatabaseoperation.1)UseCREATEUSERtoaddusers,specifyingconnectionsourcewith@'localhost'or@'%'.2)GrantspecificprivilegeswithGRANT,usingleastprivilegeprincipletominimizerisks.3)
What Factors Influence the Number of Triggers I Can Use in MySQL?May 14, 2025 am 12:08 AMMySQLdoesn'timposeahardlimitontriggers,butpracticalfactorsdeterminetheireffectiveuse:1)Serverconfigurationimpactstriggermanagement;2)Complextriggersincreasesystemload;3)Largertablesslowtriggerperformance;4)Highconcurrencycancausetriggercontention;5)M
MySQL: Is it safe to store BLOB?May 14, 2025 am 12:07 AMYes,it'ssafetostoreBLOBdatainMySQL,butconsiderthesefactors:1)StorageSpace:BLOBscanconsumesignificantspace,potentiallyincreasingcostsandslowingperformance.2)Performance:LargerrowsizesduetoBLOBsmayslowdownqueries.3)BackupandRecovery:Theseprocessescanbe
MySQL: Adding a user through a PHP web interfaceMay 14, 2025 am 12:04 AMAdding MySQL users through the PHP web interface can use MySQLi extensions. The steps are as follows: 1. Connect to the MySQL database and use the MySQLi extension. 2. Create a user, use the CREATEUSER statement, and use the PASSWORD() function to encrypt the password. 3. Prevent SQL injection and use the mysqli_real_escape_string() function to process user input. 4. Assign permissions to new users and use the GRANT statement.
MySQL: BLOB and other no-sql storage, what are the differences?May 13, 2025 am 12:14 AMMySQL'sBLOBissuitableforstoringbinarydatawithinarelationaldatabase,whileNoSQLoptionslikeMongoDB,Redis,andCassandraofferflexible,scalablesolutionsforunstructureddata.BLOBissimplerbutcanslowdownperformancewithlargedata;NoSQLprovidesbetterscalabilityand
MySQL Add User: Syntax, Options, and Security Best PracticesMay 13, 2025 am 12:12 AMToaddauserinMySQL,use:CREATEUSER'username'@'host'IDENTIFIEDBY'password';Here'showtodoitsecurely:1)Choosethehostcarefullytocontrolaccess.2)SetresourcelimitswithoptionslikeMAX_QUERIES_PER_HOUR.3)Usestrong,uniquepasswords.4)EnforceSSL/TLSconnectionswith
MySQL: How to avoid String Data Types common mistakes?May 13, 2025 am 12:09 AMToavoidcommonmistakeswithstringdatatypesinMySQL,understandstringtypenuances,choosetherighttype,andmanageencodingandcollationsettingseffectively.1)UseCHARforfixed-lengthstrings,VARCHARforvariable-length,andTEXT/BLOBforlargerdata.2)Setcorrectcharacters
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
SublimeText3 Linux new version
SublimeText3 Linux latest version
SecLists
SecLists is the ultimate security tester's companion. It is a collection of various types of lists that are frequently used during security assessments, all in one place. SecLists helps make security testing more efficient and productive by conveniently providing all the lists a security tester might need. List types include usernames, passwords, URLs, fuzzing payloads, sensitive data patterns, web shells, and more. The tester can simply pull this repository onto a new test machine and he will have access to every type of list he needs.
ZendStudio 13.5.1 Mac
Powerful PHP integrated development environment
DVWA
Damn Vulnerable Web App (DVWA) is a PHP/MySQL web application that is very vulnerable. Its main goals are to be an aid for security professionals to test their skills and tools in a legal environment, to help web developers better understand the process of securing web applications, and to help teachers/students teach/learn in a classroom environment Web application security. The goal of DVWA is to practice some of the most common web vulnerabilities through a simple and straightforward interface, with varying degrees of difficulty. Please note that this software
Notepad++7.3.1
Easy-to-use and free code editor
