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 |
|
prodigy2006
Yak Posting Veteran
66 Posts |
 Posted - 2010-01-12 : 10:59:12
|
| I hear DBAs talking about processes day in and day out. What does a process mean in db terminology?May sound dumb, but i don't want to have any questions... :) Thanks! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2010-01-12 : 11:48:00
|
| It can mean a number of things:1. a SQL job2. a query3. a batch of queries4. a DTS/SSIS package5. following a procedure outlined in documentationIt's just a term to mean some sort of action.Here's an example:I need to run the defrag/rebuild process on this database as many queries aren't performing well and fragmentation is high. By that statement, I'd mean I was running my SQL job that handles it or I would be running isp_ALTER_INDEX (custom code) manually.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog"Let's begin with the premise that everything you've done up until this point is wrong." |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
prodigy2006
Yak Posting Veteran
66 Posts |
Posted - 2010-01-12 : 11:59:25
|
| Wonderful!!! Thanks so much Tara. I don't think anybody could have answered in such detail and easy way. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Process