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...
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.
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...
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...
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...
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...
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...
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...
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...
February 11, 2006 at 9:03 am
sp_OAcreate can only be executed by sysadmins.
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...
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...
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...
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...
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...
February 8, 2006 at 11:40 am
Viewing 15 posts - 211 through 225 (of 824 total)