Viewing 15 posts - 406 through 420 (of 599 total)
Run the performance dashboard reports and have a look at long running queries and missing indexes.
June 22, 2009 at 2:08 am
Is your machine at the same patch and service pack level as the server?
Was it saved as encrypt with user key by a different user or login?
June 19, 2009 at 1:10 am
Instances can also be useful if you have one server but need to pretend it's more! We have our development instance and our test instance co-existing happily on one server...
June 17, 2009 at 1:42 am
Our preference is to store a copy of the package in msdb because we can "Rely on server security" and save the connection details and passwords, especially good when importing...
June 17, 2009 at 1:29 am
I always use "Save copy of package as" from BIDS/Visual Studio and save to the SQL Server (msdb) and set the protection to "Rely on server..." and this saves all...
June 16, 2009 at 10:01 am
Check the component's properties and the "delay validation" option. Setting to true prevents validation before run time.
June 11, 2009 at 1:14 am
Having a dummy defensive position to attack, out in the public domain, is also not unlike the way
the M.o.D (UK Defence Department) carry on in Salisbury Plain. Perhaps we could...
June 5, 2009 at 8:32 am
Connection pooling and timeouts also come into play here - the connection can thus remain after a user has finished and - especially if you are using the same sql...
June 5, 2009 at 8:20 am
Steve,
The vast majority of the SSC Community truly appreciate your efforts, including any occasional errors that might be made. I would think that a "newbie" would have better things to...
June 5, 2009 at 8:05 am
Monday is the spring bank holiday in the UK and schools' half term break is timed to fit this, so much of the country is taking a short break away...
May 22, 2009 at 3:46 am
I'm over 50 and female and been in the software business for over thirty years but no, I think my best days are now because I have so much more...
May 15, 2009 at 5:25 am
The two jobs I've had in the last fourteen years have both come from the hardcopy ads in Computing. This despite using lots of agencies, computing and computer weekly online...
May 13, 2009 at 2:09 am
Personnally I have a computer science degree taken in the 1970's when they weren't very common. When I started with a software house as one of the new graduate intake,...
May 5, 2009 at 2:10 am
Greg thanks. You've answered something I've been needing to do for a while as my fellow developers need to manage jobs but not be sa and so far we've let...
April 23, 2009 at 1:20 am
VB every time - it's much more readable especially if you aren't into the C family of languages.
April 20, 2009 at 5:22 am
Viewing 15 posts - 406 through 420 (of 599 total)