Viewing 15 posts - 91 through 105 (of 173 total)
I wouldn't put that VPN project off, as you'll have quite a lot more to do if someone hacks into your 'sa' account from outside.
June 15, 2005 at 1:23 pm
I'd never assume that SQL will convert the way you'd expect. I believe that a conversion to integer would be seen by the execution engine as 'simpler' than converting to...
June 10, 2005 at 10:37 am
In SQL2K:
select isnull(convert(varchar(10),@X,101),'Unassigned')
June 9, 2005 at 11:50 am
I agree with Karl. Use your own procedures to implement log shipping. That way, you don't have to use the Enterprise version, nor are you stuck with SQL's implementation of...
June 8, 2005 at 10:07 am
I sold the pair of guides already. I still have 1 first edition study book for the 70-229 test (T-SQL). I'll sell it for $35 shipping included. Still interested?
June 7, 2005 at 1:25 pm
After a teleconference with the vendor, it became obvious they were used to dealing with clients that had moderately large installations (about 20 users per database) as opposed to our...
June 2, 2005 at 8:54 am
I'm an MCDBA, and I think they did help me to pass. That, and working with SQL every day. The sample questions were really useful. I'll sell the pair for...
June 2, 2005 at 8:46 am
The "no chance that the application doesn't perform well due to hardware" sounds like the most reasonable answer.
I'm going to recommend to my CIO that we buy servers when performance...
June 1, 2005 at 11:26 am
Your approach will work fine when you are the only person testing it, when you get the bugs out. But the nature of ASP apps is that you may have...
May 20, 2005 at 10:50 am
It's considered a best practice to write your select statements with explicit field names instead of star (*). There are some "hints" available that may help, such as:
NOLOCK: Do not...
May 20, 2005 at 10:42 am
Copying your post locally, or even composing it with an editor, is the best solution. There is very little that the site can do if there is a problem with...
May 19, 2005 at 9:19 am
Somewhere here there's a script for dealing with the User logins and the orphaned users on the new server. Maybe someone else will point it out to you.
May 19, 2005 at 9:09 am
I'd go with Win 2K3 Server. And make sure you get SQL Enterprise, so it will take advantage of all that extra RAM.
May 13, 2005 at 10:37 am
The simplest thing to do would be to apply SP4, and see if you get the error with that version. Though I haven't ever had an error with SP3a, there...
May 13, 2005 at 10:34 am
Viewing 15 posts - 91 through 105 (of 173 total)