Viewing 15 posts - 4,951 through 4,965 (of 9,643 total)
Check out this article
June 1, 2009 at 7:11 am
Are you doing the restore using Enterprise Manager or T-SQL in Query Analyser? If you are using EM can you run Profiler when you are doung the restore and...
June 1, 2009 at 6:59 am
I like it Jeff. I always forget about STUFF(). It's a great function.
May 29, 2009 at 3:37 pm
Here is some code you can put in a Script Task that will find the value "ProductA" in the file and then set the Package Variable ProcessFile to either true...
May 29, 2009 at 3:35 pm
It definitely won't work correctly for -360 offset as my code assumes that the offset is just whole hours with the first digit hours and the other 2 minutes. ...
May 29, 2009 at 3:14 pm
Try wrapping the text in double-quotes.
="1,2,3,4,5"
May 29, 2009 at 2:44 pm
Can you provide the code/expression you are using? What is the data type of the parameter?
May 29, 2009 at 2:18 pm
I'd use NT Authority\System. You don't need\want network access so there is no reason to use Network Service.
This is a step that was missing in earlier versions which is...
May 29, 2009 at 2:07 pm
Gail's example for turning off Auto Update stats is a good one. I've never worked on a system that was big or busy enough that you would want to...
May 29, 2009 at 1:40 pm
Oooh, this sounds like fun.
What does a date look like if it is +? Is the "-" changed to a '+'?
I'd do the conversion like you are doing, then convert...
May 29, 2009 at 1:36 pm
Typically for a primary key you want to select the column(s) that uniquely identify the entity and that will be used to JOIN to that table. Also, I'd like...
May 29, 2009 at 1:14 pm
GilaMonster (5/29/2009)
Jack Corbett (5/29/2009)
Hey you folks who are going to write the book on indexing. How about helping this guy out?Why? You're doing a fine job yourself.
Thanks, but I...
May 29, 2009 at 12:55 pm
Hey you folks who are going to write the book on indexing. How about helping this guy out?
May 29, 2009 at 9:57 am
Sounds like you may not have the best clustered index key. I'd recommend reading this blog post by Kimberly Tripp as it does a good job defining what makes...
May 29, 2009 at 9:23 am
Viewing 15 posts - 4,951 through 4,965 (of 9,643 total)