Viewing 15 posts - 46,066 through 46,080 (of 49,571 total)
Do not, do not, do not regularly shrink your data files! It causes lots of fragmentation and the data files will just have to grow again. Databases need some free...
June 30, 2008 at 7:03 am
In general, no, and you mostly don't want to force the optimiser to do things a specific way, as it usually knows better.
Could you post the execution plans in xml...
June 30, 2008 at 6:58 am
That very much depends on what you want. Business Intelligence isn't a product. It's a term encompassing a several different products and technologies.
Could you please give a little more info...
June 30, 2008 at 4:28 am
Please don't cross post. It just wastes people's time and fragments replies. In addition, posts on SQL 2000 should be made in the sQL 2000 forums.
No replies to this thread...
June 30, 2008 at 4:26 am
You'll have to export each table individually to a csv file. You can use bcp, you can write a DTS package or you can use the inport/export wizard.
What does the...
June 30, 2008 at 4:24 am
What kind of information are you looking for?
The SQL error log usually records log failures with a brief reason. Also the history of the job/maintenance plan should show success or...
June 30, 2008 at 4:21 am
If you don't have some form of monitoring in place, there's no way to find out that information.
SQL 2000 does not keep track of when objects were modified or...
June 30, 2008 at 4:19 am
Firstly, make sure that G: exists and that the path G:\SQL2KData\Staging does exist and does have the required data and/or log files that SQL's expecting to be there.
June 30, 2008 at 12:35 am
Sure. See your other post.
http://www.sqlservercentral.com/Forums/Topic525175-10-1.aspx
If you want something more specific, please give us some more detail on what you're looking for.
June 30, 2008 at 12:34 am
Hmmm, not sure if you can. From what I know of xml, each plan will have to be in a separate file to be valid xml and to be readable.
Honestly,...
June 30, 2008 at 12:01 am
These links should get you started
http://www.microsoft.com/learning/mcp/mcts/sql/default.mspx
http://www.microsoft.com/learning/mcp/mcitp/dbdev/default.mspx
http://www.microsoft.com/learning/mcp/mcitp/dbadmin/default.mspx
June 29, 2008 at 10:41 am
hyeng (6/28/2008)
2) If I find that there's 11GB of empty space, Should I shrink? What's the best way to shrink or recover the empty space without causing deframentation?
In general,...
June 29, 2008 at 10:01 am
Jeff Moden (6/27/2008)
All ya gotta do now is store all of the data in a single monster EAV and you'd have it made. 😛
<Shudder>
Fortunatly I don't think anyone here's quite...
June 27, 2008 at 12:18 am
Jeff Moden (6/26/2008)
June 27, 2008 at 12:12 am
Viewing 15 posts - 46,066 through 46,080 (of 49,571 total)