Viewing 15 posts - 4,291 through 4,305 (of 6,400 total)
duplicate post
replies here please http://www.sqlservercentral.com/Forums/Topic1331288-392-1.aspx
July 18, 2012 at 2:19 am
Try shrinking in smaller chunks rather than one big shrink and keep your eye on blocking and percent_complete from sys.dm_exec_requests.
July 18, 2012 at 2:16 am
Personally I would follow these steps.
Pause the passive node in the cluster
Perform the netbackup upgrade on the passive node
Test make sure it works
Uninstall/Reboot depending on above
Unpause the passive node
Fail over...
July 18, 2012 at 2:14 am
If you want to enforce unique ness, maybe a computed hyshbytes MD5 column based on the 17 columns would be the way to go
July 18, 2012 at 2:11 am
There are pros and cons to everything.
While the statement of better performance is true, it will only give you better performance if you have an IO bottle neck at disk...
July 18, 2012 at 1:55 am
The installation media comes with them all.
It is then up to you to decide what to install and where to keep inline with what licenses you have purchased.
July 17, 2012 at 7:58 am
You may want to refer to this http://www.sqlservercentral.com/Forums/Topic1232230-391-1.aspx
July 17, 2012 at 7:46 am
Well it has to be within that task then which is failing on validation.
What is the task doing, can you attach screen shots?
July 17, 2012 at 7:34 am
It looks like the SSIS package couldnt connect to Oracle, have you checked the connection managers connect as they should?
July 17, 2012 at 7:29 am
July 17, 2012 at 6:46 am
After reading a number of articles
http://msdn.microsoft.com/en-us/library/aa366796.aspx
http://msdn.microsoft.com/en-us/library/aa366778.aspx#physical_memory_limits_windows_server_2003
It would seem that Server 2003 Standard x86 supports by default 4GB which we all knew, with PAE it can address up to 64GB...
July 17, 2012 at 6:26 am
You cannot take a backup of the standby databases, you will need to take the backup on the primary server.
The only way to backup the DB's on 03 would be...
July 17, 2012 at 5:47 am
You would need to do a check on the variable to see if it is within the range of numbers allowed
Something like
DECLARE @variable INT = 8
IF @variable >=1 AND @variable...
July 17, 2012 at 5:45 am
No, there is no agent with SQL express.
If you want a SQL agent you will need a higher product, like Standard or Enterprise.
If you need to schedule tasks in express...
July 17, 2012 at 5:39 am
July 17, 2012 at 4:43 am
Viewing 15 posts - 4,291 through 4,305 (of 6,400 total)