Viewing 15 posts - 36,451 through 36,465 (of 49,562 total)
Guru Nagabhushan (10/5/2009)
I am hoping that SQL 2008 doesn't have these issues and has a better algorithm for managing stats.
The stats update algorithm is unchanged in SQL 2008
The...
October 5, 2009 at 1:06 pm
repent_kog_is_near (10/5/2009)
GailThese are the 3 repeated errors in the logs..
Please post the contents (or partial contents) of the SQL error log. Need the end of the log, probably from...
October 5, 2009 at 1:02 pm
What does the SQL error log say? It's a file called Errorlog, just search for it, should be easy enough to find.
October 5, 2009 at 12:28 pm
Lowell (10/5/2009)
ouch that sysindexes is handy and i haven't found any view that still tracks that [rows] and [rowmodctr] yet.
Rows are in sys.partitions, though you should aggregate by object and...
October 5, 2009 at 12:28 pm
hanxue.lee (10/5/2009)
Since my access is read-only, I would imagine this is possible without affecting the operations of the database.
Nope. SQL takes exclusive 'locks' on the files. Can't be read or...
October 5, 2009 at 11:57 am
Just bear in mind that sysindexes is deprecated, will be removed in a future version of SQL server and that the rowmodcol is not longer 'accurate'. It's a calculation based...
October 5, 2009 at 11:52 am
wodom (10/5/2009)
October 5, 2009 at 11:51 am
Caching is something you need to do on the client, SQL doesn't have the capabilities of caching a query's result (unless you go and stick the result into a table)
If...
October 5, 2009 at 11:12 am
Guru Nagabhushan (10/5/2009)
October 5, 2009 at 11:09 am
Why oh why oh why do you not have backups?
Do note that neither ApexSQL nor Lumigent's log readers are free.
Apex SQL Log: $999 per server
Lumigent Log Explorer: Starts at...
October 5, 2009 at 11:04 am
It's safe in that it won't break the log shipping. You will need to schedule an index rebuild afterwards, as shrink can severely fragment indexes.
October 5, 2009 at 9:43 am
SQLCAT (Customer Advisory Team) did some tests a while back and found little improvement after 8 files. Hence the updated recommendation.
The other point is that SQL 2005 is much less...
October 5, 2009 at 9:40 am
homebrew01 (10/5/2009)
October 5, 2009 at 9:38 am
If there has never been a backup of the database, then no. Regardless of recovery model, if there has never been a backup of the database then the log will...
October 5, 2009 at 7:46 am
repent_kog_is_near (10/5/2009)
Now, I have removed the second part - SHRINKFILE. This has probably done 2 bad things*made Recovery to point-in-time not possible because of TruncateOnly
No, no, no!!!
There is a...
October 5, 2009 at 6:58 am
Viewing 15 posts - 36,451 through 36,465 (of 49,562 total)