Viewing 15 posts - 901 through 915 (of 1,790 total)
Ah, that makes a whole lot more sense. Yes, probably many of the data pages are being cached. Based on the time differential between queries 1 and 2 I would...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 21, 2009 at 5:22 pm
Awesome! I know being able to catch that data with traces like that are great and if you keep using it you can find other ones that need to be...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 21, 2009 at 4:17 pm
Lynn Pettis (1/21/2009)
hmmm, Got "it" I think he has!
Nice job Lynn! There were times looking at that one that I wanted to hit MY head with the keyboard but you...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 21, 2009 at 2:06 pm
Did you read that article / posting? The configuration of profiler is filtering down to those expensive queries that are running at that time and it is using a trace...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 21, 2009 at 1:45 pm
The first thing that you need to do is find out what is running in SQL Server during that time. A great link on getting together a trace that can...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 21, 2009 at 1:13 pm
The index wizard, DTA, is not the final authority in indexing for sure. It is a guideline. I would do as GSquared stated and use the set stastics io and...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 21, 2009 at 12:59 pm
You are correct that it should not look at the other table if you criteria is such that it only points to the recent table. Having said that, if the...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 21, 2009 at 12:50 pm
Being that the trace that would contain the shutdown would not be the current default trace you could query just that file. So, run select * from systraces to find...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 20, 2009 at 2:10 pm
You can use the same server. You just have to understand that this one instance will now share the load. I will say that I have quite a bit of...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 20, 2009 at 12:25 pm
Alan Vogan (1/20/2009)
DavidB (1/9/2009)
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 20, 2009 at 11:03 am
There is a bit of work to be done on this query. It would greatly help if you could provide the table definition script that you are looking to pull...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 20, 2009 at 10:13 am
Lynn Pettis (1/17/2009)
People actually wrote applications that used it, and then we had to figure out how to extract the data into SQL databases.
Dr that I mentioned earlier with Access....
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 18, 2009 at 3:19 am
It looks like there is very little data in the database based on this output so, it doesn't surprise me that the backup is pretty small. My guess is that...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 16, 2009 at 7:39 pm
This is a duplicate post. See http://www.sqlservercentral.com/Forums/Topic638614-357-1.aspx
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 16, 2009 at 7:06 pm
Can you run sp_spaceused in the database that you are backing up and post the output here (don't have to include the database name)?
Thanks.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 16, 2009 at 7:04 pm
Viewing 15 posts - 901 through 915 (of 1,790 total)