Create knowledge
[?]
|
(rate this)
|
1
Managing Time, Scope, Budget, and Risks
2
concept design
 |
SKS Karthikeyen
| Supported idea
"Managing Time, Scope, Budget, and Risks"
| 2 years ago
|
|
It is also important to sense the early warning signals out of the systems process implemented to sustain the project progess on the defined baselines to make the project a success story.
|
|
 |
Manish K.
| Supported idea
| 3 years ago
|
|
Managing a project is. right work by right people on right time,
|
|
 |
Business Management Consultant
| Supported idea
"Managing Time, Scope, Budget, and Risks"
| 2 years ago
|
|
Each project should include definitive steps goals for each step. Attention to detail is very important. Once you have a definitive outline for the project, then the implementation/ follow-through helps a project to reach success. There is a lot...
|
|
Ideate: "Managing a Project" deleted from your view.
|
(rate this)
|
Like application design, database design is very critical to the scalability and performance of your SQL Server applications. And also like application design, if you don't do a good job in the first place, it is very hard and expensive to make changes after your application has gone into production. Here are some key things to keep in mind when designing SQL Server databases for scalability and performance. As always, you will want to test your design as early as possible using realistic data. This means you will need to develop prototype databases with sample data, and test the design using the type of activity you expect to see in the database once production starts. One of the first desi...
 |
Radhakrishna Marar
| Commented
| 3 years ago
|
|
Mr.Manish this is a very informative article but could you please tell whether it helps to reduce the number of columns in tables, which means that more rows can fit on a single data page, which helps to boost SQL Server read performance and also...
|
|
|
|
Manoj
| Commented
| 3 years ago
|
|
Manish, Excellant write-up on optimization, in fact we are pioneered in the optimization area be it MS SQL or Oracle. For an improved performance, one should look at the application tuning too apart from the database.
|
|
Insight: "How to Optimize Your Database's Design" deleted from your view.
|
(rate this)
|
How to configure Database Mirroring I have configured database mirroring with database sansu as the principal and with following 3 instances namely, Manish --- Principal Manish\Sansu --- Mirror Manish\Test --- Monitor I have drafted the following steps to configure database mirroring in SQL 2005, Step 1: Prior to configuring mirroring we need to take a full backup and1 tran log backup of the principal db and restore them in mirror with NORECOVERY option. Step 2: In SSMS expand the SQL server Manish--- expand databases- -- right click the db which is to be mirrored(in my case db name is sansu)--- select properties.This invokes the database properties window. Step 3: Click configure security ...
Insight: "SQL Server 2005 DB Mirroring" deleted from your view.
|
(rate this)
|
Question: If a user is not authorized to see a database can I exclude that database from even appearing in SQL Server Management Studio for that specified user or group? Answer: Until SQL Server version 2000 it was not possible to hide the database information from being displayed on SQL Server Enterprise Manager. In SQL Server 2005 it is possible with a new server side role that has been created. VIEW ANY DATABASE permission is a new, server-level permission. A login that is granted with this permission can see metadata that describes all databases, regardless of whether the login owns or can actually use a particular database. Please note By default, the VIEW ANY DATABASE permission is gr...
Insight: "How to hide databases in SQL Server Management Studio from unauthorised users?" deleted from your view.
|
(rate this)
|
How to Conduct Your SQL Server Performance Audit To make your SQL Server Performance Audit easy to perform, I have divided it into several sections. They include: Using Performance Monitor to Identify SQL Server Hardware Bottlenecks Server Hardware Performance Checklist Operating System Performance Checklist SQL Server 2000 Configuration Performance Checklist Database Configuration Settings Performance Checklist Index Performance Checklist Application and Transact-SQL Performance Checklist Using Profiler to Identify Poor Performing Queries Once the Performance Audit is Over, What Do I Do? The best way to conduct your SQL Server Performance Audit is to first review each of the above sections...
 |
