Viewing 15 posts - 33,871 through 33,885 (of 49,552 total)
I don't think it's just the lack of indexes that's hurting you (fwiw, you can create some indexes on table vars), it's lack of statistics. The optimiser's going to be...
February 20, 2010 at 11:49 am
Multiple log files does not reduce log waits. The files are used sequentially, not in parallel. Having 2 200MB log files is no different from 1 400MB log file.
What's the...
February 20, 2010 at 12:41 am
There's an entire chapter on SQL's startup procedure in the book "SQL Server 2005 Practical troubleshooting"
In summary (and not necessarily in completely the correct order, some stuff runs in parallel):
Start...
February 20, 2010 at 12:35 am
Grant Fritchey (2/19/2010)
February 19, 2010 at 3:51 pm
AndrewSQLDBA (2/19/2010)
February 19, 2010 at 9:15 am
AndrewSQLDBA (2/19/2010)
I was at the understanding, and have tested this, that once the data is committed to the database, that is can be removed from the transaction log.
Yes, and...
February 19, 2010 at 9:13 am
David Data (2/19/2010)
February 19, 2010 at 9:08 am
Still not following.
Are you interested in the startup process of the SQL service or the login process for a user connection?
February 19, 2010 at 9:06 am
As the checkDB output says, REPAIR_ALLOW_DATA_LOSS is the minimum level needed to repair. Hence REPAIR_REBUILD will do nothing.
Since you have no backup (why not?) you have little choice other than...
February 19, 2010 at 8:36 am
Not enough info. The messages are always truncated in the history log. Go into the job, set up a file to log output to and check what's in that file...
February 19, 2010 at 8:19 am
Ser Tharg (2/19/2010)
In my situation I'd expect the space freed not be reused.
Not ever?
In that case, do a once-off shrink followed by a rebuild of all indexes. I've got...
February 19, 2010 at 7:36 am
Sorry, I don't understand your question. What do you mean by 'starting modes'?
February 19, 2010 at 5:25 am
GilaMonster (2/18/2010)
Lynn Pettis (2/18/2010)
No kidding. That's more than my house payment.
It's about 5 times my house payment.
To give you a rough idea, I pay around R500/month for 512kb/s with...
February 19, 2010 at 4:24 am
Take a look at this blog post. http://sqlinthewild.co.za/index.php/2010/01/12/in-vs-inner-join/
February 19, 2010 at 2:54 am
sanketahir1985 (2/19/2010)
because in first query both the table will be scanned only for condition a.name=b.name
In second query whole table2 will be scanned then it will be...
February 19, 2010 at 2:53 am
Viewing 15 posts - 33,871 through 33,885 (of 49,552 total)