Viewing 15 posts - 556 through 570 (of 1,354 total)
Thanks for taking the time to write this. Took me way beyond what I've done with the OVER function.
October 14, 2015 at 8:17 am
We put everything in default filegroup. Our clients' databases don't exceed 50GB, mostly they are 5-10GB. At least 50% of that is our logging data rather than their real-world data
While...
October 14, 2015 at 7:27 am
RonKyle (10/13/2015)
A downside I've seen is that when I adopted this method I had to stop putting my indexes in a different file group because of the restore issues.
I...
October 14, 2015 at 7:24 am
Adding equally sized tempdb data files can relieve this contention
This helped a lot where at another place I worked and is now one of the first things I do if...
October 13, 2015 at 6:59 am
I use filegroups with my large OLAP database to group the tables by data source. Especially as one source loads only once per month, it allows me to load...
October 13, 2015 at 6:55 am
This tends to be something to approach with caution. If the value isn't going to have math done on it then it is probably isn't a number. A US ZIP...
October 7, 2015 at 12:14 pm
Moreover, if the value is unknown or unavailable you’ll see a blank string, such as ‘ ‘. It is...
October 6, 2015 at 6:06 am
How do I justify pulling time away for whatever reason and getting less done?
Some things have to happen on your own time. For those with young families that...
October 1, 2015 at 7:03 am
I have found that walking While thinking allows me to gain insight into issues
Me, too.
October 1, 2015 at 6:46 am
I have reworded to ask about classes.
So... how do we get to answer the question again with the revised wording?
September 24, 2015 at 12:07 pm
I agree; poor question with no correct answer. How can a count of rows in a table that lists Classes return a "count of subjects in each"?
I agree with...
September 24, 2015 at 7:31 am
1. When I got those errors in deployment, did I already overwrite the working project deployed?
2. When you edit the namequery of one of your table in the datasouce view...
September 22, 2015 at 7:03 am
This question has been asked several times on this forum. You could do a little searching, too.
September 18, 2015 at 9:27 am
Second thought, I can see records that entered 2 months ago, pretty recent, and we did not change any schema, or drop constraints , disable contraints [sic], etc. so still...
September 8, 2015 at 6:00 am
Viewing 15 posts - 556 through 570 (of 1,354 total)