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...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
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...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
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...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
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...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
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...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
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...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
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...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
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...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
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:
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
October 10, 2005 at 12:58 pm
These forums are full of them...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
September 30, 2005 at 1:57 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...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
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...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
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...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
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...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
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...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
September 30, 2005 at 9:17 am
Viewing 15 posts - 301 through 315 (of 824 total)