buildingcareerforu.blogspot.com
BuildingCareerForU: MS Sql Server Installation Make Easy
http://buildingcareerforu.blogspot.com/2011/01/ms-sql-server-installation-make-easy.html
Saturday, January 29, 2011. MS Sql Server Installation Make Easy. This blog is intended to help the first time users of sql server to interact sql server easily. So let's understand what we should know while installing sql server. SQL server is very interactive database engine. You will find this far more interesting when you install and start using this. Sql server comes in many editions specific to usage. A SQL Server Enterprise Edition - Specific for enterprise environment. Now you are prepared to ins...
buildingcareerforu.blogspot.com
BuildingCareerForU: January 2011
http://buildingcareerforu.blogspot.com/2011_01_01_archive.html
Monday, January 31, 2011. Shrinking DB Cause Increase In Fragmentation. Let's understand how shrinking Database can increase Index fregmentation. When the DB is shrunk, the sql server db engine goes at the end of the data pages located in the database and adjust them in the size mentioned for shrink activity. This is the reason why shrink causes data pages unorganized and result in fragmentation. Let's create a database name CitiesPopulation. And some tables like. Select * from sys.sysdatabases. This blo...
mssqlcorruptiontackle.blogspot.com
MSSQLCorruptionTackle: SQL Azure Interview Questions and Answers Part - 2
http://mssqlcorruptiontackle.blogspot.com/2011/01/sql-azure-interview-questions-and_04.html
A blog to deal with SQL Corruptions and related problems. Tuesday, January 4, 2011. SQL Azure Interview Questions and Answers Part - 2. Here you go with the second set of Interview question of SQL Azure:. Qu 5 What is the difference in accessing DB between SQL Server Vs SQL Azure? Ans: YOu connect to directly DB in SQL Azure instead of connecting. Qu 6 What encryption security is available in SQL Azure? Ans: Only SSL connections are supported. SET Encryption = TRUE. Qu 7 What is the Data Tier Application?
buildingcareerforu.blogspot.com
BuildingCareerForU: MSSQL Interview Question Clustering- Part3
http://buildingcareerforu.blogspot.com/2011/01/mssql-interview-question-clustering_2865.html
Thursday, January 27, 2011. MSSQL Interview Question Clustering- Part3. Q6 - Why is this needed to manage the max memory on failover cluster? Q7-Why antivirus should not be run on? Q8 - How to see the drives? Ans: Execute the following Transact-SQL query:. Select * from : fn servershareddrives(). Q9- Fail Resources on a group level? Ans: To prevent an automatic failback, select Prevent Failback. To allow automatic failback, select Allow Failback, and then one of the following options:. SQL Azure Intervie...
buildingcareerforu.blogspot.com
BuildingCareerForU: DBCC CheckDB The operating system returned error 21(The device is not ready.)
http://buildingcareerforu.blogspot.com/2011/02/dbcc-checkdb-operating-system-returned.html
Thursday, February 3, 2011. DBCC CheckDB The operating system returned error 21(The device is not ready.). Will Indian Rupee Cross 55? Following error can be very difficult to deal with this error if not dealt properly. DBCC CheckDB The operating system returned error 21(The device is not ready.)". Please follow following steps carefully. 1 run xp readerrorlog and find the recent errors. 2 run xp fixeddrives to see if all the drives can be read from sql server. 4 Don't detach the DB. It is always recomen...
buildingcareerforu.blogspot.com
BuildingCareerForU: MSSQL Interview Question Clustering- Part4
http://buildingcareerforu.blogspot.com/2011/01/mssql-interview-question-clustering_2337.html
Thursday, January 27, 2011. MSSQL Interview Question Clustering- Part4. Q: What is the standard setting of Lookslive, IsAlive and Pending Timeout? Ans: LooksAlive - 5 sec IsAlive - 30 sec Pending Timeout - 180 sec. Note- Do not modify Pending Timeout. The value, represented in seconds, is the amount of time the resource in either the Offline Pending or Online Pending states has to resolve its status before the Cluster Service puts the resource in either Offline or Failed status. If Yes then how? Ans: Clu...
buildingcareerforu.blogspot.com
BuildingCareerForU: Shrinking DB Cause Increase In Fragmentation
http://buildingcareerforu.blogspot.com/2011/01/shrinking-db-cause-increase-in.html
Monday, January 31, 2011. Shrinking DB Cause Increase In Fragmentation. Let's understand how shrinking Database can increase Index fregmentation. When the DB is shrunk, the sql server db engine goes at the end of the data pages located in the database and adjust them in the size mentioned for shrink activity. This is the reason why shrink causes data pages unorganized and result in fragmentation. Let's create a database name CitiesPopulation. And some tables like. Select * from sys.sysdatabases. MS Sql S...
buildingcareerforu.blogspot.com
BuildingCareerForU: MSSql Error 1088 - Cannot find the object "tuition_account_info" because it does not exist or you do not have permissions
http://buildingcareerforu.blogspot.com/2011/02/mssql-error-1088-cannot-find-object.html
Monday, February 7, 2011. MSSql Error 1088 - Cannot find the object "tuition account info" because it does not exist or you do not have permissions. Following error is a simple and most easily seen error in transaction replication. The solution is also very simple. Read following blog to solve this in minutes. MSSql Error 1088 - Cannot find the object "tuition account info" because it does not exist or you do not have permissions. If @ trancount 0 rollback tran. Subscribe to: Post Comments (Atom). Q: Wha...
tuitionaffordable.wordpress.com
SQL Server DBA “Interview Questions And Answers” | Tuitionaffordable's Blog
https://tuitionaffordable.wordpress.com/sql-server-dba-interview-questions
Just another WordPress.com site. SQL Server DBA “Interview Questions And Answers”. War Room: Avoid Silly DBA Mistakes. What after Final Year of Education? SQL Server DBA “Interview Questions And Answers”. Following are some “sql server 2008 dba interview questions” to help you in interviews. Go ahead with ten most important Microsoft SQL Server DBA Interview Questions. 1 What is the difference between lock, block and deadlock? 2 What is the meaning of lock escalation and why/how to stop this? 10 How to v...