Viewing 15 posts - 15,961 through 15,975 (of 39,970 total)
Yes, full text changed a lot in 2008. It became Integrated Full Text Search, with additional enhancements for multi-languages, better indexing of documents and more. Check Books Online for more...
June 13, 2011 at 9:25 am
We always only return 150. You can search by keyword or topic. You have to narrow down the search in some way.
June 13, 2011 at 9:24 am
Tom.Thomson (6/13/2011)
But one major niggle and one minor niggle:
Major niggle: if page compression is enabled on a table already containing data, each page is rebuilt and evaluated for page...
June 13, 2011 at 9:16 am
Search for a cross tab query. It's not easy or efficient, especially if you don't have a set number of rows that you are changing to columns.
June 13, 2011 at 9:11 am
I am not sure how much of a difference this makes in SQL 2000, but it should help. If you can partition on a field that will remove most of...
June 13, 2011 at 9:10 am
I have not heard about any issues with it. It's a fairly simple process and works well.
The third party tools do a better job of compression, but at the expense...
June 13, 2011 at 8:57 am
Most tools don't replace something like Replication Monitor. The tools do catch errors that are logged to the Error log in SQL Server.
I have heard good things about all of...
June 13, 2011 at 8:56 am
Performance monitor has low overhead, and you can run it from your machine, but I'm not sure it's better. You want to log the data, not run it interactively.
June 12, 2011 at 10:45 am
You have to search for them. We have a performance limit of 150 posts.
June 12, 2011 at 10:44 am
Did you set an sa password? Did you add your account as an admin during setup?
Also, you aren't necessarily running as administrator on the local machine. Shift right click the...
June 12, 2011 at 9:59 am
If you changed the email in your account, all posts move with the account. You still have 433 points, which I assume mean posts.
How are you searching for posts?
Also, please...
June 12, 2011 at 9:58 am
Right click the database, select "generate script" and there is an option to include permissions.
However the easiest way to move the database is a backup and restore. That will include...
June 12, 2011 at 9:57 am
June 12, 2011 at 9:56 am
First, if you've never done this, tell your manager you don't know how to do this. Screwing up a cluster without warning someone is way worse than anything else. You...
June 12, 2011 at 9:55 am
The database will restore with user permission. however logins are not part of a backup or restore. You can script them with sp_help_revlogin (from MS) and run the resulting script...
June 12, 2011 at 9:53 am
Viewing 15 posts - 15,961 through 15,975 (of 39,970 total)