Viewing 15 posts - 5,476 through 5,490 (of 18,926 total)
The data and log files preallocate the space. So from day 1 even with 0 rows of data you can size the db at 1 TB if you want...
June 10, 2011 at 9:48 am
June 10, 2011 at 7:23 am
hkflight (6/9/2011)
but what would I join on? I need to use the like operator to compare the two strings and pull the rows that match.-Danny
Not quite what you want but...
June 9, 2011 at 4:42 pm
I've never had that in the error log (in traces yes, but not the log).
If I had only 1 guess I'd bet that you have a once a month process...
June 9, 2011 at 2:19 pm
If the data is really static just put the file as read-only. Won't need nolock and it'll be even faster!
June 9, 2011 at 11:09 am
Wow this is wrong on so many levels.
Do you have auto_close or auto_shrink on?
Please stop using sa for the connection if possible.
Make sure you have auto_create / upate stats to...
June 9, 2011 at 11:07 am
Runs 5400 times a minute to delete records older than 5 minutes?????
Index will create a stat and "may" help this out. On a table with 1 page I just...
June 9, 2011 at 10:54 am
Something likelier perharps... how about locking mixed with waiting on log autogrow once in a while?
June 9, 2011 at 10:51 am
How can you defrag a heap that has no required order?
June 9, 2011 at 10:49 am
Please post the actual execution plan, we can't do much with the jpeg.
June 9, 2011 at 10:30 am
The reason it's slow is because you pretty much always have to scan the whole table to figure out if all the matches are done. Unless and until you...
June 9, 2011 at 9:59 am
How can that be empty?
You're using a matrix right??? So if you have something for the column grouping then you have something in the data!
June 9, 2011 at 9:16 am
GilaMonster (6/9/2011)
SQL_Athmi (6/9/2011)
First SHRINK and then REORGANIZE.SINGLE MODE is good.
Rather don't shrink, just reorganise (or rebuild). No need for single user mode, both can be done without any...
June 9, 2011 at 9:06 am
Viewing 15 posts - 5,476 through 5,490 (of 18,926 total)