Viewing 15 posts - 301 through 315 (of 824 total)
You don't have the ability to specify which files in a given filegroup your table will be allocated to. If you have multiple files in a single filegroup SQL Server...
November 1, 2005 at 11:09 am
BOL has an article that describes how to do this using Enterprise Manager, but not T-SQL. Look for "switching filegroup" and you should find it. I did this a while...
November 1, 2005 at 9:42 am
Just noticed the post...
I'm familiar with Cache. Sure hierarchical dbms'es are fast at storing/retrieving hierarchical data, as long as the structure doesn't ever change. For data that isn't inherently hierarchical (most...
October 29, 2005 at 8:12 am
I hadn't heard of RDF before, but after a quick scan through a couple of documents it looks like it's nothing more than XML shorthand. I does seem to address...
October 29, 2005 at 8:03 am
Nice article Steve.
I don't think Steve was implying that you should pigeonhole yourself, but rather that you should find out which specific areas you are interested in, and that the business is...
October 25, 2005 at 4:42 pm
It sounds like you need to differentiate between your parts table which contains the attributes of the parts and a work table which indicates which parts are to be installed...
October 20, 2005 at 12:39 pm
Differential and file-group backups will probably be an essential part of your backup strategy. Read about them and experiment with them in a test environment. You will still need to...
October 11, 2005 at 10:48 am
Once you start to approach or exceed the terabyte range you need to start thinking in terms of differential and file group backups. SQL Litespeed is a great product, but...
October 11, 2005 at 9:51 am
Someone sent me an email with the following question and I thought that both the question and answer might help someone else so I am posting it here:
October 10, 2005 at 12:58 pm
Access doesn't implicitly convert the bigint to a text column so it blows up. If you create a view that casts the bigint to a varchar and define a linked...
September 30, 2005 at 1:56 pm
Unique constraints are enforced by the creation of a unique index. There is no difference in either performance or functionality. About the only difference is that if you just create...
September 30, 2005 at 1:35 pm
Probably because Access can't deal with numeric values that big. Access has an integer and long integer data types, but these correspond to SQL Server's small integer and integer data...
September 30, 2005 at 11:59 am
I was going to ask Mike to clarify that comment too, because if I read it correctly, it betrays a pretty serious misapprehension of both the logical need for keys...
September 30, 2005 at 11:11 am
As long as we're beating a dead horse...
Since the example in the article doesn't provide the DDL, you might assume that the key has been (or could be) defined across...
September 30, 2005 at 9:17 am
Viewing 15 posts - 301 through 315 (of 824 total)