|
Written by Administrator
|
|
Monday, 15 December 2008 14:34 |
|
Have you ever needed to merge data from two tables? You probably first inserted the rows that don't exist in target table then tried to match existing rows from target table with rows from source table and then update target with values from source and in the end you did something with untouched target rows. |
|
Read more...
|
|
|
Written by Administrator
|
|
Monday, 15 December 2008 08:30 |
|
Tempdb is a very important SQL Server system database. DBA should pay very meticulous attention to tempdb settings and carefully monitor usage of this db. Overall system performance strongly depends on the way tempdb is configured. Tempdb is recreated each time sql server restarts which means any data present in tempdb is lost after sql server restart. Tempdb recovery model is simple and you can’t change it. Tempdb is prohibited from creation of user defined filegroups but you may create as many files in existing filegroups as you need. Tempdb operations are minimaly logged and because tempdb is recreated after sql server restart there is no need to REDO tempdb operations so transaction log does not need to be flushed after commit. |
|
Read more...
|
|
Written by Administrator
|
|
Friday, 12 December 2008 08:21 |
|
MS SQL Server programmers and even administrators (making reports for managers from production database) quite often face the problem, that resulting record set must be numbered by some rule. For instance, top management wants the report of the best sold products grouped by category and ordered separetly within a particular category. Which would result in something like |
|
Read more...
|
|
|
Written by Administrator
|
|
Saturday, 13 December 2008 20:21 |
|
So what does actually give you being MCTS MS SQL Server 2005? First of all how to become MCTS. Check Microsft SQL Server Certified DBA path. 70-431 exam is a good beginning for you. For information about how to pass it you should visit official 70-431 exam page, sel-paced training kit is a very good resource to prepare. After you passed the exam if it was you first microsoft exam you will receive mcp id. Using it you will be able to Official MCP website. Go to welcome kits and certificates page, enter your address and submit the request. You can track status of your request right there until the moment it is shipped . After 4-5 weaks since submitting you will receive two envelopes. |
|
Read more...
|
|
Written by Administrator
|
|
Wednesday, 10 December 2008 12:45 |
|
Here is the series of scripts and tips which any Microsoft SQL Server DBA would use on the daily basis. You are welcome to use it. - Your database consumes large ammount of disk space. How to know space distribution by table?
- How to delete huje ammount of data but not a whole table to not have transaction log full and replication broken?
- How to drop all logical objects from database(functions, views, stored procedures)
- Query to archive a backup file using winrar without access to the server desktop
|
|
Read more...
|
|
|
|
|
<< Start < Prev 1 2 3 4 5 6 7 8 Next > End >>
|
|
Page 7 of 8 |