Abhishek Tiwari
| Commented
| 3 years ago
|
|
This is only a smart part Manish , There is alot of things for SQL DB management/Auditing.
|
|
Insight: "How to Conduct Your SQL Server Performance Audit " deleted from your view.
|
(rate this)
|
Question Is it recommended to install SQL Server on a Windows domain controller? The DC is a Compaq ML 370 2x9Gb(RAID1) + 4x18Gb(RAID5), and is in a remote office supporting 20 users. The DC also doubles as a file server. Any assistance will be greatly appreciated. Answer While SQL Server can run on a domain controller, it is not recommended if you are seeking the best performance. For best performance of SQL Server, the server should be dedicated to SQL Server, and not shared with other functions, such as a domain controller or a file server. It is hard to tune servers that run multiple application, as different application may require mutually exclusive configurations. One example of this...
|
|
Abhishek Tiwari
| Commented
| 3 years ago
|
|
No never I am managing the entire database & server management. Dependency is never allowed In It sector.
|
|
Insight: "Is it recommended to install SQL Server on a Windows domain controller?" deleted from your view.
|
(rate this)
|
Below are the average annual salaries of the United States top 12 paying jobs according to the most recent Employment Policy Foundation study. Top Paying Jobs : Doctors, physicians and surgeons - $147,000 Aircraft pilots - $133,500 Chief executives -- $116,000 Electronic and electrical engineers -- $112,000 Judges and lawyers -- $99,800 Dentists -- $90,000 Pharmacists -- $85,500 Management analysts -- $84,700 Computer and information system managers -- $83,000 Financial analysts, managers and advisors -- $84,000 Marketing and sales managers -- $80,000 Education administrators -- $80,000 It is probably not surprising to learn that all of the top paying jobs require at least a four year colle...
 |
Deepali Gulati
| Commented
| 3 years ago
|
|
Thanks for Sharing, This should be send to the management, so that they can improve on underpaid employees
|
|
Trends: "Top Paying Jobs" deleted from your view.
|
(rate this)
|
Data Warehousing and Reporting rehousing and Reporting Replication is often used in data warehousing and reporting applications to: Consolidate data so it can be transformed and moved into the data warehousing environment. Distribute data to read-only databases for reporting. Distribute data to an online analytical processing (OLAP) database. Although replication does not replicate Microsoft SQL Server 2005 Analysis Services (SSAS) objects (for example, dimensions or cubes), it is often used to distribute data from online transaction processing (OLTP) databases to staging databases and databases that are used for reporting, decision support and analysis purposes. The following diagram shows ...
Insight: "Data Warehousing and Reporting" deleted from your view.
|
(rate this)
|
The SQL Server Development Team at Microsoft has been doing some great work with Integrated Full Text Search (iFTS) in SQL Server 2008. The iFTS feature is available in the February CTP of SQL Server 2008. Simon Sabin , who is an active SQL Server MVP in the UK, has a good series of posts talking about performance improvements with iFTS compared to the old FTS in SQL Server 2005. What I have seen with iFTS on CTP6 is that it does perform much better than SQL 2005 FTS (at least for our workload), but there are a few issues to be aware of with this CTP. First, (especially if you have a heavy insert/delete load on your base table), you should use manual change tracking instead of automatic cha...
 |
prashant pamani
| Commented
| 2 years ago
|
|
USE [Customer] /****** Object: Table [dbo].[OCRDocument] SET ANSI_NULLS ON exec sp_fulltext_database 'enable' SET QUOTED_IDENTIFIER ON IF NOT EXISTS (SELECT * FROM sys.fulltext_catalogs WHERE name = N'FullTextSearch_Catalog') BEGIN CREATE FULLTEXT...
|
|
Insight: "Integrated Full Text Search (iFTS) in SQL Server 2008" deleted from your view.
|
(rate this)
|
In merge replication there is a limitation in the maximum number of articles that you can publish, which is 256. However, this limitation is 32,767 articles for snapshot and transactional replication. This is a very small number of articles for large systems, however the following workaround can be used to publish additional articles. 1. Create several publications so that one publication does not contain more than 256 articles. However, if you have several publications it may lead to a reduction in performance. OR 2. a. Generate a script for your publication and save the script file b. Now delete the all articles for the publication c. Run the snapshot agent, it will run successfully witho...
Insight: "How to replicate more than 256 articles in Merge Replication?" deleted from your view.
Follow me on
