Viewing 15 posts - 286 through 300 (of 492 total)
Ninja's_RGR'us (1/5/2011)
Thanx. But what I need is to be able to control how much data I keep in the trace (above and beyond 5 files @ 20 mb).
What I...
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
January 5, 2011 at 2:49 pm
Craig Farrell (12/30/2010)
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
December 30, 2010 at 4:56 pm
marc 96091 (12/22/2010)
GilaMonster (12/22/2010)
Please post table definitions, index definitions for the contacts table as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/Sorry, I went back and added the attachments
I can't see much besides the insert into...
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
December 22, 2010 at 2:08 pm
Going back to your real issue, that of re-initializing the subscriber, you may need to look at how you are doing this.
In SQL 2005 schema changes may be replicated to...
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
December 21, 2010 at 1:00 pm
As Jason says, low rows per page really means wide rows. In my old mainframe days we could manage the size of the page, this allowed us to calculate an...
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
December 21, 2010 at 12:04 pm
Note this article: http://support.microsoft.com/kb/264474
Taking it one database at a time.
Model: Unless you have modified the Model database for your particular requirements there is no real reason to move it to...
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
December 12, 2010 at 4:44 pm
In theory yes, but I question why you want to do it this way. There are a few issues that can cause you problems.
Firstly you can backup the resource database,...
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
December 12, 2010 at 1:50 pm
It's not as black and white as that.
I do have an issue with SQL creating schemas for every user, and I tend to delete them and set all users default...
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
December 2, 2010 at 12:57 pm
In general knowing that most vendors don't like client messing with their DBs, I've used a different approach to this problem. I would rather add my own database to the...
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
November 28, 2010 at 1:45 pm
Iulian -207023 (11/24/2010)
It seems that table size does not change immediately, might this be because of the statistics update frequency?Iulian
If you are using sp_spaceused you will often get out of...
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
November 24, 2010 at 12:18 pm
Yes, I've seen similar behavior, although not exactly the same as your first example I have seen the second one.
2 things I've learned about the DMV Index recommendations. Don't accept...
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
November 23, 2010 at 2:00 pm
Have you tried doing a restore with REPLACE? You should be able to use any database backup as long as you make the database name match and use WITH MOVE...
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
November 23, 2010 at 1:38 pm
Patricia Johnson (11/22/2010)
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
November 22, 2010 at 8:31 pm
marko61 (11/18/2010)
Are you able to advise which trace counters would be most useful to break down the different stages around the cursor?...
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
November 18, 2010 at 5:52 pm
I've got to second Lutz here. It sounds from what you said that you ran the SELECT statement of the cursor and it ran in "0" seconds, but when you...
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
November 18, 2010 at 3:35 pm
Viewing 15 posts - 286 through 300 (of 492 total)