Viewing 15 posts - 211 through 225 (of 3,232 total)
CirquedeSQLeil (12/2/2010)
Newborn
Is there a congrats in order?
December 3, 2010 at 9:36 am
Well, that doesn't sound good for you. If all user interaction is being done through the application and they say they can't spend DEV hours to change the app,...
December 1, 2010 at 4:49 pm
I'd monitor your SQL instance w/ profiler when you run your package and see if it is taking that long to execute the query against the DB engine or if...
December 1, 2010 at 4:42 pm
How are you getting a sum of 1000 for that? I think it would help if you gave an example of your table DDL, and a few sample rows...
December 1, 2010 at 4:38 pm
How are the users querying the data now? SSMS?
December 1, 2010 at 4:18 pm
What about the second column value of 625, how did you pick this one out of the possible values from within the ref 595 group? Do you want the...
December 1, 2010 at 4:17 pm
DECLARE @name VARCHAR(50) -- database name
DECLARE @path VARCHAR(256) -- path for backup files
DECLARE @fileName VARCHAR(256) -- filename for backup
SET @path = 'C:\Backups\'
SET @name = 'Your DB...
December 1, 2010 at 4:11 pm
You could use views that limit the data and only grant your users access to those views.
Another option would be to expose the data to your users via SSAS. ...
December 1, 2010 at 3:58 pm
I'm a bit confused as to the nature of the question. Outside of homework, I can't see where this would ever come up. What is your thoughts on...
December 1, 2010 at 3:07 pm
What about the obvious answer of changing the query to use the clustered index by removing the IN clause? The IN clause is treated just like a series of...
December 1, 2010 at 2:46 pm
Agreed. I would stay far away from using a script task for this. Use a data flow, compare the inputs as described by Strick.
December 1, 2010 at 1:48 pm
cold.....and snowy
Yes, Brandie, it's now cold here! 24 degrees w/ 20+ mph winds....14 degrees with wind chill.
November 30, 2010 at 11:29 am
Viewing 15 posts - 211 through 225 (of 3,232 total)