Viewing 15 posts - 271 through 285 (of 392 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;-)
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
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....
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
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....
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
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...
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
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...
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
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...
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
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...
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
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...
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
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...
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
September 24, 2010 at 7:01 am
Good question - and a great way to review the basics.
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
September 21, 2010 at 5:59 am
Thanks Nakul for a very good question and to Hugo for the detailed explanation.
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
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.
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
September 14, 2010 at 6:25 am
Great QOD Hugo. Really makes you think.
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
August 24, 2010 at 6:12 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...
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
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...
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
August 20, 2010 at 11:04 am
Viewing 15 posts - 271 through 285 (of 392 total)