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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 20, 2010 at 12:35 am
Grant Fritchey (2/19/2010)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 19, 2010 at 3:51 pm
AndrewSQLDBA (2/19/2010)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 19, 2010 at 9:13 am
David Data (2/19/2010)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 19, 2010 at 7:36 am
Sorry, I don't understand your question. What do you mean by 'starting modes'?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 19, 2010 at 2:53 am
Viewing 15 posts - 33,871 through 33,885 (of 49,552 total)