Today I was working with creating a rolling date based partition scheme. In this scheme I wanted to switch out the earliest date range so I could switch in the new. To do this you need to create a staging table. My question was how do I create this in such a way that if I make changes to the table this code will not need maintenance? First thought was to do a select into unfortunately the select into does not support direction to a fileGroup which with switching out the data this staging table h...
Read More
During the process of trying to Schedule a subscription in reporting servies with a large report I received this error: This is easily corrected by changing the Web.config file for Reporting Services this is located on your Report Server in the reportManager directory as shown: Edit this Web config file adding or replacin with this line <httpRuntime executionTimeout = "9000" maxRequestLength="500000" /> This will incress the timeout and the length of the data able to be pushed to the repor...
I recently had an issue that I wanted to verify that my partitioning strategy was working and distributing the workload as I hoped. Windows 2008 has a great feature to do this built into Task Manager. First open Task Manager by right clicking toolbar and selecting start task manager (nothing new there). Then just click resource monitor and open DISK by double clicking and then sort by write by double clicking the header for write b/min. This proves to be a very useful way to see if your tempdb i...