Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sql_er
Constraint Violating Yak Guru
267 Posts |
 Posted - 2011-07-19 : 17:46:53
|
| Hi,I recently started working in a new company. My role will be on a development side. As a first task, I plan to familiarize myself with the databases as much as I can(schema/data/...).I am coming from SQL Server 2000 background, but the new role is with SQL Server 2008. What tools/scripts would you guys advise to quickly get an idea of the database? Perhaps use DMVs to find out table sizes, columns, indices, triggers, and so on?Please adviseThank you! |
|
|
Sachin.Nand
2937 Posts |
|
|
sql_er
Constraint Violating Yak Guru
267 Posts |
Posted - 2011-07-21 : 09:13:09
|
| Unfortunately there is no documentation available, which is why I need to dig in and figure out on my own. I'm sure others had to do this exercise, which is why I'm asking for useful scripts to learn the new terrain.Thanks! |
 |
|
|
muratos
Starting Member
22 Posts |
Posted - 2011-07-22 : 10:53:01
|
| You can use SQL Profiler to see which queries are executing on the server. This can give an idea about the business logic. Plus, open stored procedures. They should have meaningful names and maybe you will find commentaries inside the scripts.http://ipad2keyboard.nethttp://ipad2covers.org |
|
|
|
|
|
|
Getting familiar with a new database server