Viewing 15 posts - 271 through 285 (of 824 total)
I think what Nanda meant was that the meta data is now secured along with access to the objects themselves, so you can't assume that any given user has access 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
*****************/
January 4, 2006 at 10:10 am
VMWare can be great for training/development/testing environments, but I wouldn't want to run a busy production SQL Server instance on VMWare.
Virtual machines are all about maximizing hardware resources, based...
/*****************
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
*****************/
January 3, 2006 at 3:53 pm
Good point! I neglected to mention the INSERT problem...
"Don't distract me with standards, they just slow me down!" Of course almost everbody who has anything to do with development efforts...
/*****************
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
*****************/
December 30, 2005 at 2:47 pm
The way most DBMSs (including SQL Server) allocate space by grabbing contiguous extents is intended to minimize the effects of file system fragmentation.
Also, since data access in OLTP envionments tends to be...
/*****************
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
*****************/
December 29, 2005 at 2:27 pm
I'm pretty sure that he was referring to file system fragmentation rather than the logical fragmentation within the SQL Server data files which is what the DBCC commands 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
*****************/
December 29, 2005 at 2:20 pm
You can script out the backups, but yes each database is backed up separately. You may not need to run a full backup if you have a recent full backup...
/*****************
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
*****************/
December 29, 2005 at 2:04 pm
So I'm going to guess you are wanting to use transactional replication.
David's initial post indicated that there were unique indexes but not PKs. If this is the case, and the...
/*****************
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
*****************/
December 29, 2005 at 1:54 pm
As a rule I don't like GUIDs as primary keys, but like most rules, there are exceptions...
I won't claim to be a replication expert (I have only used Snapshot replication,...
/*****************
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
*****************/
December 29, 2005 at 12:57 pm
Yes it can, but that depends on a number of factors such as the type of activity being performed, and the amount of freespace in the index.
I wasn't disagreeing with...
/*****************
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
*****************/
December 29, 2005 at 12:51 pm
What David says is true, but it has nothing to do with primary keys versus unique indexes per se. His is an argument to make sure your indexing strategy makes...
/*****************
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
*****************/
December 29, 2005 at 10:22 am
Tell the original developers that they are full of it! A primary key is physically implemented by a unique index but with the addition that NULLs are not allowed.
If there...
/*****************
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
*****************/
December 28, 2005 at 8:18 pm
This isn't the error usually associated with not rebooting but I just thought I'd check...
You forgot to spin in a counter-clockwise motion while throwing air and chanting Bill's name.
Have...
/*****************
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
*****************/
December 28, 2005 at 10:46 am
The problem is that you are basically "rolling your own" cursor by using the WHILE loop. Yes, you should avoid cursors if possible, but that advice should be broadened 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
*****************/
December 28, 2005 at 10:36 am
A bit more information would be helpful here...
Generally though, the default settings work pretty well. The biggest possible exception is the data file size and placement.
/*****************
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
*****************/
December 28, 2005 at 10:28 am
Have you rebooted since the uninstall?
/*****************
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
*****************/
December 28, 2005 at 10:18 am
Viewing 15 posts - 271 through 285 (of 824 total)