Viewing 15 posts - 271 through 285 (of 391 total)
Where is the option for violating the rule "Don't attempt to cram 10 table's worth of entities and attributes into 1..."
OFF WITH THEIR FINGERS;-)
September 24, 2010 at 1:28 pm
Robert Frasca
The uniqueifier is created when a non-unique clustered index is created. This makes the clustered index unique. Did you actually define that clustered index as the primary key, i.e....
September 24, 2010 at 8:59 am
We had Spotlight for a long time from Quest Software, but they do not seem to be keeping it up to the changes with the new versions of SQL Server....
September 24, 2010 at 8:52 am
Robert Frasca (9/24/2010)
Sorry, my bad. What you're speaking of is if no clustered index exists. It will add one. What I'm speaking of is if a clustered key exists but...
September 24, 2010 at 8:32 am
jeff.mason
It happens under the hood, and always has AFAIK. If there isn't a uniqueidentifier replication will add one to every table on the system and if replication is deleted, the...
September 24, 2010 at 8:20 am
Quoting BOL (gasp) again (from the uniqueidentifier TSQL reference article):
I use replication heavily in our stores, to move high priority data back and forth with HQ. I personally have not...
September 24, 2010 at 7:45 am
The problem lies in that fact that xp_cmdshell does not recoginize lang windows paths but we can still use shortend path names with tilde (~) in them.
This is actually a...
September 24, 2010 at 7:15 am
Hugo Kornelis (9/24/2010)
--------------------------------------------------------------------------------
if the table is used in replication, ..., SQL Server requires that a surrogate key with the UNIQUEIDENTIFIER data type is also present in the table.
I cannot...
September 24, 2010 at 7:06 am
Having read through the many intelligent comments, I find it amazing that over the past 25+ years, the arguments have not changed. First though, I feel that the question could...
September 24, 2010 at 7:01 am
Good question - and a great way to review the basics.
September 21, 2010 at 5:59 am
Thanks Nakul for a very good question and to Hugo for the detailed explanation.
September 16, 2010 at 8:05 am
Good question - almost got me. If i hadn't have reread the code and noticed the way the rollback was written. Proves that rereading code is good.
September 14, 2010 at 6:25 am
First, why did you create the publication on server 1 before backing up and restoring the database on server 2?
Can you detatch the database on server 1, copy it to...
August 20, 2010 at 2:19 pm
Exactly how did you get the database onto the subscriber? Was it a restore? Did you detatch the database, copy it over and attach it? What version of SQL Server...
August 20, 2010 at 11:04 am
Viewing 15 posts - 271 through 285 (of 391 total)