Viewing 15 posts - 15,811 through 15,825 (of 39,824 total)
LOL, 23..... Everything is weird at 23.
I think I had pop-tarts for awhile in my 20s at various jobs. Easy way to start the day.
At 44, I've switched to protein...
June 13, 2011 at 9:52 am
Our "real world financial problem" individual sent me a note that he got a "real answer" on the MSDN forums.
He ignored the fact that someone on the thread said...
June 13, 2011 at 9:49 am
Look at the columns in the DMV. Create a table with the same columns, perhaps with one more for timestamping. Then insert data from the DMV select into that table.
June 13, 2011 at 9:32 am
A second for ALZDBA's article on trace, and second that Grant has noted trace is what you need, not Profiler.
Another note. Management shouldn't care how you do this. Your job...
June 13, 2011 at 9:29 am
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
Viewing 15 posts - 15,811 through 15,825 (of 39,824 total)