Making changes to a database that has been created by a third pary can be a difficult task, especially when you don’t want to break any of the existing stored procedures. You can search the database’s stored procedures for keywords to find which procedures use a keyword that is involved in your change. This makes it much easier in identifying these procedures so you can make the appropriate changes.
If you’re running SQL Server, it’s very wise to make sure that you have the latest service pack installed for optimum performance. If you’re not sure what service pack you have installed (or if you’re still running RTM), follow these steps to find out:
A trigger allows for the execution of SQL code anytime an UPDATE, INSERT, or DELETE command is performed on a certain table. If you are having to perform manual modifications to the table, you may not want the trigger to fire off. Here’s how to disable the trigger so that you can perform your administrative tasks:
By default, tempdb is placed on the same drive that SQL Server is installed on. This is probably not a desirable result, especially if you have installed SQL Server on the boot drive or on an IDE versus a SATA drive. To move tempdb to a faster drive and improve performance, follow these steps:
Granting Select to all tables for a login can be an extremely painful and lengthy process. Utilizing the SQL Server Management Studio to perform this means going table by table and checking the Select checkbox for each individual table, this makes a real nightmare if you are working with hundreds of tables. You can do this in mere seconds versus hours by using the Query window. Here’s how:
By default, when you create a new Excel workbook, the program will create three new sheets for you. If you usually work on only one sheet, the rest will be unnecessary. Or if you always have to work on a big workbook, then three sheets may be not enough and you have to manually create new sheet. For your convenience, you can change the program’s setting to make it include the number of sheets that you usually have to work on right at the start.
To be more productive, many Chrome users may want to carry the browser’s settings including extensions, apps, theme…. and personal data with them to any computer that they use. However, by doing so, you may mix your settings with the current browser’s settings on that computer. Fortunately, Chrome lets users setup and use multiple user accounts with different settings in just some clicks. This step-by-step tutorial will show you how to add accounts, change the settings for the accounts and remove them from the browser.
One of the benefits of email is that it’s quick, but sometimes this isn’t such a great thing if you hit Send and then remembered that you didn’t attach the intended files or include vital information. By setting up a short delay of only a few minutes, you will give yourself adequate time to catch these shortcomings prior to the message going out.
Every time when you send items like email messages, meeting notes, task notes from Outlook to OneNote, the program will ask you where you want to save them. If you always send each type of items to a particular notebook, then this feature may not be necessary. This tutorial will show you how to configure locations for each type of items when sending them from Outlook to OneNote.
If you are an advanced user, you may have many tabs open right when Firefox starts. Because all the tabs are loaded at the same time, your computer may be freeze sometimes. To avoid this problem, you can configure Firefox to load the tab only when it is the current one. This step-by-step tutorial will show you how.
By default, OneNote does not allow you to search for words in audio or video notes. Therefore, it can be very time-consuming when you have many audio or video note files and you want to search for a specific one. Luckily, you can configure OneNote to enable this feature. Here is how to do it.
To keep all downloaded files organized, many users want to save different file types to different folders. With the default download manager in browsers like Firefox, Chrome or IE… you can only set one download folder for all files. However, in Opera browser, you can set folder for each file type. This tutorial will show you how to do it.
1...357358359...525Page 358 of 525 error: Content is protected !!
