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 |
|
DBA-LEARNER
Starting Member
9 Posts |
 Posted - 2008-04-29 : 23:55:37
|
| Hi,I am new to this forum, could any one help me in scripting the INDEXING on all the databases which runs weekly basis on setting up through the JOB.I thank everyone who help in this urgent request.Regards |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-29 : 23:57:32
|
| Check out Tara's Blog. |
 |
|
|
DBA-LEARNER
Starting Member
9 Posts |
Posted - 2008-04-30 : 00:31:25
|
| Can I get that Link PleaseRegards |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-30 : 22:23:00
|
| What do you mean INDEXING on all the databases? Rebuild index on all dbs? |
|
|
|
DBA-LEARNER
Starting Member
9 Posts |
Posted - 2008-05-01 : 00:30:29
|
| Indexing all tables in a database.Someone can help me in this regard. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-01 : 09:35:11
|
| Check BOL for syntax for creating indexes and check www.sql-server-performance.com for help |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-01 : 23:43:10
|
| >> Indexing all tables in a databaseYou create index on column in the table, not on table. Which column needs index depends on queries you want to run against the table. |
|
|
|
|
|
|
Indexing on Databases