Viewing 15 posts - 46 through 60 (of 104 total)
Posts: 1, huh? It's obviously a troll, but I'll bite.
rhat (10/15/2007)
DBCC commands are wild goose chases when a siimple restore of backup is what's needed and needed ASAP.
Yes, let's...
October 15, 2007 at 1:41 pm
colin Leversuch-Roberts (10/15/2007)
non clustered PK, I'd say 75% of candidates have got this wrong - .
How about "Gee, I'm not sure. I don't see a good reason to...
October 15, 2007 at 1:27 pm
edu-dba -
You specifically mentioned looking for experience. Sometimes, experience can be a problem.
I have 25 years experience with the relational database lineage that MS SQL Server is...
October 15, 2007 at 9:02 am
Relax.
It's old news, for one thing, and it was very good news for of use who make a living at this instead of treating vendors like baseball...
September 19, 2007 at 9:09 am
I shouldn't give this away - but be careful of charging too little.
Years ago, when my spouse was building her business, she tried offering discounts to attract clients.
Then she...
August 29, 2007 at 10:46 am
I'd enjoy work more these days, if what Steve suggests were not true. Especially when folks write against databases that we designed and impemented 10 and 20 years...
August 17, 2007 at 8:24 am
Mike - great, I did a similar thing a few months back when one of our programmers needed to do an encrypted field for the first time (rot-13 really doesn't...
August 2, 2007 at 8:36 am
Steve makes his points well (as usual) - and cases vary. I would counter-argue
that this does NOT derail my current efforts to get all my SQL 2000 and...
July 11, 2007 at 7:35 am
Oh - which subway - the IRT, the IND, or the BMT? It's good to have a choice!
(Of course, "local" in a subway isn't so good if you...
July 2, 2007 at 10:24 am
Sorry, Steve, you lost me this time. Do you live in Iowa?
For the record - I go to my local pharmacist, not the cheaper mail order, because he can...
July 2, 2007 at 8:30 am
If all we're talking about is keeping schema in sync, it's simple enough -
I run sp__revtable on the tables on my Sybase server databases that have not yet been...
June 28, 2007 at 7:25 am
Nice set of articles. If you get inspired, here are two situations I have run into moving databases around.
1. Using detach/attach, you lose the dbo information. I've...
June 25, 2007 at 9:05 am
Another voice for XOSoft, if it suits your needs. We have a very very warm spare 25 miles away, always ready with the same databases (including master). ...
June 19, 2007 at 1:09 pm
Speaking from vast experience: "it depends".
Portability is important - but you can't predict so well what that means. I have ported the same code base from - (frontend / backend)...
June 1, 2007 at 8:12 am
Happy Aniversary. In all the celebrating, you missed the research done on SQL Server 2005 performance.
If your apps live happily inside what 32 bit can do, you won't see much.
However,...
May 29, 2007 at 1:21 pm
Viewing 15 posts - 46 through 60 (of 104 total)