Viewing 15 posts - 256 through 270 (of 589 total)
Would you be able to use the proc that is used for transferring logins called sp_hexadecimal?
http://support.microsoft.com/kb/246133
August 15, 2007 at 8:27 am
I don't see a major reason to not install 64-bit on any new server at this point. As long as your applications work with it that is. Would I spend...
August 15, 2007 at 8:10 am
With included values a query will also return those values when it looks up on the index. I.e. if you have Col a indexed, with Col b as an included...
August 14, 2007 at 9:17 am
Depends no the block. Most blocks in SQL are transient in nature, so as long as they go away before the timeout the procedure should finish
August 14, 2007 at 9:15 am
Karma,
I don't think anyone would really argue too hard against you with the capabilities of Access to make front ends for reports, especially one off quick and dirty reports. ...
August 14, 2007 at 5:28 am
I was a co-op student, which I guess is just about the same thing (at my school internships where not paid, co-ops where paid). It's a very low cost way...
August 14, 2007 at 5:20 am
Karen I would say that is anamoly in DBA's you describe though. At least those among us that has been doing this for a while. If I was the boss...
August 10, 2007 at 7:52 am
I agree Matt. Another one I hate is along the line of "What would be your favorite company to work for be like?"
I mean, WTH? I don't think answering "one...
August 10, 2007 at 7:41 am
I think Molly is on the right track, it might just be more complicated in 2005.
(I do not have a server I can test this on, just mentioning it to...
August 10, 2007 at 7:36 am
We had an issue here (with SQL 2005) where this happened. Declared variables inside the proc that we assigned the values passed into the procedure, and it now was fast...
August 9, 2007 at 9:53 am
All depends really... Restore is not an option as you can not restore a SQL 2005 backup on a SQL 2000 server. So DTS/SSIS would most likely be your only...
August 9, 2007 at 9:44 am
Charles, I (and 3 of my CFI friends.....) stand corrected.
Flying does actually change quite a bit, and quite often. Maybe not as radically...
August 9, 2007 at 6:05 am
Someone brought up flying... and I think some parralels could be drawn up here. I have my commercial, instrument rating, Single Engine Land and Multi Engine Land. On all of...
August 8, 2007 at 1:33 pm
Why copy the file? Restore from the backup directly without copying it first.
August 8, 2007 at 8:08 am
Viewing 15 posts - 256 through 270 (of 589 total)