Viewing 15 posts - 16,321 through 16,335 (of 39,944 total)
Craig Farrell (4/28/2011)
Steve Jones - SSC Editor (4/28/2011)
I posted a note about understanding your access patterns for data, meaning...
April 28, 2011 at 3:41 pm
There is still no guarantee of the ordering of the data. Regardless of how it is stored, it will not be returned by a SELECT in that order without an...
April 28, 2011 at 12:35 pm
Grant Fritchey (4/28/2011)
Steve Jones - SSC Editor (4/28/2011)
I posted a note about understanding your access patterns for data, meaning...
April 28, 2011 at 12:33 pm
GilaMonster (4/28/2011)
Steve Jones - SSC Editor (4/28/2011)
April 28, 2011 at 12:32 pm
Really the basics, Tom. Something between the DB Design one Paul White wrote and the crazy relational debate. A "normalization" for dummies, and I'd like to have a separate article...
April 28, 2011 at 12:20 pm
Since I have the collective braintrust here, and you're posting technical stuff.
I posted a note about understanding your access patterns for data, meaning hitting tables how often and how concurrently....
April 28, 2011 at 12:18 pm
Yes, but it's more that if you are querying large ranges in both OrderHeader and OrderDetails and possibly aggregating or adding in lookup information from other indexes.
The benefit from separate...
April 28, 2011 at 12:17 pm
Is DATENAME not something you want?
You're not really describing this well, either in your first post or this last one.
April 28, 2011 at 12:14 pm
I'm not quite clear what you are doing here.
Can you provide a short sample of test data and the source? Is this is in a table or in XML for...
April 28, 2011 at 10:53 am
Syed Jahanzaib Bin hassan (4/28/2011)
April 28, 2011 at 10:43 am
I don't think that tempdb is ever redundant. It's used for a variety of things as mentioned above, and it isn't necessarily because of memory.
April 28, 2011 at 10:26 am
The restore syntax is the same. Not a big deal there. However the startup parameters for master might need to be changed in a DR situation. In the services applet,...
April 28, 2011 at 10:17 am
First, AFAIK, you cannot separate a table across filegroups. You can separate across files, but not filegroups. The exception is partitioning.
You can move a table's data to a new filegroup...
April 28, 2011 at 9:56 am
One thing to keep in mind, if you are looking for partial database recovery in a DR situation, moving the indexes away from the table can cause issues. Think about...
April 28, 2011 at 9:51 am
Jim has some good advice here. The main problem is trying to track the web user. If you move to requiring the person accessing the web site to log in,...
April 28, 2011 at 9:13 am
Viewing 15 posts - 16,321 through 16,335 (of 39,944 total)