Viewing 15 posts - 211 through 225 (of 824 total)
A covering index refers to a non-clustered index that is defined across all columns (in 2005 you can now have Included Columns) that a given query is after. This means...
/*****************
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
*****************/
February 20, 2006 at 3:05 pm
I ALWAYS remove builtin\administrators and I have had no problems with the SCU. You may have a different issue.
/*****************
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
*****************/
February 15, 2006 at 10:25 am
I can't say that I have done this, but since nobody else has responded... It should be possible to do this using a variable to name the worksheets. I know...
/*****************
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
*****************/
February 15, 2006 at 9:43 am
The thing about pinning tables in memory is that you want to do it for small, frequently used tables right? Well, small, frequently used tables are likely to be in...
/*****************
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
*****************/
February 15, 2006 at 9:32 am
Before you do anything make sure that you have granted yourself sysadmin rights by some other means than by being a local administrator.
Then make sure that the BUILTIN\Administrators login 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
*****************/
February 15, 2006 at 9:24 am
I would humbly suggest that allowing your programming language to dictate your choice of DBMS is not the way to go. Almost any programming language, and all of those that...
/*****************
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
*****************/
February 13, 2006 at 2:00 pm
Unfortunately, that too requires sysadmin rights to run because you have to do it through xp_cmdshell, unless you set up a proxy account...
/*****************
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
*****************/
February 13, 2006 at 1:31 pm
Rudy, I'd bump that up to 100%
Actually you can load balance across servers by using Distributed Partitioned Views, but that has proven to be much more difficult in most situations...
/*****************
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
*****************/
February 11, 2006 at 9:11 am
Anymore, performance is more a matter of application and database design rather than platform. Between DB2, Oracle, and SQL Server all of them have the ability to scale as high...
/*****************
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
*****************/
February 11, 2006 at 9:03 am
sp_OAcreate can only be executed by sysadmins.
/*****************
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
*****************/
February 10, 2006 at 7:08 pm
I'm not sure about the AMD chips, but the Itanium 2 chips are a world apart from their Xeon siblings.
We moved our mission critical databases from a 4 way...
/*****************
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
*****************/
February 10, 2006 at 1:27 pm
I don't believe that the extents are assigned an identifying name or number at all. The GAM and SGAM pages of the datafile contain a sort of bitmap that tells...
/*****************
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
*****************/
February 10, 2006 at 1:18 pm
I'm sure you think I'm just being argumentative, but the author of that article is an idiot. The most notable attribute of the article is its incoherence. He uses...
/*****************
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
*****************/
February 10, 2006 at 11:21 am
In the case of PolyServe it's because the product brings totally new capabilities as well as provides some that are SIMILAR to clustering, but it does not use Windows Clustering...
/*****************
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
*****************/
February 9, 2006 at 12:32 pm
The "best" solution depends on a combination of your business requirements and your budget...
Log shipping is sometimes seen as the "poor man's" solution, but that is far too simple. Log...
/*****************
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
*****************/
February 8, 2006 at 11:40 am
Viewing 15 posts - 211 through 225 (of 824 total)