Viewing 15 posts - 76 through 90 (of 194 total)
I'd start with server properties in SSMS and have a good old read here:
http://technet.microsoft.com/en-us/library/ms181453.aspx
'Only he who wanders finds new paths'
July 4, 2013 at 5:25 am
Sadly dont have a specific answer but would it be worth trialing the different monitors out there to see how they fit? We dont rely on one tool in...
'Only he who wanders finds new paths'
June 27, 2013 at 1:24 pm
NULL is basically unknown, so for example, 1 cant be not equal to NULL as we dont know what NULL is, for that same reason and perhaps more to the...
'Only he who wanders finds new paths'
June 25, 2013 at 7:52 am
I think the last couple of paragraphs sum it up perfectly!
'Although this gives you a lot more flexibility in controlling your database maintenance it would have been nice if they...
'Only he who wanders finds new paths'
June 24, 2013 at 8:10 am
No I havent ran the plan yet, I normally do them via a script (or manually in some cases!) checking page_count and fragmentation from DMV's.
Just wanted to know...
'Only he who wanders finds new paths'
June 24, 2013 at 7:46 am
WHERE firstname IS NOT NULL?
'Only he who wanders finds new paths'
June 21, 2013 at 10:43 am
There is a setting, which I cannot remember, where you have to specify the job to fail when the package does. Apologies I just cant think off the top...
'Only he who wanders finds new paths'
June 21, 2013 at 8:48 am
Is there error-handling inside the package trapping a potential error?
'Only he who wanders finds new paths'
June 21, 2013 at 5:44 am
Rather than looking to validate first, can you not use TRY...CATCH and then use ERROR_MESSAGE, ERROR_NUMBER for example?
'Only he who wanders finds new paths'
June 21, 2013 at 5:41 am
Quite often you will see things like NOLOCK to improve performance however the massive disadvantage of using it is that queries could well see inconsistent (lets say incorrect) data. ...
'Only he who wanders finds new paths'
June 19, 2013 at 10:33 am
ALTER DATABASE [dbname] SET ONLINE
'Only he who wanders finds new paths'
June 19, 2013 at 5:20 am
Thanks that was the part i was missing that by evicted a node in Windows, you didnt have to do anything in SQL.
Never had the pleasure thus far so wanted...
'Only he who wanders finds new paths'
June 19, 2013 at 5:16 am
I am a big fan of it but I am beginning to think that SSIS is possibly the root of all evil...
'Only he who wanders finds new paths'
June 18, 2013 at 12:41 pm
Apologies, I didnt see the 'source database' - had another thought:
Would it be possible to use a script task to populate a variable (or variables) which is then used as...
'Only he who wanders finds new paths'
June 11, 2013 at 12:43 am
Viewing 15 posts - 76 through 90 (of 194 total)