Viewing 15 posts - 301 through 315 (of 392 total)
Had to really dig through the cob webs on this one. Great piece of trivia:rolleyes:
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 13, 2010 at 5:19 am
Question is terrible!
Took a guess because the error that should have come up was not listed, so had to guess.
Had you at least tested your QOD before posting it,...
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 12, 2010 at 8:02 am
Good question, thanks
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 11, 2010 at 7:09 am
Hugo, very good question.
Reading my question now, many weeks after submitting it, I am wondering if I even should have written it like this - QotD should test SQL understanding,...
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 10, 2010 at 6:42 am
Also, to use Paul Randall's method from a couple of weeks ago - this is for my point I lost
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
July 22, 2010 at 6:26 am
I must add my own .02 to this thread. I to come up with the correct answer being wrong. Using the reference given, I see that some of the indexes...
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
July 22, 2010 at 6:24 am
What level of authority does the new startup login have?
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
July 15, 2010 at 8:28 am
Yes Gail, but in Africa if you want to maintain the business, you have to be prepared for this situation (accepts blaims).
I am confused. Contractually, are you responsible for 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
July 13, 2010 at 9:30 am
That is truely a great attitude. Did they understand what needed to be done to maintain the database as well as the consequences if they didn't?
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
July 13, 2010 at 9:09 am
River - First it sounds like as Paul stated the database is corrupted or possibly you are not on the same version of SQL Server as the customer. Have you...
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
July 13, 2010 at 8:46 am
I may be a bit slow on this, and am not going to be as adament on it as Dave, who has been having this very same arguments for 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
June 25, 2010 at 1:29 pm
Not on a simple select *
Unless possibly there is a problem with the statistics on the clustered index.
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
June 25, 2010 at 9:23 am
That's not what you said though. Here is what you said:
"If there is a clustered index on the table it will return the data in the order of the PK."
I...
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
June 25, 2010 at 6:46 am
The original comment was about records being loaded using bcp into a table with no PK or other indexing, and adding it after. (This was my original comment 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
June 25, 2010 at 6:16 am
one more example:
Removing the PK from the id field, and placing it on your x field returned the following:
x z...
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
June 25, 2010 at 6:01 am
Viewing 15 posts - 301 through 315 (of 392 total)