Viewing 5 posts - 46 through 50 (of 50 total)
seems like a number / tally table would do well here; basically you want an insert for each month regardless of if there were sales for that month, if I'm...
April 19, 2009 at 11:33 am
If you have scheduled a backup to take place every 15 minutes, then SQL Server will create a new TRN file every 15 minutes; the size of that file merely...
April 18, 2009 at 2:17 pm
One additional warning about setting the AutoGrowth size on your databases, especially if you're using SQL 2005, no service packs. Generally the recommendation (and it was mentioned in this...
April 17, 2009 at 5:30 am
The answer you're looking for here is, no, you're not under memory pressure. The Page Life Expectancy number could be interpreted as: if a page is loaded into...
April 15, 2009 at 2:57 pm
If you're seeing the total memory counter at 28GB, then SQL Server is actually using 28GB of RAM. One of the main features of SQL Server is that it...
April 15, 2009 at 10:43 am
Viewing 5 posts - 46 through 50 (of 50 total)